SQL

From: <kskasi_at_hotmail.com>
Date: 2000/06/16
Message-ID: <3949EB15.8DFBDDDC@hotmail.com>#1/1

Hello everyone

I've got a table named projects which has got customer_budget in it. This customer_budget is for 12 months of the year. Basically I need to spread that out throughout the year. So if the customer budget is $12 the output should look something like this

Period      Budget
200001     $1
200002     $1
200003     $1

.
.
.

200012 $1

Period is to_char(date,'YYYYMM). Is it possible to get that output for a given date range

cheers...kasi Received on Fri Jun 16 2000 - 00:00:00 CDT