Topics
Started by
Posts
Last post
Hello, Please let me know how to retain the + symbol and truncate the decimals from the following. …
3 replies
Hi, Here is the scenario - Table QALS has Fld1, Fld2, Fld3 ( Records 10K) Table QAVE Has Fld1, Fld…
4 replies
I have two tables I'm working with. They are Crazy. Their names are [mentor table] and [Mentor with…
4 replies
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
Viewing 15 topics - 5,461 through 5,475 (of 12,234 total)
You must be logged in to create new topics.