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

Why function is used in sql?

992

What is a design view?

978

Are sql connections encrypted?

1085

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1149

What does select * from mean in sql?

3330

Explain the difference between triggers and constraints?

1023

How do temporal tables work?

1018

Explain normalization and what are the advantages of it?

998

Can we join tables without foreign key?

1005

What is a ddl command?

1153

What is trigger in sql and its types?

1109

What are different joins used in sql?

1105

What is difference between my sql and sql?

1138

Can a procedure in a package be overloaded?

1099

Is oracle and sql same?

1077