🚀 go-pugleaf

Dear Jens S��meyer,

how do it in create procedure?.
rick

>
> you have to put the strigs all together, bute till you don�t post some ddl
> and exmplae data its not very easy to help you. The first thing, is to do
> this query with a function that concas these values together:
> 
> ---Untested, because of missing examples:
> 
> DROP Function fn_Myfunc
> 
> CREATE FUNCTION fn_Myfunc(@COL int)
> RETURNS VARCHAR(30)
> AS
> BEGIN
>  DECLARE @W VARCHAR(30)
>  DECLARE @EXAM varchar(50)
>  SET @W = ''
>  SELECT @W = @W + CAST(examname AS VARCHAR(10)) + ' ' FROM temptable  WHERE
> studentID=@COL
>  SELECT @EXAM=examname FROM temptable WHERE studentID=@COL
>  If @EXAM IS NOT NULL
>  BEGIN
>    SET @W = LEFT(@W,LEN(@W)-1)
>  END
>  RETURN @W
> END
> GO
> 
> SELECT StudentID,[P/F],dbo.fn_Myfunc(StudentID) as Exams
> FROM temptable
> 
> But for this, tables must be non temporary, because of working in a
> function.
> 
> HTH, Jens S��meyer.
> 
> > #temptable (studentID,p/f,examid,examname):
> > 1   p
> > 2   f    100  bio
> > 2   f    101  mTH
> > 2   f    102  CHM
> > 2   f    103  spts
> > 2   f    104  LIT
> > 2   f    107  geo
> > 2   f    109  phys
> > 2   f    110  eng
> > 2   f    111  hist
> > 3   p
> > 4   f    100  bio
> > 4   f    102  chm
> > 4   f    109  phys
> > 4   f    110  eng
> >
> > #tempResult:
> >
> > (studentid,p/f,1st,2st,3rd,4th,5th)
> > 1  p
> > 2  f   bio  math  chm  spts  lit
> > 3  p
> > 4  f   bio  chm  phys  eng
> >
> >
> > what query turns #temptable to #tempresult?.
> > rick
> >
> >
> >
> >
> > --
> > Sent  by  ricksql from yahoo in field com
> > This is a spam protected message. Please answer with reference header.
> > Posted via http://www.usenet-replayer.com/cgi/content/new
> 
> 


 





-- 
Spam protected message from: 
Sent  by ricksql from yahoo piece from  com
Posted via http://www.usenet-replayer.com/cgi/content/new