how to calculate monthly data expecting sundays of the month

Question

0.00/5 (No votes)

See more:

There is a table contains 31 column(DataType int) for each day of a month..
I am trying to calculate for total details of the month excluding sundays Data..
How do I get the desired data through SQL Query.

Please help..

Posted 11-Sep-12 4:10am

himanshu034

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kuthuparakkal · Answer 1 · 2012-09-11T04:19:00

You may have to derive your date field from existing data:

YourDateField = Year + Month + DataType Int Column converted to varchar
Eg:- '2012' + '01' + RIGHT('00' + CAST(MonthDay AS NVARCHAR(2), 2)

SQL

select * from yourTable
Where UPPER(DATENAME(DW,YourDateField)) <>'SUNDAY'

OR

SQL

select * from yourTabl
Where DATEPART(DW,YourDateField) <> 1 -- 1 means Sunday, 2 Monday, ... 7 Saturday

how to calculate monthly data expecting sundays of the month

1 solution

Solution 1

Add your solution here

Preview 0

how to calculate monthly data expecting sundays of the month

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us