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 posting?

607

How much does a sql dba make? : SQL DBA

511

What is ttitle and btitle?

576

how to use myisamchk to check or repair myisam tables? : Sql dba

509

What are the different types of database management systems?

532

Can we create view in stored procedure?

526

Are subqueries faster than joins?

575

Is sql a scripting language?

521

What is dba in sql? : SQL DBA

535

What program will open a mdb file?

500

How to test for null values?

606

Explain character-manipulation functions?

634

Why is sql important?

579

How bulk collect improves performance?

570

What is the use of desc in sql?

496