Then the question is WHICH record do you want from table B? Do you want the first record, the last record, the maximum record?

SELECT DISTINCT will group by every field, so if all fields you are returning are the same on the 5 duplicate records, it will do what you want.

oh, and the T-SQL is really basic:

IF (datepart(month,@MyDate) < 6)

SET @MyDate = ...

ELSE

SET @MyDate = ...

Isn't today's date + 11 months - 6 months the same as today's date + 5 months?

Start by comparing them to the ones that are installed by default.

Your trigger logic is thinking you are dealing with one record at a time. Remember that the inserted table can have multiple records so you need to do a...

Sorry to say that every migration is different. Even if you had a nice step-by-step example of a migration, it is going to be different from your environment and...

1) Databases / tables - you should have no issues. Everything from 2000 is supported in 2005

2) Views - assuming you did not use some really old query syntax,...

Your report server uses some css files during rendering. You should find them in the reporting services install folder on the report server.

Right-click on the source component and open the advanced editor. Go to the inputs and outputs and look at the configuration for the field giving you the error. ...

Look for a messed up css file.

Also take a look at your referential integrity. If the table you are deleting from is the PK side of a foreign key relationship (a record must be in...

Like Steve said, processes sometimes get "stuck". I have not seen this happen more or less in clustered environments. The only thing I have really noticed is that...

I do this fairly often and I typically just have a two field table - one with a unique variable name, and one with a variable value stored as some...

You are posting this in an SSIS forum.

If you want a non-SSIS solution, I suggest you post this in a forum related to batch files or .Net programming. This...