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

I have just checked and the SQL Service Account is currently the LocalSystem.

My understanding is that the LocalSystem has full rights to all local drives.

Does anyone else have an idea...

Nakul Vachhrajani (8/23/2010)

---

Hello!

Just a thought - I trust you do not have any white spaces in the database name - can you just give it a try (eg. you have...