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.
| Author |
Topic |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2006-08-17 : 03:35:18
|
| Hi I want to create a Function that calculate how many Saturday and sunday fall down in a month. plz help me.Ranjeet Kumar Singh |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-17 : 04:08:57
|
| [code]select count(*) from F_TABLE_DATE('20060801', '20060831')where weekday_name in ('sat', 'sun')[/code]The function F_TABLE_DATE can be found here [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519[/url].Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
calculate how many Saturday and sunday in a month