Re: Stored Procedure help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 02/09/05 

Date: Wed, 9 Feb 2005 16:15:42 -0500

Actually, "Aggregate Concatenation" does appear to be its "official" name:

http://support.microsoft.com/default.aspx?scid=kb;en-us;287515 

-- 
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:uVGLkwuDFHA.2508@TK2MSFTNGP09.phx.gbl...
> dspa wrote:
> > Hi everybody,
> > I'm new to Sqlserver and I have to solve this problem using a stored
> > procedure:
> >
> > I have a simple table tab1 (int a, varchar(255) b)
> > My stored procedure should do this:
> >
> > mystored( varchar(255) in) returning out varchar(4000) )
> >
> > select * from tab1
> >
> > foreach row
> > out = out + currentrow.a + " - " + currentrow.b
> > end foreach
> >
> >
> >
> > Sorry, but I still don't know the t-sql syntax.
> > Can someone help me?
> >
> > Thank you in advance
>
> See this thread:
>
http://groups-beta.google.com/group/microsoft.public.sqlserver.programming/browse_frm/thread/2d87fe75c32fe408/f758f03fd96c1452?q=aggregate+concatenation+author:Bob+Barrows&_done=%2Fgroups%3Fq%3Daggregate+concatenation+author:Bob+Barrows%26hl%3Den%26lr%3D%26c2coff%3D1%26rls%3DGGLD,GGLD:2003-36,GGLD:en%26sa%3DN%26tab%3Dwg%26&_doneTitle=Back+to+Search&&d#f758f03fd96c1452
>
> Bob Barrows
>
> -- 
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Relevant Pages

  • Re: Createobject of (null) caused exception C0000005
    ... Aaron [SQL Server MVP] wrote: ... >> coming from my stored procedure. ... with more or less effort or performance impact in the database tier. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Stored Procedure help
    ... SQL Server MVP ... "dspa" wrote in message ... > My stored procedure should do this: ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure help
    ... > I'm new to Sqlserver and I have to solve this problem using a stored ... > My stored procedure should do this: ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... You will get a quicker response by posting to the newsgroup. ... SQL Server MVP ... Columnist, SQL Server Professional ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... You will get a quicker response by posting to the newsgroup. ... SQL Server MVP ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)