Batches are terminated by the GO command.

See: http://msdn.microsoft.com/en-us/library/ms188037.aspx

You should avoid joining on different data types if you possibly can.

If you use cast() in the join, at least everyone can see what's happening. An implicit cast is...

Its about covering indexes. If a query only uses those 3 columns, SQL Server may use the index to get the data & not look at the table at...

It's because the seek doesn't use Id, & Id is the first column in the index.

An index can only be used for an index seek if the key to seek...

Have a look at my post on this thread - it's a similar problem:

http://www.sqlservercentral.com/Forums/Topic1366725-391-2.aspx

I think this does what you want - ie shows users who haven't taken all curriculums, & a list of curriculums they haven't taken:

--========== TEST DATA ======================

if object_id('[dbo].[Curriculum]') is not...

This might be what you want, but I'm guessing on the join:

--=========== TEST DATA ===========================

-- Reset all NOT NULL to NULL...

--Source Table:

if object_id('[dbo].[CMC_BLCO_COMM_ITEM]') is not null drop table [dbo].[CMC_BLCO_COMM_ITEM]

CREATE TABLE...

What's the link between the two tables? You need to know which record to update.

--I am trying to get mtd, yesterday and previos month data in 1 table.

--Can someone please help me..

--===== TEST DATA =========

declare @a table

(Id int, OrderDate DateTime, OrderQty int...

How are you trying to reference the local server?

This will work in 2005. Only the test data has changed (& variable declaration).

Please note: You should post on a 2005 forum for 2005 answers 🙂

--===== TEST DATA =========

declare...

You should always specify...

What version are you using?

I read this as 3 being a later record than 2.

The...

This works for the test data. It picks up values from the 3rd row if the 2nd has nulls too.

--===== TEST DATA =========

declare @Person table

(Id int, Name varchar(20),...