SQLRNNR (4/20/2012)

---

I am there...

Forum etiquette would have you post your solution. It is possible others may benefit.

Sorry, confused. Would you please elaborate on the following:

I need to delete the data in table 1. I know before delete the data in table1 I need to delete...

Yes, but may I ask why first? How are you going to be using this information?

David Burrows (4/20/2012)

---

Or maybe it...

Different note, anyone care to try and explain this one: http://www.sqlservercentral.com/Forums/Topic1287023-8-1.aspx?

GilaMonster (4/20/2012)

---

Not if there's a suitable index.

AdventureWorks (of some version or other)

CREATE...

Yes.

Express12 (4/20/2012)

---

Is their a best practice for re-coding this ? (this predicate is being applied to a 500 M row table - and performance stinks!)

SELECT stuff FROM...

Greg Edwards-268690 (4/20/2012)

---

12 Steps...

Ran into this myself a long time back. Took me a bit to remember. You would think your WHERE clause would stop reading from your Numbers table when...

Try this:

DECLARE @FREQ INT

SET @FREQ = 2

SELECT DATEADD(MM, @FREQ* NUMBER, '01/05/2012') AS MYDATE, NUMBER

FROM UTILITY..NUMBERS

WHERE NUMBER <= DATEDIFF(mm, '20120501', '20200501')

John Mitchell-245523 (4/20/2012)

---

The only thing I can think of is that there's some anomaly in your Numbers table. What does this return?

select MIN(number), MAX(number), COUNT(number)

FROM Utility.numbers where number <=...

mota7128 (4/20/2012)

---

Hi,

I have created some SSIS packages and they are working well on BIDS, I uploaded them to Inetgration server, and when I went to SQL Server Agent to...

Considering what you have...