Check out EXCEPT operator in BOL. Basic query would be this:

SELECT

Last_Name,

First_Name,

Birth_Date

FROM

dbo.TableA ...

Oops, you were probably thanking Gus as his explanation is much clearer than mine. You should still check out Lynn's blog though.

No problem. You may want to read and point dev's to this blog post by Lynn Pettis.

Okay here's a shot at it:

DATEADD(yyyy,([deliver_y] - 1900),'1/1/1900')

This takes the the number of years since 1900 and adds them to 1/1/1900 so for 2009 you get 1/1/2009. Which then...

Bwaaaah, ha, ha....

Just found a duplicate post for this one with more replies so please post replies here.

Also please don't duplicate post as it fragments replies.

Okay my reply is on this thread.

Here is a simple example:

DECLARE @retval INT

EXEC @retval = sys.sp_who

IF @retval = 0 -- success

BEGIN

PRINT 'Success'

...

Actually it only works great if you have single row delete. If you have a batch delete occur you will only get...

I'm not really sure what you are asking, but it sounds like you need to learn how to use a JOIN. Start by reading this article:

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

I don't know that there is a way to do this in SQL Server as the connection to SQL Server is by the specified user and the Web Server. ...

I'm not sure exactly what you want to do, but I do know that multi-column reporting is a weakness in SSRS.

Here are a couple of links that may help:

http://msdn.microsoft.com/en-us/library/aa179433(SQL.80).aspx

http://jagbarcelo.blogspot.com/2007/04/partial-multi-column-reports-in.html

In SSIS you would configure your source to use a Query instead of a table and filter the data in your query using a where clause.

From BOL:

Using float and real Data

The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE 754 specification on approximate...

It sounds like you are trying to use a single lookup to return the alternate key for 3 values and the lookup doesn't work that way. You will need...