SQLTeam.com | Weblogs | Forums

Calendar

sql2008

#1

How does displaying a calendar with select function?

thx


#2

Not sure I understand what you mean. Can you give some examples of table you want to select from and what you want the output to look like?


#3

I need to create an report, The report is about activity date, my database is only storing the activity that the user entry. I need to get an information about another date or need to display all of information activity even there are not any activity. for an example display :

Date Activity
01-01-2017 Sales Meeting
01-02-2017 Tech.Meeting
01-03-2017 -----
01-04-2017 -----
01-05-2017 Business Trip
and so on

thanks


#4

so where is the

information about another date

Also:

display all of information activity even there are not any activity

Would be nothing, right? If you want to show all activity when there is no activity, you should get an empty result set.