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
- 3853 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
Can you use order by when defining a view?
What are the advantages dts has over bcp?
Are all views updatable ?
Explain about the command-line tool SQLCMD?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What are the steps to process a single select statement?
What is the difference between mysql and sql server?
How to download and install microsoft sql server management studio express?
What is normalization and what are the advantages of it?
What is table valued function and scalar valued functions?
Define master database?
Why do we need different type of parameter?
What are the types of normalization?
How to get a list of columns using the "sys.columns" view in ms sql server?
Will sql server 2005 allow you to reduce the size of a column?
