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

What is the difference between rollback and rollback to statements?

1060

What will you get by the cursor attribute sql%found?

964

Enlist the characteristics of pl/sql?

1803

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

what is query cache in mysql? : Sql dba

1037

What is a parameter query?

1084

What version is sql?

1035

What is full join?

954

How you improve the performance of sql*loader? : aql loader

1014

what are different types of keys in sql?

1153

How do you clear the screen in sql?

1069

What is sql basics?

1044

What is exit statement?

1018

Is merge a dml statement?

980

What is the need of a partition key?

987