SQL SERVER2000 stitching multiple rows of query results into one row of data

The results of the query before processing are as follows:

By using the definition of SQL variables

DECLARE @Scope varchar( +)DECLARE @Num int SET @Scope="'SET   @Num = 1   SELECT @Scope=@Scope+Convert(varchar(8),@Num)+','+Descscope+Descoper+';',@Num = @Num+1  fromFuel_contractqualitynewWhereContractid='012009000100'SELECTContractid,@Scope  fromFuel_contractqualitynewWhereContractid='012009000100' GROUP  byContractid

Achieve the effect:

  //Create a function that stitching describes SQLCREATE FUNCTIONDBO.F_STR (@contractID varchar( -))RETURNS VARCHAR(8000) asBEGIN        DECLARE @Scope varchar( +)        DECLARE @Num int         SET @Scope="'        SET   @Num = 1           SELECT @Scope=@Scope+Convert(varchar(8),@Num)+"'+Descscope+Descoper+';',@Num = @Num+1  fromFuel_contractqualitynewwhereContractid= @contractID        RETURN @ScopeENDGO

SQL SERVER2000 stitching multiple rows of query results into one row of data