I pride myself on my British sense of humour (a colonial hangver, I guess), and while I could understand the last line, the bit about the warthog was lost on...

Chris, once again many thanks for your tireless help.

Your code works when I run it directly on my DB Table.

I can even set the @Today variable from my code.

I thank all of you for your contributions.

I do not want to look like I am arguing but some of the replies here did not understand my need for unique...

Chris, my apologies!

INSERT INTO #ViewResult

'202','COMPANY2',CAST ('29/06/2007'AS DATETIME),CAST ('01/07/2007'AS DATETIME) UNION ALL

'AAAA','GUEST1 GUEST1',CAST ('05/07/2007'AS DATETIME),CAST ('07/07/2007'AS DATETIME) UNION ALL

'AAAA','bilal dadar',CAST ('27/06/2007'AS DATETIME),CAST ('29/06/2007'AS DATETIME) UNION ALL

'AAAA','Mr Bond',CAST ('24/06/2007'AS...

I spoke too soon (sigh)!

I thought I could adapt your code to get my data from just a single table:

SET DATEFORMAT DMY

DECLARE @MyDate DateTime

SELECT @MyDate = GetDate()

SELECT RoomName,

...

I posted a reply here a few hours ago but see it's missing!!

No offence taken, Jeff, so do not feel bad at all. You have a perfectly valid point, and...

Thanks, (and sorry, I did not knwo you had a forum for 2000 also).

Any link?

It works, beautifully.

Thanks, but am using SQL Server 2000 at present.

Learning new technologies as I go along.

I do not want to rush things, rather to learn on a need-to-know basis, so I'll...

Thanks Ian & Chris both for your contributions. I think Chris nailed it - his solution's perfect for my need, (but I'll get back as soon as I've tried it...

Thanks. I'll remember that, though I am years away from implementing email functionality in my DBs.

Thanks, Herve.

I'd like to learn more about the hashing process and how to implement it.

Also, the reason I want to protect my DB is that I do not want anyone,...

Thanks again for your indefatigable hospitality, may God bless you.

I understood your solution since yesterday, but I do not think I am making much sense to you.

Your solution is good...

Sugesh, thanks for the kind words.

(FYI, I am a hyperactive member on VBCity, and my experience there normally makes me very nervous when venturing to other forums, because the leaders...

I just looked at my first post, and saw it has been mangled by the editor so here is my sample report with dotted column spacing:

Room...Rollover...Arrival...Departure

101....ABC...........................

102................DEF...............

103................GHI.......JKL.....

104..........................MNO.....

105.....PQR..........................

Currently Room 103 will appear...