Okay Steve, I find it admirable that you will stand by your code. Unfortunately, I took that as a challenge and wrote my own inline TVF that generates the...

Try here:

[Url]http://msdn.microsoft.com/en-us/library/ms187476(SQL.90).aspx[/url] and

http://msdn.microsoft.com/en-us/library/bb510452

Steven James Gray (6/2/2010)

---

Lynn Pettis (6/2/2010)

---

What most people are saying is that this approach isn't necessarily the correct approach in a DW environment.

My complaint with the code is the use...

What most people are saying is that this approach isn't necessarily the correct approach in a DW environment.

My complaint with the code is the use of a recursive CTE. ...

If you would really like some help, may I suggest that you post the DDL (CREATE Table statement(s)) for the table(s) involved, sample data (as a series of INSERT INTO...

Not too difficult for someone who hasn't read his blog as well. I just pay close attention to others more versed in log files that also post here on...

Its lack of scalability is its biggest problem. A recursive CTE is still RBAR (a Modenism for Row By Agonizing Row).

Gianluca Sartori (6/1/2010)

---

Tom.Thomson (5/31/2010)

---

GilaMonster (5/30/2010)

---

Actually from one point of view this is a smaller problem than the other. Working out a backup strategy for 2TB of data is non-trivial,...

Using a recursive CTE to generate what is basically a dynamic tally table except returning a dynamic calendar/time table is not scalable.

For an article on dynamic tally tables, please read...

This is how your RESTORE should look:

RESTORE DATABASE [AdventureWorksDW]

FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\AdventureWorksDW.bak'

WITH FILE = 1,

MOVE N'AdventureWorksDW_Data' TO N'D:\Databases\UserDB\AdventureWorksDW_Data.mdf',

...

urzsuresh (5/30/2010)

---

Hi Paul White NZ

Its was nice. But one clariffication. here Starttime and endtime is nchar(10) type.

i need to get the result without using any functions.

I need another...

Had to think this one through, and managed to get it right! Good question!

Though worded differently, this looks like a cross post. Please post any answers here.

Jeff Moden (5/29/2010)

---

I wonder what the interview process was and how full of hooie the resume was that allowed someone to have a job that required someone to do the...

CirquedeSQLeil (5/28/2010)

---

bteraberry (5/28/2010)

---

I believe in free markets. I believe we'll all be better off the less government is involved in our lives with very specific exceptions where government oversight...