I have a date field of type datetime in a table.

But while I'm creating a...

Your column names are still pretty vague and I'm trying to figure out why the...

Thanks for all the replies I realized that its much easier to edit the select...

Hello All,
I'm trying to find a method that will run on Data-sets of 100K rows...

Hi All

Bit of a mental block, probably from looking at this a bit to much,...

Hi,

I have a table - TagDetail - that stores the many-to-many relationship between Tag, ParentTask,...

Hi,

Sample data to play with

Declare @vendor table(IdVenor int,MessageId int);
Declare @vendor_customer table(IdVenorCustom int,MessageId int);
Declare...

I have a sub-set of customers :

CREATE TABLE #temptable ( [ID] int, [Mobile] nvarchar(20),...

Hi Expert,
I tried to create a table with foreign key but I am not sure...

I recently found a non-ANSI select statement with equal joins executing against a SQL 2012...