True, but if you...

Wait, wait for it. Another one plagerized.

http://codevc.com/1929_A_The_Dynamic_Tally_or_Numbers_Table.aspx

Am I seeing some sort of pattern here? Here is another one but there are some variations, the code samples. The words really look like mine.

http://sqlanddotnetdevelopment.blogspot.com/2011/02/deleting-large-number-of-records.html

Same author a...

WAIT! Another one? Same date as published on SSC. Only thing, I had published this earlier on sswug.org several months earlier and republished on ssc later.

http://dbaling.blogspot.com/2009/09/deleting-large-number-of-records.html

I think I've been plagerized!

Here is the url for all to see:

http://www.codevc.com/1817_A_Deleting_Large_Number_of_Records.aspx

Edit: There is a link at the bottom that takes you back to SSC, but there is no...

SanDroid (10/3/2011)

---

Nice question. I heard this was supposed to change in 2008.

Not suprised it did not.

Becuase of this we always remove table variables from any code we get.

Table...

I've read that partitioning can enhance performance if it is done for the right reasons. In this case, if most of the queries are restricted to the current fiscal...

Lexa (10/2/2011)

---

Lynn Pettis (10/2/2011)

---

You aren't passing any parameters to the query based on what you have posted. To get what you want based on your post, try this:

DECLARE @table_name...

Lexa (10/2/2011)

---

Lynn Pettis (10/2/2011)

---

You aren't passing any parameters to the query based on what you have posted. To get what you want based on your post, try this:

DECLARE @table_name...

I'm really not sure what you are actually looking for as output.

It would really help if you would post the DDL for the tables, sample data for those tables, and...

It would help if you could provide the DDL for the tables, sample data for the tables, and expected results based on the sample data.

Please read the article I referenece...

You aren't passing any parameters to the query based on what you have posted. To get what you want based on your post, try this:

DECLARE @table_name nVARCHAR(128)

DECLARE @sql nvarchar(1000)

...

How is this function being used; as a column in a SELECT statement, a WHERE clause of a SELECT statement?

There is probably another way to write the function as well.

What...

The only problem I see with subtracting 730 days for 2 years, it isn't always 2 years. You have to account for leap year at times or you may...

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all the MVP's...