JacekO (3/12/2009)

---

Lynn,

If I am not mistaken the SAVE POINTS still does not provide you with an option to nest. It allows you to rollback to a certain point but...

Here is some test code. Let me know if this helps.

declare @teststr varchar(20);

set @teststr = 'p_a3c_master';

select

@teststr

where

@teststr like '__[A-Za-z][A-Za-z][A-Za-z]%';

set @teststr = 'p_abc_master';

select

...

Regarding transactions, you can use SAVE POINTS to avoid ROLLBACK undoing all your work. You can do this to nest your transactions, and yet ensure that some of the...

Or:

declare...

Here is some test code for you to work with:

create table #Temp (

Column1 datetime,

Column2 datetime null

);

insert into #Temp (Column1)

select '2009-03-12 07:00' union...

Really comes down to six and half dozen the other. Personal experience on my system at home had fewer larger cross joins ran faster when I wanted millions of...

Bob Hovious (3/12/2009)

---

You are absolutely correct. When asking for more information, I just asked for complete text of errors,...

Yes, you really should do each backup to a separate file. If you are appending backups to the same file you have to specify which file to restore from...

Here is another solution:

with

a1 as (select 1 as N union all

select 1 union all

select 1 union...

Please post the code you used for both your backups and restores.

How are you looking for elapsed time to be returned? Not knowing your data, I don't know if I need to worry about elapsed time going over 24 hours...

Not sure why that would give you a problem, you are using varchar(max) in your...

The other alternative put a where clause on your inserts that checks for the existance of those three values existing in the database already.

You can also drop the NOLOCK hint. It is ignored any way on INSERT, UPDATE, and DELETE statements.

How about trying the following code:

create function dbo.DelimitedSplit (

@pString varchar(max),

@pDelimiter char(1)

)

returns table

as

return

with

a1 as (select 1 as N union all

...