-- I would use dynamic SQL

-- Just take the PRINT statement out when you are done testing

-- Good Luck!

CREATE PROCEDURE spUpdateLookupTable

@Isbn nvarchar(10),

@uvalue int,

@fieldName nvarchar(50)

AS

Declare @isbnCount int, @sSQL varchar(2000)

Select @isbnCount=Count(Isbn) FROM...

Here is a line I use to set the date to the Monday of the current week:

SET @LockDateBegin = convert(datetime,convert(char(10),dateadd(day,(2 - datepart(weekday,getdate()) + round((1.0 / datepart(weekday,getdate()) - 0.1),0) * (-7)),getdate()),101))

To...