how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
- 1 Answers
- 3324 Views
- I also Faced
- E-Mail Answers
Answer Posted / harshad lakkad (bapunagar) par
--First Create This Function To Return a week Days For
Particular Date--
CREATE FUNCTION [dbo].[udf_DayOfWeek]
(@dtDate DATETIME)
RETURNS VARCHAR(10)
AS
BEGIN
DECLARE @rtDayofWeek VARCHAR(10)
SELECT @rtDayofWeek = CASE DATEPART(weekday,@dtDate)
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
RETURN (@rtDayofWeek)
END
--Now Use this Function As Below
SELECT
Sum(Bank.Amount),
dbo.udf_DayOfWeek(Bank.Date) AS DayOfWeek
From Bank
Group By Bank.Date
-- Here Bank.Amount And Bank.Date Are Column Name Of Bank
Table
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the requirements to use odbc connections in php scripts?
How do you create a clustered index?
What are the restrictions that views have to follow?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is checkpoint process in the sql server?
What is the osql utility?
What is RMS migrations?
What is row_number()?
What xml support does the sql server extend?
What is faster join or union?
Working with TLogs
What are the advantages of sql azure?
What is the most common type of join?
Explain about Views?
How to choose all records from the table?
