Topics
Started by
Posts
Last post
Hi, I have a table which includes servernames and status . CREATE TABLE #Time (Date DATETIME,Status…
3 replies
Please see below cursor which produces my required results. It returns one row per customer with al…
4 replies
Posted - 12/23/2013 : 18:25:50 Show Profile Reply with Quote Here is my Test Data, Please any ad…
14 replies
A third party vendor has given us read access to an audit table, allowing us to review historical c…
5 replies
Hey all, I am trying to figure out how I can use SQL to search through a table of employees and the…
2 replies
I'm doing some maintenance work on a client's VB6 system. I've written a new stored proc as follow…
1 replies
Here is the data... StartDate........EndDate..........Condition -------------.....--------------...…
5 replies
I need to update a sequence number that is used to display a list. The order is not crucial except …
4 replies
Can someone tell me what the following statement is doing?? IF ISNULL(@category, '') = '' I underst…
56 replies
Table 1 : custemaildim emailADDr |||||| SendSurvey some@gmail.com|||||| N exam@gmail.c…
1 replies
Hi , I Generate reports using Database Mail. By default the alignment for columns in the Table is …
7 replies
This code is to perform a Soft Delete. It deletes a record first. If the delete was successful, rol…
3 replies
tblParent pid(int) name deleted(bit) 1 abc 0 2 def 0 tblChild cid(int) name pid(…
3 replies
I have trigger after Insert that update field in the table with GETUTCDATE() but after Insertion I…
6 replies
Hi All. I have a TABLE "TABLE1 " with column STARTDATE and Data Type DateTime2. It has value of '00…
2 replies
Viewing 15 topics - 2,656 through 2,670 (of 10,635 total)
You must be logged in to create new topics.