Topics
Started by
Posts
Last post
Hello all, It's been some time since I've written a recursive CTE and I'm having a difficult time. …
9 replies
Hi guys, here's a question that needs an answer. I have 2 sql 2005 databases. Inside the first one …
5 replies
At the moment our client system update record Created_Date and Amended_date fields from the users s…
4 replies
Hi all, Could you please help me to move data from one table to another? It's a bit tricky. a. Tabl…
3 replies
how would i write this, i have two records for every customer first time ID=1, second time ID=4 so …
7 replies
I am calling a stored procedure from another stored procedure with the code below. Set @sql = '[' …
2 replies
Hi there, Is there a way to export result set of temporary table to another format like flat file,…
11 replies
Im trying to optimzae my coding and just wondering if its ok to do most of my filtering conditions …
3 replies
Why I'm getting this error It occurs when I try to add the name or type_desc fiels I've tried cast…
3 replies
Hi, can you guys tell me which is the table to view whether particular job schedule is enabled or n…
1 replies
I need to concatenate at least three columns from a row but if the value of the column is 'Please S…
3 replies
what is an example of duplicate key object when i try a insert into a table i get the error: Violat…
8 replies
I have a large table that is made up like this 1st Record with header information 2nd - 10th detail…
19 replies
How do I write a stored procedure that inserts if record is not there and updates if record is ther…
61 replies
Hi, i have a sql which works: select [Customer No_], sum(Amount) as Balance from [Detailed Cust_ Le…
6 replies
Viewing 15 topics - 8,326 through 8,340 (of 12,234 total)
You must be logged in to create new topics.