Sorting Rows Doesn't Work, Please Help

[Harlan Grove]

(e-mail address removed) wrote...

it's not 4 untrivial queries.

it is ONE QUERY. MAYBE 2.

And if it's supposed to be returned to the original 6 fields per record
format?

And for the record?? i woudln't have to properly normalize the data--
because it would come to me in that format.

Find a state lotery authority site that provides historical winning
lotto numbers in a normalized format (2 or 3 fields per record, 6
records per draw) rather than a matrix format (6 fields per records or
possibly 7 if the date of the draw were included, so all numbers drawn
in the same records).

You don't have any real world experience with outside data. Most people
receive data in formats over which they have no control AND no access
to any database from which that data may have been drawn. This is a
good example.

So, for the record, you'd have to normalize this data if it comes from
its current sources.

 

[greaseman]

It's absolutely indicative of Aaron's lack of brain.... he thought F1,
F2, F3, F4.... in Harlan's example were -*_ACTUAL_*- field names! If
he thinks that stupidly, wouldn't we love to see his database crap?
(Sarcasm intended).

I worked with a guy a few years ago who was equally flatlined. The guy
I worked with, when I told him, in VB code to "sort some fields
alphabetically by last name, first name" -actually entered into the
program's source code, - "sort some fields alphabetically by last name,
first name" which is what Aaron would do also.

Geeeeee..... I wonder if the guy who worked for me had a middle name of
Aaron? Nahhhhhh.... there's only one Aaron (isn't there????)

I love the way Aaron shows us his incompetence.

 

[dbahooker]

no.

I WOULDNT TRANSFORM IS LEFT TO RIGHT AND UP AND DOWN.

I would _STORE_ the data up and down instead of left to right; and then
it's a single simple query.

You see.. i dont copy and paste data. I don't enter data by hand.

my data is _ALREADY_ in a database.

And I don't need to copy and paste a similiar function into 1400
different cells.

Is it PHYSICALLY POSSIBLE to accurately have 1,400 copies of simiar
functions and ensure that it's accurate?

Your stupid spaghetti code is a joke..

-Aaron

 

[dbahooker]

Jay

I'm going to have to stop screwing your mom.. I just don't want to
catch the stupid disease.

So maybe you'll have to find someone else to do this.. Find some Excel
dork.. she can't afford me.

-Aaron

 

[Jay Petrulis]

Jay

So maybe you'll have to find someone else to do this..

-Aaron

and for the record??
So, you are now giving up on helping the OP resolve the specific
question?

i mean seriously

I think you are losing focus. The McArthur Wheeler story I keep
referencing with the juice comments is amusing. However, for you,
please note the title of the study. It is clearly applicable to you.

"Unskilled and Unaware of It: How Difficulties in Recognizing One's Own
Incompetence Lead to Inflated Self-Assessments"

 

[aaron.kempf]

greaseman

i dont know WTF you're takling about.

THEY WERE ACTUAL FIELD NAMES.

dipshits like you call stuff like that all the time. It's comical.

Keep DATA in a DATABASE and it's 100 times easier to sort and filter
and sum and product and anythnig else that you would want to do.

-Aaron