Topics
Started by
Posts
Last post
i have two tables with that can be joined together on a single column key ,, with 1 to many relatio…
28 replies
I need this for my monthly report. Any help is greatly appreciated. /* Schema */DECLARE @MyCalls T…
10 replies
We want to make sure a sequence number is uniqe on a given date. However our date is sto…
5 replies
I need an SQL statement that will return a single row from two tables. The problem is there is a 1 …
4 replies
Hey all, I have code that I'm kinda confused to transform into a cursor, make it dynamic I guess. I…
13 replies
Hi all, I have a standard orderdetail table which contains the fields: customer,product,dated,qty a…
29 replies
Please help! I tried to delete data from 5 tables from linked server. I got 4 succ…
2 replies
Hi to all, I have some doubts on calculating years, month and days between two days in Single sql q…
2 replies
how do you display multiple rows in one single row?
1 replies
My code is as follows: EXECUTE sp_makewebtask @outputfile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.…
4 replies
I have a database table with 15 million rows of data. In this table one of the columns dataty…
11 replies
I there a way to get the column name from a temporary table? SELECT COL_NAME(OBJECT_ID('#temptable'…
6 replies
Hi, I was wondering if someone has an explanation for this. We got a following error on the …
17 replies
Hello, I'm Moveing a bunch of rows that I scripted out from a Production Database to Test and I am…
3 replies
Hello, I'm Moveing a bunch of rows that I scripted out from a Production Database to Test and I am…
1 replies
Viewing 15 topics - 9,541 through 9,555 (of 17,082 total)
You must be logged in to create new topics.