Mitch2007 (8/26/2010)

---

Hi all,

would love some guidance on what I thought would be a simple insert statement.

I'm inserting some values that are created on the fly but the third value is...

Stefan Krzywicki (8/26/2010)

---

On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats, airplanes,...

Yes. 😀

This seems to be a good candidate for the exist() method.

My first guess would be that you're not returning the proper parameter into the procedure. Try running Profiler and capture the actual query being passed, and see if it looks...

I see I forgot to comment what I was doing.

Since the server/db are in variables, you need to build a string to put the variables in. Then execute the string.

And,...

Libby, you might find it easier to set up an Export-to-Excel package by using "Export Data" from SSMS, and then in that wizard tell it to save a package. When...

Resolution: see this link

No, didn't have to do anything to make 2008 work properly when upgraded.

ColdCoffee (8/26/2010)

---

WayneS, OP is having SQL 2000.. so i guess OVER (PARTITION BY) wont work there..i dont have a handy SQL 2000 version for OVER (PARTITION BY)... it would be...

Agreed - it should have been ready when 64-bit...

iqtedar (8/25/2010)

---

Mentioned below is my sql. @server and @database are created dynamically. I need to get name,type_desc,create_date,modify_date,@server and @database columns in one table. Any suggestions?

select name,type_desc,create_date,modify_date from [' + @server...

No

I have a script where my cursor loops through different servers and different databases....

Put it into an INSERT trigger.

Ram,

First of all, I'm opposed to any code that contains the keyword "WHILE". This means that you are processing things in a loop, instead of a set-based manner.

I would start...