Hi there
Thanks for ther reply, although it errors with:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.
Msg 156, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'AS'.
Im probably doing something stupid! Im using SQL Express 2005 if that helps...
Cheers
Mark
Main Topics
Browse All Topics





by: Sharath_123Posted on 2008-11-18 at 00:03:28ID: 22982705
replace your statement with MERGE statement.
Select allOpen in new window