SumonB (1/25/2016)

---

Okay here is the scenario.

I am creating a DBA Report where I need to show the backup details for last 15 days including today's date.

I have 2 variables...

Sergiy (1/23/2016)

---

I think he was not totally understanding date math in sql server. Once he defined the problem better Scott was able to give him a solution. I was...

Sergiy (1/20/2016)

---

OK, this is opposite...

Since this is a SS2K8 T-SQL forum,

A cleaner approach:

Declare @StartDate Date;

Declare @EndDate Date='2016-01-05';--getdate();

Set@StartDate = dateadd(d,-15, @EndDate);

Select@startDate, @endDate;

Just changing variable types from datetime to Date declaration

He may be after picking some random rows on the intermediate result of a union alls for whatever reason....

Sergiy (1/21/2016)

---

MMartin1 (1/21/2016)

---

That would make sense since this table is a heap. The ID column is not really an identifyer in this situation. We are not recommending a practice of...

Phil Parkin (1/21/2016)

---

MMartin1 (1/21/2016)

---

Brilliant work Orlando. It makes sense that the execute sql task is returning the results of a SELECT. That will be in the form of a ...

I would also call that an infinite loop. A Recursive function should have a cut off point. 😛

Brilliant work Orlando. It makes sense that the execute sql task is returning the results of a SELECT. That will be in the form of a result set, even...

That would make sense since this table is a heap. The ID column is not really an identifyer in this situation. We are not recommending a practice of not maintaining...

rakesh.naik (12/31/2015)

---

I then checked the mail log and see this following error message showing up.

The mail could not be sent to the recipients because of the mail server...

Another thing to consider is avoiding the chaining of views if possible. You keep the compiler from getting a good query plan. Things are not as re-usable in the SQL...

How would you know in the real world that [dbo].[L2] was the first view in the chain, where you started the refresh? Certainly things are not named this way...

Great solution Eirikur , the

,ROW_NUMBER() OVER

(

...

If you have someone good at it, finding the bad code and fixing it isn't as expensive as most would think and has the long term benefit of being rather...