Filling in dates between - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Filling in dates between

Author

Topic

rohcky
Starting Member

38 Posts

Posted - 2007-12-13 : 10:56:32

I have a table that contains delta data.

Date Item Amount
10/1 Book 10
10/5 Book 9
10/12 Book 5
etc

I need help filling in the dates in between so that the table contains

Date Item Amount
10/1 Book 10
10/2 Book 10
10/3 Book 10
10/4 Book 10
10/5 Book 9
10/6 Book 9
10/7 Book 9
10/8 Book 9
10/9 Book 9
10/10 Book 9
10/11 Book 9
10/12 Book 5
etc

Is this feasible at all?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-12-13 : 10:59:45

Yes. make use of the F_TABLE_DATE

KH
[spoiler]Time is always against us[/spoiler]

caisys
Starting Member

16 Posts

Posted - 2007-12-13 : 14:59:56

WOW this site really rocks ! I logged on to ask about same subject and i found the solution right in front of me without even asking, you r doing a great job !!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources