SQL Server Forums - Date counting

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Date counting

New Topic

Reply to Topic

Printer Friendly

Author

Topic

annamaria
Starting Member

Israel
30 Posts

Posted - 02/26/2008 : 07:30:16

review

Edited by - annamaria on 12/26/2008 10:16:05

madhivanan
Premature Yak Congratulator

India
22469 Posts

Posted - 02/26/2008 : 07:34:17

One of the methods

Select count(*) from table
where datecol between date1 and date2 and datename(weekday,datecol) not in ('saturday','sunday')

Madhivanan

Failing to plan is Planning to fail

sodeep
Flowing Fount of Yak Knowledge

USA
7173 Posts

Posted - 12/26/2008 : 16:56:16

quote:
Originally posted by annamaria

review

Remember, If you keep on deleting like this, You won't get any help from experts over here.

madhivanan
Premature Yak Congratulator

India
22469 Posts

Posted - 12/27/2008 : 00:45:24

quote:
Originally posted by annamaria

review

What is meant by review?

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts

Posted - 12/27/2008 : 11:34:31

quote:
Originally posted by madhivanan

quote:
Originally posted by annamaria

review

What is meant by review?

Madhivanan

Failing to plan is Planning to fail

may be OP just wanted to mark threads reviewed

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.09 seconds.