Topics
Started by
Posts
Last post
I have a lot of Stored Procedures that use a Merge statement. I need to capture aggregate counts (I…
2 replies
hi all can i join more than 2 tables. i means in union, we can union more than 2 tables sele…
5 replies
please advice me what is the actual difference between union all and full outer joins? i know its s…
5 replies
hi please explain me where to use right outer join and left outer join. i referred many articl…
6 replies
Hi, I am having a query containing three unions. But i want to compulsory execute 1st query rest tw…
2 replies
I have 2 tables: dbo.Doc_activity and dbo.event_type CREATE TABLE [dbo].[Doc_Activity]( [Entry_Id]…
11 replies
hi i want ot know date function ,that gives last 5 year date. i have 1 param declare @todate dateti…
2 replies
I have a query that runs on 4 different databases and they are virtually identical. All the databa…
3 replies
Does anyone know how the BCP utility functions behind the scenes? I am using it for a query out exe…
6 replies
Hi I want to retrieve date from description. Following is the code I am using it now,But I have to …
1 replies
HI. I need a date table that has all the dates from 2000 till today. the Table should look like as…
11 replies
Hi all I’ve been using this brilliant solution for FIFO calculation that is found here, (Dave’s one…
5 replies
How can I update multiple values in 1 table based on the values from another table, do i need to us…
15 replies
Hi Gurus, Could you please tell me how to prepare a demo database for sales team? I have to write …
9 replies
I am working in an SQL Server 2008 R2 environment and I wish to add a routine to my T-SQL script th…
4 replies
Viewing 15 topics - 5,986 through 6,000 (of 10,635 total)
You must be logged in to create new topics.