Topics
Started by
Posts
Last post
How can i do multiple updates in a single cursor with better performance. I know the systax below i…
10 replies
I have a performance issue with a stored procedure that contains correlated subqueries that get dat…
21 replies
Can someone please help me extracting the below one? <Return> <SOURCE PROCESSSTATECODE="30…
2 replies
This a the basic statement USE master; GO SET NOCOUNT ON; GO DECLARE AllDatabases CURSOR FOR SELECT…
14 replies
I am in the process of re-developing my application for my customers and I want to loop through all…
15 replies
Hi.. I have observed the difference in execution plans when i m trying to execute the same stored p…
13 replies
Can anyone please tell me what the below where filter is doing? select TargetSafetySockQty from SSI…
12 replies
A report has been running happily for a while. Today a user reported an error. It transpires there …
5 replies
In SQLSERVER 2005, I'ts possible execute files from a files.sql? Like sqlplus : --- install.sql @p…
1 replies
Nevyn helped me big time on the script below and thank you for that. I was wondering if the script …
1 replies
Hi All, If I have a stored proc and I SET NOCOUNT ON and later on I also EXEC some dynamic SQL do I…
4 replies
Greetings SQL Gurus, I have a quick question. Anyone know how, or if it is possible, to pass a case…
3 replies
Hi All, I have a bit field column (confirmed) in a table, which can take true,false or null. I want…
2 replies
Hello, I am creating a UDF to enforce a business rule: CREATE FUNCTION [dbo].[UDF_IsValidEntryDate]…
14 replies
here please refer the table: in that table value: 1 is Order No ABCL is Client Name 12/1/2009 12:…
6 replies
Viewing 15 topics - 3,211 through 3,225 (of 12,234 total)
You must be logged in to create new topics.