Viewing 15 posts - 14,341 through 14,355 (of 26,486 total)
Sean Lange (10/3/2011)
Lynn Pettis (10/3/2011)
Wait, wait for it. Another one plagerized.http://codevc.com/1929_A_The_Dynamic_Tally_or_Numbers_Table.aspx
At least this yahoo gives credit at the bottom with a full link to the "source".
True, but if you...
October 3, 2011 at 1:39 pm
Wait, wait for it. Another one plagerized.
http://codevc.com/1929_A_The_Dynamic_Tally_or_Numbers_Table.aspx
October 3, 2011 at 1:28 pm
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...
October 3, 2011 at 1:01 pm
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
October 3, 2011 at 12:57 pm
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...
October 3, 2011 at 12:53 pm
SanDroid (10/3/2011)
Not suprised it did not.
Becuase of this we always remove table variables from any code we get.
Table...
October 3, 2011 at 9:17 am
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...
October 2, 2011 at 2:58 pm
Lexa (10/2/2011)
Lynn Pettis (10/2/2011)
DECLARE @table_name...
October 2, 2011 at 2:12 pm
Lexa (10/2/2011)
Lynn Pettis (10/2/2011)
DECLARE @table_name...
October 2, 2011 at 2:06 pm
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...
October 2, 2011 at 1:25 pm
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...
October 2, 2011 at 1:23 pm
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)
...
October 2, 2011 at 1:10 pm
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...
October 2, 2011 at 1:00 pm
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...
October 2, 2011 at 12:51 pm
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 1, 2011 at 5:09 pm
Viewing 15 posts - 14,341 through 14,355 (of 26,486 total)