I've been doing well these last few weeks. Going into week 9 against a division rival and half my team have byes! I think I may be in...

jcrawf02 (11/2/2010)

---

Ha! This one is for Lynn and others who ref soccer - what NOT to do for the kickoff:

http://runningahospital.blogspot.com/2010/10/sad-news-on-soccer-pitch.html

It's also a good blog by the CEO of Beth Israel...

Unfortunately, HoustonFirefox, your clarification does not really match what you wrote in your original post.

I believe SQL Server does a good job of managing the t-log files as long as...

First, I take exception to the "Weekend Warrior" comment. I have supported GB+ databases on SAN and DAS systems and have had to worry about disk space constraints on...

I really think that the code can be much simpler. I'll wai for the OP to post the DDL for the underlying tables, sample data, and expected results.

Hopefully he...

Also, I do agree that if there is a GUI or reporting tool (SSRS, Crystal, etc) that formatting of dates should occur there (as well as for all other data).

WayneS (10/28/2010)

---

Lynn Pettis (10/28/2010)

---

Jeff Moden (10/28/2010)

---

Maybe so but you should consider it...

jcrawf02 (10/28/2010)

---

Two comments, which are completely separate, and I should probably post separately, but I'm lazy 😀

1 - we're all talking too much about Celko, and frankly, you're better than...

What is wrong with this?

declare @Date1 datetime, @Date2 datetime;

set @Date1 = '2010-07-01 00:00:00.000'

set @Date2 = '2010-10-01 00:00:00.000'

select

@Date1,

@Date2,

dateadd(yy, -1,...

Umm, agree with you I must.

All you need is a tally table and then the following works:

select

mrt.id,

mrt.MyValue,

mrt.Qty

from

MultiRowTest mrt

...

Jeff Moden (10/28/2010)

---

Maybe so but you should consider it to be just...

WayneS (10/28/2010)

---

Stefan Krzywicki (10/28/2010)

---

Roy Ernest (10/28/2010)

---

I have couple of suggestions, but you have to take the first step on that. Put the Table structure here. We could help you with...

CELKO (10/28/2010)

---

I tried to read what you posted got 45 minutes. You have re-discovered the same algorithms I used on mag tape files decades ago. Your temp tables are scratch...

My function is also written as an in-lineTFV, combined with the cross apply and strings less than or equal to 8000 bytes, it works really quick.

I know that there may...