GilaMonster (1/29/2016)

---

"(table2.[type]<2 and table2.[type]>2)"

That will match precisely 0 rows, as type cannot be both less than 2 and greater than 2 at the same time. It's not equivalent to (table2.type...

Also know that if that column contains nulls, those will be missed by the select. Something along the lines of

(table2.[type]<2 and table2.[type]>2) Or table2.[type] IS NULL /*...

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