titsiros (1/26/2016)

---

The databases are on different machines but for the purpose of the merge we could move them to the same one. This would also make sense in terms of...

titsiros (1/26/2016)

---

I use a similar strategy but instead of having a nested select, I do an INNER join between the two databases

insert into destinationDB.destinationTable (ID, s...)

select destinationParentTable.ID, s...

from...

Sergiy (1/25/2016)

---

MMartin1 (1/25/2016)

---

No, since this particular statement is vague the best we can do is start him off with some basics to try and get more information. This is not...

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...