how can retreive multiple rows of a column values from DB using a stored procedure with passing parameters

Question

0.00/5 (No votes)

See more:

how can retrieve multiple rows of a column values from DB using a stored procedure with passing parameters.

sp_getcolumnsdata( pass an input parameter and output parameters)
based on it i want to return a multiple rows of a column

Please help me

Posted 29-Nov-11 23:05pm

sandhya.T 2011

Updated 29-Nov-11 23:06pm

v2

Add a Solution

3 solutions

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)

RDBurmon · Answer 1 · 2011-12-12T00:41:00

Based on you question my understanding is as below :
You need to return column values (comma separated or tab separated) in multiple rows. Like below example :
column value is : "AB,CD,EF,GH"
return value is :
AB
CD
EF
GH

Please see below

SQL><br

create table Testdata(SomeID int, OtherID int, Data varchar(max))
insert Testdata select 1, 9, '18,20,22'
insert Testdata select 2, 8, '17,19'
insert Testdata select 3, 7, '13,19,20'
insert Testdata select 4, 6, ''


;with tmp(SomeID, OtherID, DataItem, Data) as (
select SomeID, OtherID, LEFT(Data, CHARINDEX(',',Data+',')-1),
    STUFF(Data, 1, CHARINDEX(',',Data+','), '')
from Testdata
union all
select SomeID, OtherID, LEFT(Data, CHARINDEX(',',Data+',')-1),
    STUFF(Data, 1, CHARINDEX(',',Data+','), '')
from tmp
where Data > ''
)
select SomeID, OtherID, DataItem
from tmp
order by SomeID

Eduard Lu · Answer 2 · 2011-12-12T17:35:00

What is the problem with this? you do not need output parameters to get the output rows. You can simply select it and retrieve it in ADO.NET using DataReader. Try this up:

SQL

CREATE PROCEDURE sp_getcolumnsdata
(
@Username varchar(30),
@Password varchar(30)
)
BEGIN

SELECT firstname, lastname, age, address, city -- will return multiple rows and columns
FROM   [TableName]

END

Regards,
Eduard

**AmitGajjar** · Answer 3 · 2011-12-12T17:50:00

Solution 3

Hi,

if you need to retrieve multiple rows and column only, you do not need output parameters. only you need filter condition as input parameter.

thanks
-amit.

Posted 12-Dec-11 17:50pm

AmitGajjar

how can retreive multiple rows of a column values from DB using a stored procedure with passing parameters

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0