Well I guess I didn't quite get the requirements. Chock that up to a lack of details. This thread could serve as a good example of why it is so...

Grant Fritchey (9/27/2013)

---

hisakimatama (9/26/2013)

---

SQLRNNR (9/26/2013)

---

hisakimatama (9/26/2013)

---

Aaaaaaargh... And now, I need to fume :-P.

Working with the company's vendor software, and one of the reports is coming across super-slow, about 10...

tskelley (9/26/2013)

---

I have a table with a large amount columns. Instead of trying to manually go thru the table and determine which columns have data. Is there a...

Luis is absolutely correct about datatypes here. You are using sql 2008 so you have the time datatype. This would be the appropriate time (pun intended) to use that datatype.

CREATE...

mike murray-229384 (9/26/2013)

---

dwain.c (9/24/2013)

---

I don't think you've got enough information in this table to do this.

I'm not sure by your post whether you're looking to see an expanded hierarchy or...

Thanks to hunchback for the ddl and data. Here is another way to do the same thing.

select Rate

from @T

cross apply (select count(*) as RowsCount from @t where rate = @Rate)...

Lynn Pettis (9/26/2013)

---

I know most Threadizens know I am currently deployed in Afghanistan as a civilian contractor.

I was notified this evening that my position state side has been cut as...

No biggie. There is no way for us...

SQLKnitter (9/26/2013)

---

Thank you for your response. That's what I'm using but it doesn't work. I could do it on the servers at my previous job, but not here. I will...

SQLKnitter (9/26/2013)

---

Hello all, I'm out of my depth here. Working for a small company that has two small databases on the same box, a 2008 R2 SQL Server that is...

You have been around here long enough to know that posting some consumable ddl and data is far more likely to get responses.

That being said why is only 3 and...

Bhuvnesh (9/26/2013)

---

Sean,

Talking about the selection of "NOT IN" over "Between" i have experienced...

When using the send results to file it is limited to the same settings as output to text. At least it was in 2005. I just tried and it seems...

Technically speaking you can't change the identity property of an...

ROFL. I never realized that option was there either. I have always just completely ignored the time of the post. Apparently I was set to central Europe. That is bit...