Yes. You can also use @@IDENTITY but that will not always guarantee you about the integrity of the IDentity value where as SCOPE_IDENTITY() is more reliable.

Do you mean formatting it from a front-end application ? or just in QA ? If its the latter you can right click on the selected portion and use the...

>> I've been working...

You can use a autogenerated identity column and use SCOPE_IDENTITY() to get the identity value from the last insert within the current scope. Check Booksonline for more info.

You can get both the resultsets into 2 table variables ( or temp tables) and do a select from tableA where NOT IN...tableB ( or viceverca)

And how do we contact you Mr Andrew ? Can you also tell us the location of the position ?

you can do something like :

select @a=col1, @b-2=col2,@c=col3 from yourtable

update YourTable

set col1 = case when @a = @newa then @a

else...

may be the value thats coming in is not right..check that.besides that i dont see anything wrong with the code..

hth

ALTER      VIEW [dbo].YourView AS

SELECT [id],Child1 FROM Table1

can you post the line where he is calling the other stored proc? its most likely a syntax error and nothing to do with variables..the variables have scope of the...

i think its up to 8000.