Re: [SQL] Best way to do this query..

2006-08-25 Thread Richard Broersma Jr
> Yes the data does not change once it is logged. > I am quite new to this whole thing, do you mind elaborating more > about the OLAP data model you mentioned about? Well just to give a generalization using an OLAP as your data model, the data is stored in a denormalized yet defined model. Data

Re: [SQL] Best way to do this query..

2006-08-25 Thread Henry Ortega
Yes the data does not change once it is logged.I am quite new to this whole thing, do you mind elaborating moreabout the OLAP data model you mentioned about?On 8/25/06, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: I would assume that your data does not change after it is logged.  If this is the

Re: [SQL] Best way to do this query..

2006-08-25 Thread Richard Broersma Jr
> I have the following: > > name effective tstamp rate > John 01-01-2006 2005-12-07 13:39:07.614945115.00 > John 01-16-2006 2006-01-07 13:39:07.614945125.00 > John 01-16-2006 2006-01-09 15:13:04.4169351885.00

Re: [SQL] Best way to do this query..

2006-08-25 Thread Andrew Sullivan
On Fri, Aug 25, 2006 at 04:16:07PM -0400, Henry Ortega wrote: > I have the following: > > name effective tstamp rate > John 01-01-2006 2005-12-07 13:39:07.614945115.00 > John 01-16-2006 2006-01-07 13:39:07.614945125.00 > Jo

[SQL] Best way to do this query..

2006-08-25 Thread Henry Ortega
I have the following:name  effective tstamp   rateJohn   01-01-2006 2005-12-07 13:39:07.614945    115.00John   01-16-2006 2006-01-07 13:39:07.614945     125.00 John   01-16-2006 2006-01-09 15:13:04.416935    1885.00 I want the outp