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

what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

What are truncate options available in sql server? : sql server database administration

0 Answers  

---

What are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

What is the difference between mysql and sql server?

0 Answers  

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

What is sparse columns of sql server 2008?

0 Answers  

---

What is a primary key?

0 Answers  

---

What are the recovery models for a database?

0 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---