Topics
Started by
Posts
Last post
I know this is very silly thing but i am kind of lost. sometimes 2 + 2 = 5 happens script is like t…
14 replies
qwer
1 replies
I get this error when trying to run this query: Subquery returned more than 1 value. This is not pe…
6 replies
Hi, Greetings of the Day!!! I have two different servers. I have to write a query to select data fr…
5 replies
Hi all, I am using 2 DB's one is in 2005 and other is in 2008 both are same only the sql server ver…
3 replies
hi i have one column in which i need to do sum for every id and then i need to do total of that sum…
36 replies
i need to do gradntotal , i created UDF(scalar),but i cannot include in select statement coz of whe…
20 replies
Hi all - I was just looking through the Adventure Works database and found this trigger. I underst…
1 replies
For each ID/Sub ID combination where complete=0, I want the first value for location. ID SubID…
26 replies
Hello all, I have a 'TIME UPDATED' field I need to include into reporting but the value, eventhough…
3 replies
I have ETL process that utilizes fast load merge statements by turning on trace flag 610. I do thi…
2 replies
This is a challenge that I haven't mastered yet, and I've been writing SQL for a long time. There a…
7 replies
Hi all, By mistake one of my colleague deleted all record from a table, he forgot to put where cond…
5 replies
[font="Courier New"]In search of SQL to Create a VIEW which will display distinct rows from a table…
3 replies
Hi, I am trying to run a query against each database, which has a particular column: EXEC sp_MSfore…
12 replies
Viewing 15 topics - 7,471 through 7,485 (of 10,635 total)
You must be logged in to create new topics.