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"
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 the Main Difference between ACCESS and SQL SERVER?
Name some of the open source software that you can use in alternative to SSR?
Explain ranking functions?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What were the latest updates to SQL Azure service?
What is the default schema of your login session in ms sql server?
what is a correlated sub-query? : Sql server database administration
What is msdb database? : SQL Server Architecture
What are click through reports?
what changed between the previous version of sql server and the current version? : Sql server database administration
How to enter date and time literals in ms sql server?
Tell me about the approaches which you used to counter the DI problems.
Name few endpoints exposed by ssrs 2012?
Does index slows down insert statements?