Viewing 15 posts - 53,941 through 53,955 (of 59,068 total)
Hi Michael,
VB and Excel returns the same value.
I'm currently coding T-SQL again to see where the problem lies.
Be specific, please... what value is that?
November 26, 2007 at 8:12 am
However, I don't want the lines with all the fields (about 150 for my table).
Not a problem... it'll depend on the actual query you write.
In addition, I want the values...
November 26, 2007 at 8:00 am
Ok... are we working in VB or T-SQL???
And, please provide a sample of the input that you currently have that is not being transformed to your liking as well...
November 26, 2007 at 7:38 am
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
Viewing 15 posts - 53,941 through 53,955 (of 59,068 total)