Pretty close, Bob. Well done. 🙂

Well, dynamic SQL would be my first response.

Since that wasn't the question that Jeff wanted, I'll answer this one, ...:D

They are necessary because all table...

Ivanna Noh (3/11/2009)

---

here's an even simpler query that those i've seen posted - but no doubt i have overlooked something 🙂

...

query:

SELECT ID FROM #test WHERE countries LIKE 'IN'

AND ID...

cspencer (3/11/2009)

---

Is there anything like object_name() for SMO, that let's you retrieve an SMO object using a name or ID? Currently, the only way I know how to retrieve an...

SMO does not do this. You might possibly be able to generate a CREATE TABLE command and reparse it yourself into ADD COLUMN clauses, but that seems problematic to...

Bob Hovious (3/11/2009)

---

M R Ducks.

No M R not.

S M R. Look at M webbed feet.

L I B !! M R Ducks.

I haven't thought about that since...

From your original post:

Rats, Lowell beat me to it... 🙂

You probably want a transaction here too.

And long term, you seriously want primary keys.

Actually, I just checked and it now appears to me that your SQL answer is correct and your calculator is incorrect at the 8th place.

You are only allowing 7 digits of precision right of the decimal point. Your SQL results are returning 7 digits of precision right of the decimal point, which is...

Tasumy (3/11/2009)

---

Thank you for your answer but I've found out!

I have to delete the shema and database users for the login first and replace Dim log As New Login(myServer, myLogin)

If...

No worries, I do this all the time. Especially with ROW_NUMBER() which I love to use.

PeterR (3/10/2009)

---

Thanks for your suggestions guys.

I was most impressed with RBarry's solution, but unfortunately nested selects did not work on our SQL2000 site. I got an 'incorrect syntax' error.

I've...

Glad we could help.