Topics
Started by
Posts
Last post
Really easy question: How do I write a SQL statement where I want one field unique (MasterCodeID) b…
3 replies
I have this query below: Select Count (DISTINCT providerlink.PLid) FROM workrequest, providerlink W…
10 replies
Other than moving this to a faster IO, or partioning it, or moving indexes to different spindle,&nb…
23 replies
Hi gurus, Can you please help me in finding all the weekdays of a given month and a year. …
42 replies
Hi there, I would like to output the results of each cursor row into a separate file for the f…
7 replies
Please help! I am troubleshooting a stored procedure that inserts data from a linked server …
5 replies
hi guys, How we can generate a unique serial no in a distributed system. The tables are replicated …
3 replies
Hello to you all, I've got 2 tables : Table A has a lot of proces data, each time a product …
2 replies
We are want to call a stored proc using the fully qualified name, however we want to be able…
18 replies
Hello, The following programme runs fine in SQL 2000 and failing on 2005. Error is in subject line.…
10 replies
Hi I have a stored procedure which executes a series of statements inside a transaction. I&nb…
5 replies
I have a problem about passing parameter to stored procedure. Suppose the procedure like that: Cre…
3 replies
Need some help from the pros. I am probably over-thinking this and making it more complicated…
3 replies
Hi I am using a bcp command within a stored procedure to output some data to a text file for import…
2 replies
How can I combine this into one query? select count(*) from table1 a left join table2 b on a.id = b…
1 replies
Viewing 15 topics - 4,636 through 4,650 (of 17,082 total)
You must be logged in to create new topics.