Topics
Started by
Posts
Last post
Hi, I have a table where I want to return rows based on two scenarios given below : CREATE TABLE #N…
5 replies
Hello, Can you please help and let me know why the next select with @start_date and @end_date doesn…
2 replies
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
Viewing 15 topics - 2,656 through 2,670 (of 10,647 total)
You must be logged in to create new topics.