QUESTION POSED ON: 17 March 2006
Can you tell me what is wrong with this query? I'm getting the following error:
Server: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'where'.
Here's the T-SQL insert Into tbl_ScannedFiles (Folder, Path, FilName, DMIS, Loc, LName, SSN, PatCat, RegNbr) Values '\21cshfolder', '\fullpath', 'FileName', '0109', 'IZ', 'TATE', '475527006', 'A99', '1234567') where NOT EXISTS (SELECT * FROM tbl_ScannedFiles WHERE FilName = 'FileName')
|
