EmployeeId

TABLE AUDIT:

CREATE TABLE [dbo].[tblAudit](

[tableid] [nchar](10) NULL,

[employeeid] [nchar](10) NULL,

[tablename] [nvarchar](50) NULL,

[fieldname] [nvarchar](50) NULL,

[oldvalue] [nvarchar](200) NULL,

[newvalue] [nvarchar](200) NULL,

[changedate] [nvarchar](200) NULL,

[userid] [nvarchar](200) NULL,

[username] [nvarchar](200) ...

You're a sweetie. I did have a condition on the upd and del tables but removed to strip down code.

CREATE TABLE [dbo].[tblEmployeeId](

[EmployeeId] [nvarchar](100) NOT NULL,

[SSN4] [nchar](10) NOT NULL,

[SSN5]...

Hmmm! I never thought about that. Well right now I have to get it working and I'll have to remember to turn off trigger if batch update. Currently, the...

I am a vb.net programmer havee never had to use dynamic SQL or Triggers or cursors (and never been at a company which used them). So I am...

I realized that error when I got from lunch. Corrected I still got the error:

Incorrect syntax near the keyword 'select'.

This is what I come up with following examples on MSDN:

declare @tmpOldQuery nvarchar(200)

declare @ParamDef nvarchar(200)

declare @rtnVal nvarchar(200)

SELECT @tmpOldQuery = N'select @rtnVal = ...

Thank you. That helped. Now to put it back in context, how can I accomplish assigning the scalar value returned from the select statement to a variable:

set @mySQLString...