ZZartin (3/22/2016)

---

This code doesn't look the greatest but it might do what you want. But how do you plan to handle it when there are multiple solutions? For...

Jacob Wilkins (3/22/2016)

---

jewel.sacred (3/22/2016)

---

Yes, I can fully understand this as I have experienced it as well in past. 🙂 I really appreciate the help been provided. But I already mentioned...

Yes, I can fully understand this as I have experienced it as well in past. 🙂 I really appreciate the help been provided. But I already mentioned this criteria in...

Thanks. Very interesting indeed. But it fails for the following criteria

SELECT @DateStart = '20160425', @DateEnd = '20160501';

The result should have been

PrimaryKeyIDDateStartDateEnd ...

I would be very happy if there will be such a simple solution, but this is not giving the desired results. 🙁

Sorry for responding late. There was an auditing process going on which meant that we are only done with the deletion of the data(No shrink). So I was not able...

SQLRNNR (2/10/2014)

---

jewel.sacred (2/10/2014)

---

@Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No disrespect to...

MyDoggieJessie (2/10/2014)

---

Shrinking a database wouldn't cause the creation of any new execution plans.

Yes, this will cause your log file(s) to fill/grow (especially so with the index maintenance)

If space...

The included columns are there in order to omit bookmark lookups which could be costly and in some scenarios could lead to deadlocks. But it all depends upon your workload.

As...

@Keith Tate Thanks a lot for quick the reply. I already had this in my mind but I am more comfortable with Michelle Ufford's gem (No disrespect to Olla's excellent/great...

jewel.sacred (4/9/2012)

---

Also, since you are using global temporary tables, you can create two procedures which would check the temp table existence and create the desired temp table with different definition....

Also, since you are using global temporary tables, you can create two procedures which would check the temp table existence and create the desired temp table with different definition. And...

This indeed is a very odd and strange behavior of SQL. You cannot add the definition of the temp table (CREATE TABLE #...) again in the same batch as it...

@Lynn Pettis

Was I able to answer your query?

Also, Currently, I am trying to put the data in a Declared table, and then run updates on that with IFs...

Sorry friends, In our part of world, its getting a bit late. Moreover, I may not be able to reply this thread for good time. So please accept my apology...