Thank's y'all for your responses--I had a typo on the 'legalto', which is why none of my results returned what I was looking for. My actual code was correct, except...

Lowell, thank you! Your post fixed my problem converting Decimal stored as Varchar into an INT (still working in 2005 & 2008)

This was a huge help. Thank you!

WillC9999 (10/6/2010)

---

"I dragged my toddler into the data center complete with pillows and blankets for off hours calls"

Should this be regarded as a good or bad thing? It's a hell...

As a woman in the production side of the IT/DBA business, let alone as a single mother, I believe it is very difficult for women to be fully dedicated to...

Excellent solution! I'll read more on sp_executesql for future reference.

BTW, anyone wanting to use the above script, log files are groupid = 0, not 2.

Many thanks,

Clarie DeWayne

In my experience, it's VERY difficult to get $$ for Admin tools. Developers seem to get the bigger monitors, faster machines, and definitely all the software tools they want &...

Your post is a bit confusing and doesn't contain all required information. :w00t:

So here is a guess:

Are you saying that you have a table [users] and a table [loginHistory], and...

Like others before me, I've always used export tools to get the data to Excel. However, the formatting of the spreadsheet for alternate colors makes me *almost* wish that I...

Your job is as secure as your last valid backup.

Security including getting DomAdmins out of SysAdmins Role

I enjoy the commentaries, though rarely respond. Keep up the good work! ~Clarie