Topics
Started by
Posts
Last post
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
hi, How to find the file name in the folder if it exists or not.Daily text file is coming in …
6 replies
Question # 11: Create a loop to go through the products table ordered by productname . for each pro…
20 replies
I have requirement. I want use 'xyz' where ever null data is existed in the column query is select…
12 replies
Hi, I have a queries to read a simple text file. I want to read only end of line at that file. B…
2 replies
Viewing 15 topics - 7,486 through 7,500 (of 10,647 total)
You must be logged in to create new topics.