|
Posted by Buzby on 10/10/08 11:33
"Jens" <Jens@sqlserver2005.de> wrote in message
news:1133365217.428667.241950@z14g2000cwz.googlegroups.com...
Please post some DDL next time, but I don΄t know If I understood your
questions right:
"AND AvailDayShow != 0" ?
I wish it were that simple! - basically I have returned a set of days in a
block between dates - if there's a 0 in any of these block I want not to
show it - imagine trying to book a room - I for three nights, - it's
available tonight, tommorrow night, but not on the third night so it can't
be booked.
Thanks for the help - much appreciated - just hope I'm making myself clear
(as mud!!)
[Back to original message]
|