Does anyone know??? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Does anyone know???

Author

Topic

rbohaty
Yak Posting Veteran

71 Posts

Posted - 2007-11-11 : 18:37:47

I would like to have a simple web based calendar that I can connect to a database that will...

looking at the current date (ie 11/11/2007) and display the current month (in this example November) then

go through a database and evaluate 1 field (ship by - date field), this field may have many occurences of 11/11/2007 as well as other dates.

count how many 11/11/2007's exist in the field

based on the number of occurences display the calendar day 11/11/2007 as:

green if >=0 and <=50
yellow if >50 and <75
red if >75

This would be done for every day in Novemeber, it would be nice to have controls that can switch to a different month displaying the same info for that month also. I only need to display 1 month at a time.

Anyone knowing of a calendar that can do this?

Thanx

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2007-11-11 : 18:57:49

duplicate.

Poor planning on your part does not constitute an emergency on my part.