DECLARE @user int , @field int , @text varchar(50) DECLARE @currentuser int DECLARE @currentdata varchar(255) DECLARE UserCursor CURSOR FOR SELECT user_id, field_id, textarea FROM UserInfo ORDER BY user_id, field_id OPEN UserCursor FETCH NEXT FROM UserCursor INTO @user, @field, @text set @currentuser=@user set @currentdata = @text WHILE (@@FETCH_STATUS = 0) begin FETCH NEXT FROM UserCursor INTO @user, @field, @text if @currentuser=@user set @currentdata = @currentdata +' '+ @text else begin print @currentdata set @currentdata = @text set @currentuser = @user end END print @currentdata CLOSE UserCursor DEALLOCATE UserCursor
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT COALESCE(T_Nom.textArea, 'N/A') + ' ' + COALESCE(T_prenom.textArea, 'N/A') + ' ' + COALESCE(T_adresse.textArea, 'N/A') FROM MaTable AS T_Nom LEFT OUTER JOIN MaTable AS T_Prenom ON T_Nom.user_id = T_Prenom.user_id AND T_Prenom.field_id = 18 LEFT OUTER JOIN MaTable AS T_Adresse ON T_Nom.user_id = T_Adresse.user_id AND T_Adresse.field_id = 21 WHERE T_Nom.field_ID = 16