Viewing 15 posts - 55,051 through 55,065 (of 59,078 total)
| My aim isn't to always at all cost post 100% conclusive close-the-case posts. I'm more interested in getting... |
September 13, 2007 at 4:54 am
Much better... but won't work in SQL Server 2000 which is what this forum is... ![]()
September 13, 2007 at 4:50 am
Heh... or just pay attention to what you're doing
Either way, a trip to the estimated execution plan probably would have shown the...
September 12, 2007 at 4:56 pm
Glad it helped...
Any chance of you posting your final code?
September 12, 2007 at 4:50 pm
Your solution can not work without the numbers table... at least a link would have been nice...
September 12, 2007 at 4:48 pm
Sure... when you first create a server instance, they are not there. They only appear when something first needs them... then, they persist.
September 12, 2007 at 4:40 pm
Um... be careful in that assumption... while this works...
DECLARE @SomeDate DATETIME
SET @SomeDate = '05.24.2007'
PRINT @SomeDate
...this will not...
DECLARE @SomeDate DATETIME
SET @SomeDate = '24.05.2007'
PRINT @SomeDate
...because the implicit format is understood to be mm.dd.yyyy.
September 12, 2007 at 4:39 pm
Still worth it... maybe someone else can get a leg up on things if they manage to find it...
September 12, 2007 at 4:29 pm
"Error like this object already exists?" What on Earth are you doing with the Dynamic SQL?
September 12, 2007 at 4:18 pm
What... and miss out on all that high-class entertainment? ![]()
September 12, 2007 at 4:16 pm
Duplicate records DO happen on staging tables used for preprocessing rows from third parties, especially telephone companies... Either a "UNIQUE WITH IGNORE DUPES" index must be used (comparitively very slow)...
September 12, 2007 at 4:16 pm
Heh... you're right... wrong article... it was about "RAAS", not "RAC"...
You'r still nothing more than a spammer... I can't understand why you don't get your product evaluated on this site......
September 12, 2007 at 4:12 pm
This should do it nicely... classic cross-tab... you might be able to use SQL Server 2005 PIVOT as well... either way, it'll solve your slowdown because each row is only...
September 12, 2007 at 8:33 am
Viewing 15 posts - 55,051 through 55,065 (of 59,078 total)