How to return a Table with Stored Procedures?

i have a procedure like below but it dosen't return any table

SELECT Hardwares.HWID, Hardwares.TitleFROM HardwaresINNERJOIN CategoryON Hardwares.CategoryID = Category.CategoryIDWHERE (Category.TypeLIKE'%Hardware%')AND (Category.Title = @.Title)

Without more information, my guess is that there are no rows in the table Hardwares which meet your where criteria.

Can you post a sample row which you would expect to be returned using this query? Also, what are you passing in for the @.Title parameter.

|||

The output of a SELECT query is always tabular. If you run this query in your query analyzer / management studio, what results do you see? How are you executing this stored procedure from within your data access code?

Matt

|||

i actually missed out the varchar(n) part. so it becomes only 1 character