For starters, get your close paren from the end of the expression to the end of the cast function...

SELECT SUBSTRING(CAST(date AS NVARCHAR(11)), 1, 10)

..and then explain (as pam asked) the...

..as well as ddl & sample data...

right - just to clarify - sql server creates a table called "Deleted" that temporarily stores the deleted row(s)...so that's the one one you need to select from...

I cannot believe you started just a couple of years ago...If I had even a tenth of your talent I'd quit my job and waste no time in making this...

Yes - the limit in EM is 1024..but no one really uses EM for data modifications..

- you're right...it's only a matter of ratio these days...instead of 6 of one and half a dozen of the other..you could...

could you please provide some more info ?!

1) does it happen at the same times/days each month ?! is there a pattern ?!

2) any triggers on the table ?! or...

Concur! If anything, I have only seen the "excessive pride" where people turn into prickly pears (have been guilty of that myself at times.....

Sorry to ask this but..

if you print your @Assignbuyer you do see a value other than 1 ?!?!

also...your assignment to @SI should be corrected to:

SET ......, @SI = specialInstructions...

splly. DATENAME..

SELECT DATENAME(mm, getdate()) AS Month,
 DATENAME(yyyy, getdate()) AS Year

hey..hey..go easy...I, for one, belong to the "developer" world and wouldn't trade places with a dba...

Here's the (much read) link that'll unravel the mysteries of dynamic sql for you..

the curse & blessings of dynamic sql

Right...here's how you would do this:

Set @rowlimit = 10
exec('select top ' +  @rowlimit + ' col1, col2 from myTable where...')

You could do something like this...

Set Rowcount @rowlimit  

select col1, col2 from myTable where...

...Great catch!...not so hush-hush after all...stopped believing in coincidences many years ago..