There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths"
- 2 Answers
- 3295 Views
- I also Faced
- E-Mail Answers
Answer Posted / newbie
CREATE PROCEDURE GetEventsByMonths
@MONTH VARCHAR(15)
AS
SET NOCOUNT ON
SELECT name,DATENAME(MONTH,startdate) AS Startmonth
FROM Events
WHERE DATENAME(MONTH,startdate) = @MONTH
GROUP BY name,DATENAME(MONTH,startdate)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is ssl in sql server?
How to test odbc dsn connection settings?
What is a trigger and types of a trigger?
Can I disable or restrict ssrs export formats (rendering formats)?
What is the purpose of the model database?
How ssrs maintain security?
Can we install sql server 2016 on windows 7?
What is the difference between row_number and dense_rank?
What are the different types of data sources in ssrs?
Explain use of expression builder.
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is the usage of the sign function?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is difference between cte and view?
