Topics
Started by
Posts
Last post
I have a SP that has 3 parameters getservicecontractsinfo 'ALL', '2009-09-01', '2009-09-30' I want …
2 replies
I've got two tables; one for order and another for order details The basic structure is order (orde…
3 replies
Some of our procs use != within where clauses. Can someone explain the difference? example: …
3 replies
Hi, We have table which is used frequently(it gets inserted/updated about 300times a day, being hal…
1 replies
I currently have a stored procedure that uses a view to do inserts in to another table. The sql for…
1 replies
I have a table called Machine with a primary key MachineId. Each machine has attributes such as se…
6 replies
Hi, Can we have IF condition in cursor, after FOR something like below: DECLARE vendor_cursor CUR…
40 replies
hi all, please help. Im trying to write a SProc that receives optional parameter to retrieve data f…
9 replies
hi, Can anyone give me the query to get the date which is 4 days back. Say current date and time is…
2 replies
Hi all, Today I came across an old procedure which has a number of input parameters, approx 30 , ho…
3 replies
Hi, I have an SP that return an SELECT FOR XML RAW. What I want is to re-use this SP calling inside…
24 replies
How would I insert the dates of the current month 2009-09-01, 2009-09-02, etc, etc, into a sql tabl…
5 replies
Hi all i have connecting two databases in different servers using the following statements: IF EXIS…
11 replies
Hi Experts, Is it possible create an identity column such as the attached. i.e if the 1st row is on…
9 replies
Has broken group on two subgroups. ___________________________________________________________ 1,11…
8 replies
Viewing 15 topics - 5,461 through 5,475 (of 12,231 total)
You must be logged in to create new topics.