I am trying to accomplish something using SQL, but am too novice at it
to come up with a working solution. I wonder if someone has any tips for
me. Here we go...
I have, in an SQL server 6.5, one table of some substance (1.5 milion
records). It is a flat table with no relations or triggers or whatever.
What I want to do is make an aggregate query that groups certain rows.
No problem, I can do that. Now, what I want to do next is the following:
I want to analyse two subsequent rows at a time, placing one field of
each record into a new table. It should look something like this:
newtable.field1=resultset(row 1).field X, newtable.field2=resultset(row
newtable.field1=resultset(row 2).field X, newtable.field2=resultset(row
newtable.field1=resultset(row 3).field X, newtable.field2=resultset(row
I hope this description is a bit clear. Is there a way of accomplishing
this using just ANSI SQL? Or will I have to resort to VB or similar
things to process each row?
Hope someone can help me with this
PS if anybody could send hinst and tips through email, that would be
great; my usenet time is very limited. PLease remove the obvious from
the email addy