I am the Anti-Musician. I can't carry a tune in a bag. I'm tone mute. I have the rhythm of electric convulsions. Can't dance, can't sing,...

I'm late on the chain on this one, but just spending some time with a 1-year-old is all that's needed.

I get a few e-mails every month from the links on this site.

A few have been private conversations that didn't belong on the public forums. A few have been...

I don't think SQL 2008 wide tables will do what you need. They're more about having optional columns in a table, if I'm not mistaken.

The potential solution that occurs...

In Management Studio, go to Tools, Options, Scripting. There's an option there to include drop statements in scripts.

Nope. Didn't know about that option. MS Tech Support apparently didn't either (they weren't very helpful, but did at least help me figure out what was wrong, even...

Well, you could either do this as string concatenation in T-SQL, or, better, have the front-end do this for you.

Second the motion. Save to a file, import the file.

I've removed instances by using Add/Remove Programs. The problem you're running into with that might be because of disk space issues.

Glad I could help. You're welcome.

Yeah, most of these things boil down to a lazy programmer or twelve somewhere along the way.

Miles Neale (8/14/2008)

---

The mode closed doors to certain technology the more limited the toolset to solve problems. I know there are at least three ways to do most everything but...

Is there a reason to not do all the updates in one command?

rbarryyoung (8/14/2008)

---

As Gus alluded to, this...

dbo.returnvalue will be a user-defined function in your database. It looks like it takes two input parameters and returns a value, which is being assigned to that variable.