Gail,

Yes you are coorect! Someone had a bright Idaea to have these display boards for the confrence rooms and of cource the VENDOR had no clue. Which I thought they...

Hello Jeff,

Where would I place RIGHT(GETDATE(),7) in the statement. When I placed it at the begging it returned the present time of day. Any help would be great!

Select nvarchar1,

...

Hello Gail,

First Thanks So So Much! The statement works fine but just had one last request from my BOSS.

I now need to truncate the time form 24 hour Military to...

Hi Chris,

The Query you provided is now working and I thank you so much. My issue now is that the records dispaled for DATTIEM1 and DATETIME2 are 8 hours ahead...

Hello Chris,

Yes, schedule should resemble the outlook calendar. If a meeting wraps across 2 days then block out both days. Also I have provided the output of your provided...

Chris,

I have only four rooms to display this information for, I will have one LCD outside each conference room with Its Agenda/Topic(NVARCHAR1) and time of the meeting Start (DateTime1) ...

Hello,

This Meeting reservation would start on the 18th and end the 19th. The user reserved the room from 2008-02-18 17:00:00.000 until 2008-02-19 01:00:00.000.

Thanks in advance!

Roosevelt

Hi Chris,

This is a calendar out of SharePoint for several conference rooms, I will be publishing the Conference Rooms Meeting Agenda(NVARCHAR1) on a LCD Video Display board outside...