Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
koushhh
Starting Member
2 Posts |
 Posted - 2008-09-17 : 05:41:32
|
| Hi,I am a newbie to both this site and ASP .NET.My query is can I categorize my items based on type and show the number of item available for that particular type.e.g. Group CamcoderSony(23)Canon(19) like that |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 05:47:40
|
| That should be done in your database and presented in your .net pageTry the count function in MS SQL |
 |
|
|
koushhh
Starting Member
2 Posts |
Posted - 2008-09-17 : 07:15:06
|
| do i need to use group by query?will that do the trick? |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 10:58:48
|
| Yes. |
|
|
|
|
|
|
how can I categorize the items