Viewing 15 posts - 42,511 through 42,525 (of 59,067 total)
Yep! Fourth here! Add a bit of a write up to go with all the great pictures and submit that bad boy as an article. I'm sure...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 4:11 pm
aktikt (8/5/2009)
Jeff, thanks for your patronizing complements... Just kidding. I sincerely thank you. I received some helpful replies particularly Nigel's.
Nigel, this is an excellent...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 10:02 am
Jack Corbett (8/5/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:45 am
dsteinschneider ,
Keep it simple... just a simple CREATE TABLE script and a couple dozen rows of readily consumable data so folks can work on the problem of distribution of 5...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:39 am
Gianluca Sartori (8/5/2009)
When will the article be online again? It's hard to explain this technique to others without the help of your article... expecially for...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:35 am
Heh... that's why I plan on "growth" and I'll always make VARCHAR variables about 50% bigger than they need to be.
I do wish that MS would come out with type...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:31 am
SQL Iron Chef (8/4/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:22 am
Paul (8/5/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:10 am
nigel (8/5/2009)
Apologies, just noticed that you don't want it grouped by ClaimID, just the Month and Year.
Try this slightly modified version instead:
SELECT
...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 9:03 am
PeterG (8/5/2009)
I went through the set up with the import/export wizard and saved it to a file and added the package...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 5, 2009 at 8:49 am
quayludious (8/4/2009)
Is there a better way than using the inner joins?
If I'm reading your code example correctly, the answer is "yes, absolutely". Please post the code for the function...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2009 at 9:54 pm
Just don't get the idea that you can use any ol' index to do this... It MUST be a clustered index.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2009 at 9:46 pm
willian (8/4/2009)
This code will process each row using @RESULT from one line to another?
I need take the @RESULT from atual row and use it on the next...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2009 at 9:41 pm
Heh... still on a roll, Steve. Keep it going. I am, however, glad you changed your shirt from the last time.
I can't get over how many people are...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2009 at 9:35 pm
pzmrcd (8/4/2009)
We have an existing application that uses a table with a Primary ket tat has been set to char[12].
This was developed many years back and due to the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2009 at 9:26 pm
Viewing 15 posts - 42,511 through 42,525 (of 59,067 total)