How Can display tow result in select statement By Store Procdure

Question

1.00/5 (1 vote)

See more:

How Can display tow result in select statement By Store Procdure :

SQL

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 and 

select DATEADD(year, 1, '2006-08-30') as 'Datenew'

Posted 16-Jun-15 7:01am

Member 11280947

Updated 16-Jun-15 7:55am

Maciej Los

v2

Add a Solution

Comments

virusstorm 16-Jun-15 13:23pm

Do you me two (2) results?

Member 11280947 16-Jun-15 13:35pm

yes

Member 11280947 16-Jun-15 13:36pm

the first select statement
and second select statement

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

virusstorm · Answer 1 · 2015-06-16T07:40:00

Solution 1

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.).

SQL

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

Posted 16-Jun-15 7:40am

virusstorm

Comments

Member 11280947 16-Jun-15 13:47pm

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

i need to store this in parameter (second select statement)

virusstorm 16-Jun-15 13:50pm

I'm having trouble following you on that. What do you mean store the second select statement in a parameter? How do you plan on accessing/consuming this value?

Member 11280947 16-Jun-15 13:56pm

i use this store procedure in my report I trig to display for example: second year

virusstorm 16-Jun-15 14:00pm

If you are using SQL Server Reporting Services, then what you are trying to do is not possible. Your only option would be to add your second statement as part of the column list in the first select. All of the rows would then have that value and you bind the report to the first row of the result set. This could have undesired effects if the report is empty.

Member 11280947 16-Jun-15 14:26pm

i use crystal report

virusstorm 16-Jun-15 14:29pm

I have used Crystal Reports in a long time, but I think it has the same limitation. I suggest either change your approach or update your question to better reflect what you doing, bind a Crystal Report to two result sets from a stored procedure.

Member 11280947 16-Jun-15 14:42pm

in crystal report I need:
to select crent year and second year