in MsSQL


USE Northwind
GO

SET NOCOUNT ON
CREATE TABLE myTable99( type char(10),[date] datetime, price money
, PRIMARY KEY (type, [date]))
GO

INSERT INTO myTable99(type,[date],price)
SELECT 'bat' ,'1/1/2001',10.00 UNION ALL
SELECT 'bat' ,'1/1/2002',20.00 UNION ALL
SELECT 'bat' ,'1/1/2003',30.00 UNION ALL
SELECT 'bat' ,'1/1/2004',40.00 UNION ALL
SELECT 'ball','1/1/2001',40.00 UNION ALL
SELECT 'ball','1/1/2002',30.00 UNION ALL
SELECT 'ball','1/1/2003',20.00 UNION ALL
SELECT 'ball','1/1/2004',10.00
GO


What I need, is to create view
with the result


type date (date from) price date_to
ball 2001-01-01 40.0000 2001-12-31 (next date -1 day)
ball 2002-01-01 30.0000 2002-12-31
ball 2003-01-01 20.0000 2003-12-31
ball 2004-01-01 10.0000 today
bat 2001-01-01 10.0000 2001-12-31
bat 2002-01-01 20.0000 2002-12-31
bat 2003-01-01 30.0000 2003-12-31
bat 2004-01-01 40.0000 today



it's needed to be able to add new dates, and prices

Help

something like this (untested) --

Thanks but I mean smth. else



type date (date from) price date_to
ball 2001-01-01 40.0000 2001-12-31 (next date -1 day)
ball 2002-01-01 30.0000 2002-12-31
ball 2003-01-01 20.0000 2003-12-31
ball 2004-01-01 10.0000 today
bat 2001-01-01 10.0000 2001-12-31
bat 2002-01-01 20.0000 2002-12-31
bat 2003-01-01 30.0000 2003-12-31
bat 2004-01-01 40.0000 today = getdate()

but i will add the rows to mu table like

bat 2004-05-01 50.0000


so
the result
....
...
bat 2004-01-01 40.0000 2004-04-30 (the next date -1 day)
bat 2004-05-01 50.0000 today = getdate()


some of types will be 2 dates and 2 prices but some of it many.

I remeber this...what the hell does "today" mean in the result set?

today is today = getdate()

in the table are the dates of new prices and the new prices (and type - mean product)

what i need is the periods when the prices is good
the last price is good unles today =getdate()

i thought i understood what you wanted but now i don't have a clue

good luck