But does, 'Insert into '+@addDate+'' work with my above EXEC sp_executesql @query.

I defined the @addDate as

DECLARE @addDate table (dated varchar(12))

TakeCare,

Bue!!

Mark's, ur answer did work.

Frank's, ur answer does work even without the (). And since its a recommended. I'm using it finally.

Honest 'Thax' for all support.

TakeCare,

Bue!!

Thx for this info, and a neat query. And we have Normalised the database. The Date_Interval table keeps complete track of the Date(date, weekDay, yearDate, yearWeek...) and similarly the Time_Interval...

Edit plus. With this I could always color the current line. Find + Replace complex regular expressions, Infact I use this as my complete java project tool. I compile, edit...

Thx, and OLAP or AS cannot be used as per Specs. So we have to do it in a traditional way. So, I would like to tell more about the...