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
- 3939 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 is a domain constraint give an example?
What is the difference between join and inner join?
What are various limitations of the views?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How do I port a number to sql server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to recover from sql injection? : sql server security
Explain features of analysis services?
What is check constraint in sql server?
What is microsoft sql server?
Relational calculus is what type of language?
What are partitioned views and distributed partitioned views?
Can select statements be used on views in ms sql server?
What are the different subsets of sql?
What is encryption key?
