Viewing 15 posts - 33,451 through 33,465 (of 59,102 total)
matt6749 (6/27/2011)
Notes:a) i think it would be even quicker if I didn't join with my existing Providers and Occupations table
I notice you do column sorts based on that information. ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 8:29 pm
matt6749 (6/27/2011)
...for some reason searching on Canadian zip codes takes longer, even though U.S. and Canadian zip codes are in same table.
It's because the 2nd triad of characters in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 8:10 pm
Jason Selburg (6/27/2011)
I just ask Jeff. 😀
:-P:blush:
Thanks, Jason.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 6:55 pm
quickdraw (6/27/2011)
Oh, that row_number trick is so beautiful it makes me want to cry!
If you'd like to see a similar "Row_Number Trick" on steroids 😉 to solve the problem when...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 6:45 pm
skynet_si (6/27/2011)
Did not have the time to check this but it seems the last output is wrong
DBLMS 2011-04-25 00:00:00.000 2011-04-26 00:00:00.000 118.00 ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 4:42 pm
Brandon Forest (6/27/2011)
8.0
4
1 SQLCHAR 0 2...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 4:31 pm
Wrong post... removed comments.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 5:58 am
mail2payan (6/26/2011)
How to set share access policies in MS SQL Server??
You don't. You have to set the share at the OS level and the share needs to be for...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 5:52 am
paul s-306273 (6/27/2011)
As for coding, if you can't make sense of something that's been posted reasonably quickly, I suggest you move on to something that you can comprehend.
On the other...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 5:47 am
pandeesh (6/27/2011)
Regex Replace won't be faster than the nested replaces. .
May i know how?
Yep.... like I said...
Behind the scenes, they do the same thing.
However, if you want, I can...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 5:30 am
Thanks, Kamal.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 5:27 am
TheSQLGuru (6/22/2011)
If you want an amazingly efficient way to collapse date intervals, see here: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals.aspx. Incredible TSQL goodness served up by Itzik Ben-Gan.
Damn, that's clever. It's not...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2011 at 11:44 pm
Additional info would be great so I can understand something.
just learning ...
Ok... in that light...
The key to easily figuring out this problem had absolutely nothing to do with any...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2011 at 10:06 pm
As a side bar, I believe using the actual enddates for each rate is confusing because they aren't actually the enddates. They're actually the start date of the next...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2011 at 9:20 pm
skynet_si (6/26/2011)
So can someone enlighten me and put me out of my misery.
Absolutely.
Additional info would be great so I can understand something.
just learning ...
The additional info you seek...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 26, 2011 at 9:16 pm
Viewing 15 posts - 33,451 through 33,465 (of 59,102 total)