Difficult sql query

[mori0043]

I have a complex query that returns a very large rowset containing five columns (I am simplifying it a bit here):
PrimaryKey, DATE1, DATE2, DATE3, DATE4

For each returned row I want to order the dates min to max and then based on each range of dates calculate a value from another query...

Is there a way to do this that is efficient?

SQL Server, Stored Proc...

Thanks in advance.

 

[mrdenny]

i'd recommend loading the dates into a tempory table, then working with the data. That's going to be the only way to order the coulumn data is to get it from the horizontial format that you have it in, into a vertical format.

PK, DateNumber, Date
1, 1, 1/1/2005
1, 2, 1/5/2005
...

A table that looks something like that should do the trick.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[mori0043]

Ok... It's soooo slow though since the tables are very large. Thanks, I guess that I will have to keep it this way.