Stored procedure returning values

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hello,

I'm in doubt to make a stored procedure. I have a table that contains some data. example: TableX
(id_table int,
int value)

what I want is through a SP return two values, the first is to count all the records entered values, and the second is to divide all values by x and return only the integer part. this is simple, but my difficulty is to do this all in the same SP and return these two to be added later in a gridview.

the first I do this: COUNT (tableX.value)
the second: COUNT (tableX.value) / x

I want a complete SP does return these values all at once. any ideas?

Posted 16-Sep-13 2:42am

fasher_the_one

Add a Solution

Comments

BulletVictim 16-Sep-13 8:55am

The select You want is rather Easy.
SELECT COUNT(tableX.value) AS Count,(COUNT(tableX.value)/x) AS Calculation FROM tableX
This will bring the values back in one select output
The rest of the SP you can do yourself

fasher_the_one 17-Sep-13 7:17am

thankz BulletVictim, this help me well

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)

norbitrial · Accepted Answer · 2013-09-16T03:00:00

You can make output paramaters to your stored procedures.

Check this link:
Returning Data by Using OUTPUT Parameters[^]

For example:

SQL

ALTER PROCEDURE dbo.YourSP
@id_table int,
@count1 OUTPUT,
@count2 OUTPUT

AS  
    DECLARE @x INT

    SET @x = 10; --you can make an input parameter for this if you want

    SET NOCOUNT ON;
    SELECT @count1 = COUNT(X.value), @count2 = COUNT(X.value) / @x
    FROM tableX as X
    WHERE table_id = @id_table;

RETURN

And in C# you can use as the follows:
out parameter modifier (C# Reference)[^]

I hope I could help you!