Multiple values int textbox...

Hi,
I need to display the result set in a textbox,
if there are multiple rows i need to show them as comma separated..
Can anyone give me idea of how it can be achieved..
Thanks in advance,I can't think of an easy way.
You need to get the resultset concatanating, not do it in report layout.
You could use a cursor (effectively a loop) in the SQL query - get the
result set and concatanate the rows into a variable and output the
variable as the result set. Cursors are quite slow though.
You could do the same thing in VB code using ADO if that's your thing.
Chris
CCP wrote:
> Hi,
> I need to display the result set in a textbox,
> if there are multiple rows i need to show them as comma separated..
> Can anyone give me idea of how it can be achieved..
> Thanks in advance,sql

Multiple Updates In Store Procedure?

I am a total newbie to SQL Server, but have a good idea about how things operate..

I have a "job" that runs multiple (10) update queries for me in different tables.

Can I create a stored procedure to do these so that I can make one call to them?

If not, how can I call the job to start external to MS SQL?>>Can I create a stored procedure to do these so that I can make one call to them?

ofcourse. if you have all the required parameters you definetely can.

hth

multiple unnamed paramaters

Please give me an idea as to how I should be mapping my query parameters, if
i have more than one - to report parameters when using ODBC data
source(which supports only unnamed paramaters?)Related previous post:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=fe557b51-0171-46a7-9af0-6940b9e04dd2.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"NU" <vidhuvaradan@.rediffmail.com> wrote in message
news:eoGk%23lYbEHA.2812@.tk2msftngp13.phx.gbl...
> Please give me an idea as to how I should be mapping my query parameters,
if
> i have more than one - to report parameters when using ODBC data
> source(which supports only unnamed paramaters?)
>|||Thanks, that helped.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:O23MKFabEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Related previous post:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=fe557b51-0171-46a7-9af0-6940b9e04dd2.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "NU" <vidhuvaradan@.rediffmail.com> wrote in message
> news:eoGk%23lYbEHA.2812@.tk2msftngp13.phx.gbl...
> > Please give me an idea as to how I should be mapping my query
parameters,
> if
> > i have more than one - to report parameters when using ODBC data
> > source(which supports only unnamed paramaters?)
> >
> >
>