It's simple No need to use Cursor for that select Month(Joindate)

wa procedure to return the month and the no'f developers
joined in each month.

Question Posted / arrry.net

Answer Posted / arrry.net

It's simple
No need to use Cursor for that

select Month(Joindate)as MONTH,count(*) as empCount from dbo.tblEmployee
Group by Month(Joindate)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we join tables without foreign key?

693

Explain what is table in a database?

783

What is the difference between sql, mysql and sql server?

694

How do I save a sql query?

735

What is sql and also describe types of sql statements?

757

Which is better varchar or nvarchar?

735

how to load data files into tables with 'mysqlimport'? : Sql dba

745

What is data control language?

736

how many ways to get the current time? : Sql dba

710

Name some usages of database trigger?

748

Is subquery faster than join?

743

How exception handling is done in advance pl/sql?

672

What is the difference between sql and mysql?

759

When do we use triggers?

800

How is a PL/SQL code compiled?

869