Topics
Started by
Posts
Last post
Help required please. I'm trying to write a procedure to dynamically create a non-partitioned table…
2 replies
When I run sp_tables with no parameters on about 1700 tables it takes less than a second. When I ru…
3 replies
Hiya, Is there a way to handle multiple different values, but treat them as the same. I.e; NO | …
9 replies
My tables as following, USE [TUNEDB] GO /****** Object: Table [dbo].[xtApplicantQuota] Script D…
5 replies
I have a table such as the following. Aşağıdaki gibi bir tablom var .(Turkish) BIRTHDAY …
9 replies
Hi, I want to insert 100 rows like (1,2,3,4,..100) without using loops into a table using CTE. can …
39 replies
Hi all, I have stuck with some freaking problem.... Following table which i have to deal.... [Sessi…
2 replies
hi i have unique identifier field in one sp, that i need to pass into another sp. when i copy past…
9 replies
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
Viewing 15 topics - 5,986 through 6,000 (of 10,647 total)
You must be logged in to create new topics.