Okay, another act of professionalism, not. You may have editted your post deleting the comment you made, unfortunately it has been quoted in three separate posts. A...

Interesting, is this how you would interact with a person you are asking for assistance from in person? Very quick...

Who decides who can vote and who can't, Steve? I may be wrong, but are you sure he wants to decide who is qualified to make those decisions?

dxmer (6/12/2009)

---

I won't use the forum any more, because I was told I was using the forum incorrectly when the reply/answer to my post wasn't even relevant.

I was...

RBarryYoung (6/12/2009)

---

You know, I've always wondered why the #Temp tables that we create in SSMS (or QA) don't get destroyed when the batch/request ends. Shouldn't they run out of...

Unless things have changed with Access, when you attempt to open it and run a macro, Access wants to interact with the desktop, something it can't do when you try...

Curious. The code Iprovided found all the mdf/ldf files in my data directory that had been detached from SQL Server on my desktop system with no problems. Makes...

Gus,

You are correct, the EXCEPT would have been easier, but I was trying to keep it close to SQL Server 2000. Only changes needed would be to the appropriate...

I already added it to my signature block!

Although this is posted in SQL Server 7/2000 forum, I don't have a SQL Server 2000 system available, so the following solution is for SQL Server 2005. With a...

This is a running totals problem and is easily solved. Unfortunately Jeff's article is currently off-line, but there are numerous forum threads here on SSC that discuss it. ...

Yes, Jeff's article is great info, and I'm sure he'll thank you for the feedback. I'm glad we could help you understand what a powerful tool the tally or...

datediff(dd,registerddate, getdate())

darryl (6/11/2009)

---

Thanks for the reminder. Was guilty last time and you reminded me then. Just can't seem to get myself to use my live code/data. Must be...

darryl (6/11/2009)

---

Since I didn't give you the actual names in previous postings, here is what your suggestion looks like modified to fit the actual names:

select

A.empnum,

A.ename,

...