Jason Selburg (3/24/2008)
You're already doing it in some other cases, like the quest_name line ...but anyway ...
set @phone=ISNULL((select phone from guest where account=@account and room=@room_code group by phone),'')
could you verify how to form this particular set statement using the isnull function?
set @special1=isnull(isnull((select TOP 1 min(s.special) from guest_specials s,z_property z where s.account=@account and s.status='A' and z.hotel_date between s.from_date and s.to_date group by s.special)),'')
when i use this...i get the error: The isnull function requires 2 arguments.
thanks for your help