Topics
Started by
Posts
Last post
I need to get the users loginame, who is running the SP from within the SP how you do you do that i…
3 replies
Does anyone know of a set based T-SQL solution to insert data into a parent table and related data …
9 replies
I have a trigger on a table that is slowing performance down when mass inserts are done against the…
9 replies
How can I get the maximum value in a group? Here I have this: SELECT A, B, C, MAX(F) FROM TblX X …
6 replies
Hello All, I need to write a Stored Procedure to interface data between 2 tables in SQL Server 2000…
5 replies
I wrote a code for that But i got many syntax errors and may be logic errors too i am beginner in S…
3 replies
Is there a way to catch @@ERROR = 1222 but to suppress the fact that it has happened so calling rou…
8 replies
Hello all, I have a stored procedure with a series of update statements. --Update statement 1 UPDAT…
3 replies
Hi have a table that I want to put the data of multiple columns into a @Body variable so it can be …
4 replies
This block is a real bottleneck in my query: SELECT I.COBDate, 'CAD+CSW' AS RiskIdShortName, CAST(R…
2 replies
Question. If one of the criterias in my WHERE clause returns false does it mean that the time spent…
2 replies
Given two tables ... Table_A ID int Data varchar(25) Table_B ID int field_b int …
4 replies
I have the following data in my table number name city value 1 aaa bbb ccc;ddd;lll;…
2 replies
I have indexes in place that was built looking at the execution plan of the query. This is the moth…
4 replies
Hello, I outputted a query results in Grid and saved as CSV (comma-separated) file. When I open thi…
34 replies
Viewing 15 topics - 1,336 through 1,350 (of 17,082 total)
You must be logged in to create new topics.