Take it, since you did the other FTP one.

Brandie Tarvin (4/4/2012)

---

Poll of the day.

How many people support systems that do quarter end / month end processes?

[\quote]

I used to, and it was a pain.

How many additional hours do you...

Jeff Moden (4/3/2012)

---

The "advantages" you have for THROW are actually disadvantages for me especially when it comes to THROW having fewer parameters. I really hope this is April Fools...

Not sure it's...

Ditto....

No one "lost" points. There isn't a total from which we remove them. You earn them, or you don't.

Pints from Red Gate is a good idea, but at the rate I drink it would take me 5000 days to achieve alcohol toxicity.

I was checking dates, and must have forwarded a few years in a click instead of one. Monday next year, look for something interesting.

Alter authorization is a SQL 2005+ command. It didn't exist in SQL Server 2000. If you print out the values and try to run them, you'll see an error.

http://msdn.microsoft.com/en-us/library/aa299742%28v=sql.80%29.aspx

Schema's didn't...

I'd suggest what Grant says, but keep in mind you're going to get multiple result sets.

Should be a fairly simple join with a MAX(), but show us what you have.

Look up computed columns in Books Online.

Is this SQL Server 2000 or 2005? You posted in 2000. Also, you didn't mention what problem you're having, nor what you expect this to change the schema to.

I'm back, everyone have a good week?

ID10T error.

I started with one question, and then changed, rewording the answers and explanation to fit....