You aren't providing the whole story if you have left out vital information. Based SOLELY off the info you provided, the code I provided will work. How about...

First, I have been insulted on this forum as well, so I do understand. You have no control over what someone else says or does. You do, however,...

Bob! Only 83 more posts until we hit 3000!

CozyRoc (3/24/2009)

---

Steve Jones - Editor (3/24/2009)

---

I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you...

All of us "heavy hitters" could make an agreement to post nothing in any of his future requests for assistance except the following:

Please read the following article: Forum Etiquette: How...

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