You may want to look at:

http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582

It is the so called Island and Gaps solution.

I didn't expect anything in return for helping. I felt it was the right thing to do, especially since I was walking down that way any way. It was sad...

Clicking on the above link returned 111 posts,...

Is this what you require ?

CREATE TABLE #T(Hr INT,D DATE,S INT)

INSERT INTO #T

SELECT 0, '2012-09-05', 10 UNION ALL

SELECT 1, '2012-09-05', 20...

First item the time you say you need to pick is

that time does NOT exist in the data you have listed. That said is this...

WayneS

Hugo - thanks for the great clarifications / explanations that you do so frequently with the QOTDs. Things just wouldn't be the same without you on these every day, providing...

Rod at work (9/5/2012)

---

. But how do I determine the newly created backup file's name? It's kind of a long thing, so I don't know how to go about...

These two articles might give you a method of doing what you desire.

http://www.sqlservercentral.com/articles/function/67046/

http://www.sqlservercentral.com/articles/function/68323/

Time for me to toot my own horn ... braging HECK yes.

My 73rd QOD has been scheduled for 06 Sep 2012 - 07 Sep 2012

Should be available shortyly after 10...

Nice question - make sure one knows the basics

Thanks

Go to Microsoft's Connect site - for a quick guide of what you can do and what you can uncover try reading:

http://blog.hoegaerden.be/2012/01/04/posting-an-issue-to-microsoft-connect/

The Connect site can be accessed via:

https://connect.microsoft.com/

L' Eomot Inversé (9/2/2012)

---

Hugo Kornelis (8/31/2012)

---

bitbucket-25253 (8/31/2012)

---

sknox (8/31/2012)

---

Agreed. Also, if you haven't voted...

See next post

ChrisM@Work (8/31/2012)

---

Potso (8/31/2012)

---

Thanks I knew it was something simple and dumb i was just not thinking about. And i am dropping the table everytime after the stored procedure is run...

sknox (8/31/2012)

---

Agreed. Also, if you haven't voted on the Connect submission for this...