Nested Stored Procedure

[jonhbt]

hi, i need to create a stored procedure with a Count(*) option and also an output parameter with the Id of the selected record. IS it possible?

[Ashfield]

Yes

Bob Ashfield Consultants Ltd

[Mycroft Holmes]

Well the question does not make sense: ID infers a unique identifier Count(*) requires a group by So your question is can I group by a unique identifier. Try rephrasing the question (I think you just got it wrong) and give us some more detail.

Never underestimate the power of human stupidity RAH

[Venkat Eswaran]

Why do you use Count(*), it is better to use Count(ID) ID infers a unique identifier in that table CREATE PROCEDURE titles_count @@TITLE varchar(40) = '%', @@count int OUTPUT AS SELECT @@count = count(title_id) FROM titles WHERE title LIKE @@TITLE GO

Venky

[Mycroft Holmes]

Why is it better to use count(field) instead of count(*), I have never heard that there is a difference in cost

Never underestimate the power of human stupidity RAH