Not have tried to restore a copy only backup, ever, the only suggestion I have is to script it manually and see if that works.

That one is easy, you make a slight change to the INSERT to the second table like this, based on my sample code earlier:

insert into dbo.TestTab2

select

TestID,

...

notes4we (3/24/2009)

---

I figured out one more question.

What if I have similar ID's for two rows.

For some instances, I have same ID's.

Two rows having one ID. I wish to group by...

I don't admit to Solaris often. The systems are expensive (even if reliable) and could easily be replaced with commodity servers running linux for a lot less.

It did give...

Depending on how you have the properties for SQL Server Agent set up, that history is most likely gone. If you right click on SQL Server Agent and select...

I'll agree, with...

Not a problem. I dealt with files from a Solaris box for years so it is sort of ingrained now. I didn't know that Mac used the CR...

Here is the thread where I think you will see what he is trying to do with mixing code. This is also the thread where he warned someone else...

Bob Hovious (3/24/2009)

---

I reluctantly reached that decision last week. I glanced at your link. ...

GilaMonster (3/24/2009)

---

RBarryYoung (3/24/2009)

---

It's like the old joke:

Q: How many psychiatrists does it take to change a light bulb?

A: Only one. But it takes a very long time and the...

*nix files end in a LF only.

Just an FYI.

The following is test code. Look at it and adapt it as needed for your purposes:

declare @ClaimCat table(

Claims int,

Category char(2)

);

insert...

raghu (3/24/2009)

---

HI

i have a proc which displays the result as

CLAIMS CATEGORY

12345 P1

42342 ...

It would help to see the actual code you are trying to replace. In addition changing from a cursor to a while loop doesn't really change much, it is...

foxjazz,

First, don't repost this thread, maybe we can get Steve to move it to a SQL Server 2005 forum.

Second, since you are using SQL Server 2005, please post future questions...