In order to reduce the number spam posts to Microsoft's public newsgroup microsoft.public.sqlserver.programming, we have decided to require people to become a member of EggHeadCafe prior to posting. This free service is made available for people who do not have NNTP access where they work. For best results, you will want to sign-on to this newsgroup via your favorite news reader and view your reply when you get home.

Are you sure you need a procedure?

Scho posted on Thursday, August 21, 2008 11:08 PM

Are you sure you need a procedure?
Maybe a view would be better; this way it would be called at any one
time and do a list with a count for you as well as be simply an
extension of your current TSQL skills.

BOL link for procedures; http://msdn.microsoft.com/en-us/library/ms187926.aspx
BOL link for Views; http://msdn.microsoft.com/en-us/library/ms187956.aspx

I'd suggest something like...

Create View Vw_ListSoftware
AS
SELECT Name, Version, Count(Name) FROM SoftwareDataTable

Bit basic and you've not really explained the table your holding the
data but should give you an idea but sure there are a few MVPs hanging
around that can do something a lot more clever!
Scho