Hi.

I was making a booking calendar.

Like this

And regarding the dynamic dates.

The way I found was just to build the string ex, [12/1/2009],[12/1/2009],[12/1/2009] in c# then pass it in as...

Thank you nabha for your time.

A person on the msdn forum cracked it.

Just to close this quistion with the answer, go here to see it.

Thank you for your reply nabha, I'll check out the link you provided

And here is the test data:

declare @t table ( id int, name nvarchar(10),StartDate datetime, EndDate datetime,Type nvarchar(10)) ...