Topics
Started by
Posts
Last post
Hi, I am trying to implement a system wide error handle sproc that will be called in the BEGIN/END …
2 replies
I need to update 40 fields in table1 (400,000 records) using data from table1. I am using SQL serve…
6 replies
Hi I have got two tables named "Config" and "Config Values". The fields in the "Config" are ConfigI…
9 replies
Can someone tell me why am I getting error mssg as following Msg 156, Level 15, State 1, Line 10 In…
3 replies
I have create a set of triggers which updates information in an external database on the same serve…
2 replies
All, I am not very good with T-SQL, although I am learning. I have a query that I am trying to wri…
13 replies
Hi, I am having the following table Contacts --------- Contactid, ContactName Emailaddress --…
6 replies
Hello I need to display the teams standings of a hockey league. Seems pretty easy but it's not. …
1 replies
Hello guys, I want to monitor replication using sp_replmonitorhelpsubscription system proc. So want…
10 replies
Hi all, I have the following structure and data as a sample: --Build the structures if exists (sel…
2 replies
/*1st, me create as follow*/create type Date from dateTime create type Time from dateTime /*2nd, m…
9 replies
I have a block of code in my stored procedure that allows for dynamic ORDER BY. However, I cannot …
3 replies
Hello All, I have a SP which copies records from a table to the same table with new ItemID where ol…
1 replies
I’ve written a common table expression that combines complex information on staff movements, allowa…
11 replies
Hi, Hopefully someone can help me find the best solution to my problem. I have a report that a user…
3 replies
Viewing 15 topics - 4,246 through 4,260 (of 12,230 total)
You must be logged in to create new topics.