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 left join in sql?

1003

What is the importance of sqlcode and sqlerrm?

1274

what is the difference between union and union all? : Sql dba

973

What is hibernate and its relation to sql?

1063

What are the various levels of constraints?

1058

What are analytical functions in sql?

965

explain the difference between bool, tinyint and bit. : Sql dba

934

What is localdb mssqllocaldb?

1015

Why do we use procedures in sql?

1016

What are the types of variables use in pl sql?

964

explain advantages of innodb over myisam. : Sql dba

1082

What does the file extension accdb stand for?

915

What is sql integrity?

1053

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985

What do you think about pl/sql?

943