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...

You could try comparing the nvarchar string to the string cast as varchar.

DECLARE @str1 nvarchar(20)

,@str2 nvarchar(20)

SELECT @str1 = N'AB' + NCHAR(12354) + N'CD'

,@str2 = N'ABCD'

IF @str1 <> CAST(@str1 AS varchar(20))

PRINT...

You can use the group by order difference technique to get the ranges followed by the stuff xml technique to roll them up.

-- *** Test data in comsumable format ***

--...

I am glad the order difference technique worked but unfortunately I cannot claim credit for the idea. The technique was used to win a competition but I cannot remember the...

I have just had time to look at this again.

To allow for when a book is not on loan try using a numbers/tally table.

(I am just generating the numbers table...

I think the order difference technique should work well here.

Try the following and let me know how it performs:

;WITH BLOrderDif

AS

(

SELECT *

,ROW_NUMBER() OVER (PARTITION BY BookID ORDER BY LoanDate)

- ROW_NUMBER()...

-- *** Test data in consumable format ***

-- You will get quicker results if you provide this

CREATE TABLE #t

(

Cust_ID char(15) NOT NULL

,[Year] smallint NOT NULL

,[Month] tinyint NOT NULL

)

INSERT INTO #t

SELECT...

Also, the trunc and sysdate functions suggest this is an ORACLE query.

Does this work?

SELECT *

FROM X

WHERE HistoryID = MAX(HistoryID) OVER (PARTITION BY [ObjID])

I would look at using both.

ie Filestream for files greater than 1MB and varbinary(MAX) for the rest.

I would also put the table with the varbinary(MAX) column into it's own file/filegroup.

Steve - thanks a lot for your help.

When I copied the files to another server and tried to restore there was no problem.

I then tried on the new server and...