Since this is a backup you are trying to run, here is another option:

declare @dbname varchar(128),

@filedate varchar(64);

declare @diskfile varchar(256) = 'H:\Preupgrade\Backups\' +...

This is what you are trying to accomplish:

declare @dbname varchar(128) = 'TestDB',

@filedate varchar(64) = '20121214210000',

...

prabhu.st (12/14/2012)

---

Hi,

I have a xml like this.

<DocumentElement>

<tLockhistory>

<lockrequesteddate>2012-12-14T00:00:00+05:30</lockrequesteddate>

<lockexpirydate>2012-12-29T00:00:00+05:30</lockexpirydate>

...

Could you post the DDL for your tables, some sample data (INSERT INTO statements), and expected results based on the sample data? This would really help us help you.

Made a few mods with my code. Inserted the sample data into a temp table, zeroed out the ConsecutiveD column, modified my code to use the temp table and...

10e5x (12/13/2012)

---

Hi Lynn,

Firstly, i am sorry, Lynn.

Secondly, i am using SQL Server 2005

Lastly, that sentence is the entire error sentence. It appears when i click the ! functions in query...

10e5x (12/13/2012)

---

Hi lyn,

I tested your solutions and it works. However they keep prompt me "the OVER SQL constructs or statements is not supported". I just ignored that. Do u...

First, you didn't ask for an SSIS solution, you asked for a SQL solution.

Second, use the right tool for the job. This isn't a job for SSIS, it is...

Just another option to consider, think of it as food for thought:

with TestData as (

select

PassM,

cast(EnterDt as datetime) EnterDt,

ConsecutiveD

from

(values

...

I'm not a betting man, as I have said on many occasions, "On any given Sunday." I'm just asking what others think may happen this weekend.

Even during the regular...

Okay Everyone, don't forget to get your lineups in before gametime tomorrow if you have anyone playing Thursday night.

We are going into the semifinals, anyone want to hazard a guess...

It would help us if you could post the DDL for the table(s) involved, sample data for the tables, and expected results based on the sample data.

tom.moore.777 89426 (12/11/2012)

---

The user has the same permissions as other users who are able to see 'Script View as'.

They can even script out other objects (Tables, Functions, Stored Procs etc),...

What permissions does the user of the database you are using have?

Here is an alternative. Restore the the full backup with NORECOVERY, retore all the log files except the last with no recovery, restore the last log file using restore...