Luis Cazares (2/5/2014)

---

I agree that your expected results are wrong because you have an enddate greater than the startdate and that will generate a problem in the next row (rows...

That feature disappeared with SQL 2005. You can get something like it if you have all of your backups in the same backup file or in the same backup...

suresh0534 (2/5/2014)

---

Thanks for your reply,

But there is no end date....I need to calculate the End date based on Start Date.

Example I am calculating the 2013 year Data.

If Start date date...

dwain.c (2/5/2014)

---

Jeff Moden (2/5/2014)

---

He should come to Michigan. It was snowing to beat the band a couple of days ago...

I think there is a problem with your sample data.

There is at least one end date that occurs prior to the start date for the associated record.

Additionally, since the end...

duplicate post, please post replies at this post instead http://www.sqlservercentral.com/Forums/Topic1538410-392-1.aspx

homebrew01 (2/5/2014)

---

If you took the backups using native SQL, and they are stored in the same location as the time of backup, then I think you can use the GUI...

Steve Jones - SSC Editor (1/28/2014)

---

Best quote I've seen in awhile...

No.

And since you can see the stored procs through the linked server, that screams that there is a security flaw in your linked server setup. Somebody has probably created...

Revenant (2/5/2014)

---

Sean Lange (2/5/2014)

---

SQLRNNR (2/5/2014)

---

Sean Lange (2/5/2014)

---

WayneS (2/5/2014)

---

Sean Lange (2/4/2014)

---

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and...

Lab

Sean Lange (2/5/2014)

---

WayneS (2/5/2014)

---

Sean Lange (2/4/2014)

---

What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The...

IMHO - I wouldn't use the wizard.

twine

Evil Kraig F (2/5/2014)

---

Your best bet is to analyze your optimization plans, determine what your access methods can be, and then reviewing your existing tables. Sometimes simply including a...