What do you mean, concatenate rows? Specific counts, or a however many meet some criteria?

Showing some sample data and DDL would help.

I could live with the 24 clock, but I like DST, and I like my pounds, inches, and miles!

These forums, I think, do require pointing out of mistakes for the reasons Jay mentioned. However if it's something like a typo, I have pinged people to privately edit their...

To see history, I think you need a Google account that you are signed into when you search. I typically remain signed in with Google on my machines

There is a lot of money to be made selling information about people. Years ago I worked in a startup and we would regularly get lists of people to email/call...

This is something to keep in mind as you work on old code as well. If you have a 2005/008 system with these types, refactor the code to use the...

Very nice editorial, Tim, and I'll respond before I head out for a much needed break today.

Whether it's business communication, or posting here on the forum, I think small errors...

majorbloodnock (2/25/2010)

---

Agree totally with the editorial. Constructive criticism is almost always the right thing to do, and if it's not appreciated then at least you know you did the right...

I agree with Jason. Be careful what you ask for here.

The site is here http://www.sqlsaturday.com/

It's a brand/franchise started by myself, Andy Warren, and Brian Knight, founders of this site. We built it to get one day events going to help...

I hope that Google isn't implying they are removing data and then keeping it. My guess is they remove the references from my account, but they keep some type of...

jcrawf02 (2/24/2010)

---

Steve, fyi, HIPAA does allow you to request your medical records from your physician, and although you can't remove information, you can set limits on who they're allowed to...

I think you're taking the right approach. Learn, work at it, ask questions. I've been thrown into similar situations, and there are tons of Windows admins here on the forums...

This was the case when I worked in a large (Fortune 1000) company. we had two accounts, and were restricted from doing things with our regular accounts. It's a pain,...

You ought to grow it every 3-4 months, calculating what you'll need beyond that.

In terms of maintenance, you likely need to do it during off hours. You could archive off...