Master.dbo.spt_values is alright for quick queries but for production code I would be inclinded to generate a Numbers table in the relevant DB.

WHERE N.type = 'P' AND N.number BETWEEN 0 AND 29

It is best to search on a range so that there are no functions on J.JobTimeStamp, making it SARGable:

-- either

SELECT DATEADD(d, DATEDIFF(d, 0, CURRENT_TIMESTAMP), - N.number) AS MissingDate

FROM [master].dbo.spt_values N

WHERE...

Given your table definition, this should generate some usable test data:

SELECT TOP (100)

'UNION ALL SELECT '

+ CAST(ID AS varchar(20)) + ' AS ID,'

+ CAST(MainID AS varchar(20)) + ' AS MainID,'

+...

C# Screw (11/5/2010)

---

Not Quite!

simply locking the row would have been fine.

This I could do in my FoxPro days, but in SQL it seems that at least a page locked.

For example...

Here is a CLR function which could be used in Sergiy's code:

http://www.pluralsight-training.net/community/blogs/dan/archive/2006/07/27/32597.aspx

or if the operators are simple enough, just use the XML capability.

WHERE ColumnA LIKE

CASE

WHEN @Type = 'TWO' THEN N'%' + N' 20-' + N'%'

ELSE N'%' + N' [3-4]0-' + N'%'

END

It is a very good plan...

The following gives an example of the sort of code you need to be careful with:

http://en.wikipedia.org/wiki/Snapshot_isolation

As a concrete example, imagine V1 and V2 are two balances held by a single...

While snapshot isolation can be very useful, you should google 'write skew anomolies', check your code and do a lot of testing.

The classic way around this is to add a nonclustered index for the FK check to use.

Something like the following should work:

ALTER TABLE test1

ADD CONSTRAINT uq_test1 UNIQUE NONCLUSTERED (a)

You can enforce this without triggers by...

http://sqlblog.com/blogs/paul_white/archive/2010/10/19/sequence-tables.aspx

UPDATE generatepk WITH (UPDLOCK)

SET ...

may help, especially if you are using SNAPSHOT isolation.

Ouch!

One cursor in a trigger is bad enough, but three!

Also, two of your cursors are not being closed correctly and I doubt

if SUBSTRING(CONVERT(VARCHAR(30),CONVERT(DATETIME,@vtimetablestartfrom),110),1,3) = SUBSTRING(@SWV_NEW_DAY,1,3)

will work as it looks as...