Answer / 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

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

---

What is a join in sql?

0 Answers  

---

What is raid, and how it can influence database performance?

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

How to check if stored procedure is running in sql server?

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

what is mean by crystal repoart? ahere we will mainly use that?

1 Answers  

---

What is a unique key constraint?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

List the different types of collation sensitivities in sql server?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

Explain log shipping?

0 Answers  

---