I wonder if the SQL overlords have ever considered implementing my approach. It is very disconnecting in reading code to try and match up the columns and values, when you...

Really good article and follow-up comments. Thanks a lot.

It is always really scary to me when Management look at pie charts and graphs and "Think" they understand the numbers. All...

Steven, Glad you got some exercise. 😛

Let me guess, you turned 46 earlier this year ('2/5/1967'). 😀

The funny thing is, this request was me anticipating a requirement based on observed...

Michael, really liked your solution also.

Thanks Gail. I had looked at the date functions. Wish I had extrapolated out that I could use datediff().

Excellent! Thanks for sharing.

mister.magoo (4/30/2013)

---

If you mean you want to see it in SSMS , then just select it and then click on the value in the results grid - it will open...

Took me 6 minutes, but I was off by 3M. 🙂 Close enough for government work,...

I would hope most everyone who has been to school could. Anybody that knows the principles...

That is my worry as other operational procedures are all auto-commit.

Thanks for the reference. That...

Thanks again.

Looking into to this more I do have a question:

So to add a linked server you use sp_addlinkedserver and to delete it you use sp_dropserver?

sp_addserver is unrelated?

Is it possible to...

Thanks to both of you.

Unfortunately I/we have virtually no control over the choices being made. 🙁

argh!! Documentation example shows that as well. Sorry I didn't see it before.

Thanks for your help on this.