Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3911 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
Define views.
What are the types of user defined functions in sql server?
Does group by sort data?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is the library index called?
What is dbcc updateusage?
How to convert character strings into numeric values?
What are the filtered indexes?
What is the process of normalization?
Do you know sql server 2008 introduces automatic auditing?
What are the different subsets of sql?
Can we deploy SSRS reports on our personal website?
Your table has a large character field there are queries that use this field in their search clause what should you do?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is the Difference Between Primary and Foreign Key?
