Viewing 15 posts - 53,941 through 53,955 (of 59,065 total)
p.s. And a million rows isn't much so far as SQL Server is concerned... certainly, it's not sufficient for justification of 2k5 or 2k8. I've got lookup tables...
November 25, 2007 at 9:26 am
My recommendation would be... unless you have an immediate need for the Security enhancements, there's not much you can't do in a relatively simple manner in 2k T-SQL including Row_Number,...
November 25, 2007 at 9:22 am
aureolin (11/24/2007)
you'll never see me use a While Loop to create a list of contiguous dates... I'll always use a Tally table for that (and a lot more).
Sounds like a...
November 25, 2007 at 8:54 am
In the example previously given, there are 2 groups... 1 has 3 data points and the other has 4. Would you provide the "8 data points" for the example...
November 25, 2007 at 7:48 am
Funny thing... you never know if you solved their problem when they don't respond 😉 Pretty rude, too... 😛
November 24, 2007 at 9:48 pm
Sure... anytime you return less, it will usually return faster.
Lemme ask... are you using the GRID mode, or the TEXT mode? As you probably know, the Grid mode is...
November 24, 2007 at 2:04 pm
I know... old post... but, I've gotta ask...
Why in the the world would you do a SELECT * with no criteria on a table that contains 180,000 rows? You...
November 24, 2007 at 1:02 pm
Dang... not good... hides the "problem".
November 24, 2007 at 11:32 am
It's doing the Binary math as 2k does... can you try one more time? Do this in the text mode, please... thanks, Dave.
[font="Courier New"]DECLARE @MATij FLOAT(53)
DECLARE @MATpj FLOAT(53)
DECLARE @m...
November 24, 2007 at 10:41 am
The code RockMoose wrote for solving the Rank/Percentile problem in SQL Server 2000 is a great example of "How to Avoid the Cursor/Loop". Cursor/Loop solution could not be used...
November 24, 2007 at 10:34 am
ajethaa (11/24/2007)
am new to programming and am doing a project now with asp.net technology..am in need of percentile function to be created...
and saw your post...
but could not understand completely.
wats...
November 24, 2007 at 10:12 am
-- No cursors please
/rockmoose
You must unlearn what You have learnt
Rockmoose! You ol' dog! Where in the heck have you been? How funny... I quoted your...
November 24, 2007 at 10:10 am
Heh... speaking of "tea"... I once had a friend from the UK who thought folks in the US where a bit odd... here's his quote...
"I guess I don't understand Americans......
November 24, 2007 at 9:22 am
I wonder if MS made the mistake of doing the rounding on the new display? What does the code for the problem come up with for an answer on...
November 24, 2007 at 9:16 am
Viewing 15 posts - 53,941 through 53,955 (of 59,065 total)