The code is correct what I posted oops. Was something else causing the problem

Hey all,

Nothing to do with business, more diagnostics. Just wanted something quick and dirty - I guess a lazy way of checking.

Suppose a situation where you have a record...

Thanks Parul, that works fine.:-)

Michael,

All you need to do is basically store your command in a global variable.  You can create a global variable by right-clicking the background DTS designer of your package.  From the pop-up, select Package...

I came across a similar problem i had to achieve a few months back.

What I did was to setup an Execute Process Task to take the full command line parameters. ...

Thanks for the contributions...

It sounds like it would work off the top of my head although due to the massive amouts of tables that are referenced by the main table (about...

Also forgot to mention that we would remove ALL FK References before executing the SQL to do the update.  The FK Constraints would then be recreated at the end of the merge...

Forgot to mention that I copied the SQL from Step to into Query Analyzer which took 20 minutes to execute.

Ah cheers,

Just needed to remove the carriage returns...

REPLACE( Progress_Notes, CHAR( 13 ) , '' ) AS TheValue

You can use DATENAME function to do this.  This will do it for the current date.

SELECT DATENAME( year, GetDate() )

Or in a query

SELECT DATENAME( year,...

Thanks for that Tim.

Nice thinking...