If you remove the
and
between the two queries, it will return two result sets. The how to display them will depend on what you are using to execute the procedure (ADO.NET, Entity Framework, Management Studio, etc.).
ALTER proc [dbo].[PrinttProducts_TBL]
@Product_id int
as
select pt.Product_id ,pt.Product_name ,pt.Product_Price
from dbo.Products_TBL pt
inner join tblcatProducts cp on cp.catId = pt.FK_catId inner join StoresTBL st on pt.FK_Store_id = st.Store_id
where Product_id=@Product_id
select DATEADD(year, 1, '2006-08-30') as Datenew