need a querry in sql2005

Posted by Suneel161 under Sql Server on 4/21/2010 | Views : 1020 | Status : [Member] | Replies : 2
I have a form in which i have a cloumn names status. and this status is a ddl where we have 5 selection items. i need a querry to display selection items and count of month and count of year of the selected item in sql




Responses

Posted by: Pavanandey on: 4/21/2010 [Member] Bronze

Up
0
Down


Hi Suneel can u explain Ur requirement in brief

Thanks
Pavan Kumar
Mark Answer if this fits the need

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Man2vb on: 5/14/2010 [Member] Starter

Up
0
Down
try this u have the selected item value somthing X
and u wanted to get the count of month and count of year of X item then
SELECT COUNT(Month_Column), Count(Year_Column)
FROM Table_name
Where ItemValue = 'X'

Suneel161, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response