Viewing 15 posts - 196 through 210 (of 479 total)
Have you tried replacing every occurrence of GETDATE() by (GETDATE()-1) ?
February 16, 2009 at 5:41 am
bitbucket (2/13/2009)
shhh tell no one, but heck it was better than using a slide rule to do the calculations.
I still have my slide rule and can even remember how to...
February 16, 2009 at 4:02 am
David Webb (2/13/2009)
February 16, 2009 at 3:33 am
bitbucket (2/13/2009)
February 16, 2009 at 3:25 am
Michael Earl (2/13/2009)
I've always preferred someone with common sense and troubleshooting skills and wants to work over someone with a pile of certifications and lots of letters after their name.
I've...
February 16, 2009 at 3:04 am
Jesse McLain (2/13/2009)I agree with your admonition against reinventing the wheel, as Windiff does a great job. But my original intention was to provide quantitative matching results, not necessarily the...
February 16, 2009 at 2:55 am
I was looking to add more topics per page.
The situation I often find is that there are quite often 2 or pages of active items since last visit. I skim...
February 16, 2009 at 2:10 am
Lynn Pettis (2/13/2009)
February 13, 2009 at 10:09 am
eseosaoregie (2/13/2009)
The inner join produces a dataset with 98000 or so records. Consequently,logically I would expect 98000 records to be updated. However only 23000 records are updated.
This is the flaw...
February 13, 2009 at 8:57 am
I'd suggest extracting the columns as a string and using a Derived Column Transformation with a suitable expression to check for a null value or otherwise validate it.
The first example...
February 13, 2009 at 7:45 am
As I understand it, SQL server is first evaluating the CASE statement, without looking at what it's going to be used for. CASE
WHEN TestStr = 'False'...
February 13, 2009 at 6:08 am
Regarding your problem of stored procedure comparison, Windiff is still available (just Google "windiff download", one of the places is Microsoft) so I'd have just used that (and regularly do!).
Of...
February 13, 2009 at 4:43 am
Alvin Ramard (2/11/2009)
How much information I'm ready to pass on also depends on how busy I am...
February 12, 2009 at 7:00 am
DBA (2/11/2009)
it is unchecked, also for my other Dbs, the extension do show correctly except for this one. .. :crying:
Sorry, I missed this extra information.
Since your other database are shown...
February 12, 2009 at 6:52 am
I would think that your registry has lost (or more likely never had) the file association registry entries for .mdf, .ldf and .ndf (for example, in HKEY_CLASSES_ROOT). Since these are...
February 12, 2009 at 6:44 am
Viewing 15 posts - 196 through 210 (of 479 total)