Viewing 15 posts - 2,776 through 2,790 (of 5,590 total)
This should do it for you. Remarks are in the code.
DECLARE @date datetime,
@month tinyint;
SET @date = '20101230';
-- get the month of the...
October 19, 2010 at 8:37 pm
pavan_srirangam (10/19/2010)
I think he needs find out who or what are doing the deletes not the data what is deleting.
Check out the last three columns in the new table......
October 19, 2010 at 5:10 pm
thejask08 (10/19/2010)
How to do it SQL SERVER 2000. ROW_NUMBER(), OVER() doesnt exist in SQL SERVER 2000.Please help how to do this in sql server 2000.
It would help to be mindful...
October 19, 2010 at 4:49 pm
Bill_CCAC (10/19/2010)
I will but I'm not quite finished with it yet. As soon as I get it sorted I'll posted it.This turned into a nice post. Thanks all
I'd suggest...
October 19, 2010 at 4:41 pm
Roy Ernest (10/19/2010)
I think I will try a rewrite of the sproc and test it in our QA with load testing and see if it will cause any dead locks.
If...
October 19, 2010 at 4:35 pm
Steve Jones - SSC Editor (10/19/2010)
WayneS (10/18/2010)
October 19, 2010 at 4:33 pm
aspardeshi (10/18/2010)
October 18, 2010 at 10:24 pm
Steve Jones - SSC Editor (10/18/2010)
October 18, 2010 at 10:12 pm
Lynn Pettis (10/18/2010)
October 18, 2010 at 10:00 pm
Please see this link.
Text/image are depreciated - they are going away in a future version of SQL. Use varbinary(max) instead.
Which to use: FileStream or varbinary? It depends:
How many files to...
October 18, 2010 at 5:11 pm
Here's an update to my code. I've moved the 1462 dates we're concerned with into a separate temp table, instead of being called through a CTE numerous times. Greatly improves...
October 17, 2010 at 10:23 pm
Jeff Moden (10/17/2010)
WayneS (10/17/2010)
This works, but the performance is atrocious.
Because of the very large datespan from any date in this century to 9999-12-31, I'm thinking that my ol' friend the...
October 17, 2010 at 10:08 pm
Jeff Moden (10/17/2010)
Sorry... forgot to print out the results...
MemberIDStartDateEndDateGap
12006-10-01 00:00:00.0002007-12-31 00:00:00.0000
12008-01-15 00:00:00.0002008-12-31 00:00:00.00015
22007-02-03 00:00:00.0002007-12-31 00:00:00.0000
22008-01-15 00:00:00.0002008-12-31 00:00:00.00015
32006-10-01 00:00:00.0002007-09-30 00:00:00.0000
32008-01-01 00:00:00.0002008-12-31 00:00:00.00093
Jeff, are these gaps correct? By my calc, there are...
October 17, 2010 at 10:04 pm
Kevin,
This works, but the performance is atrocious. I'm posting it so that others (Jeff???) can see what I'm doing, and to improve upon it.
declare @GapDays int,
...
October 17, 2010 at 9:58 pm
Jeff Moden (10/17/2010)
WayneS (10/14/2010)
"Don't try this at home... we're professionals!"Heh... I have the perfect SQL subject for that... Quirky Update. 😀
SOM!
October 17, 2010 at 8:56 pm
Viewing 15 posts - 2,776 through 2,790 (of 5,590 total)