The value of the same field is displayed in a tag stored procedure.

The principle is to add the result to a declared field, and then check it out.

 

Declare @ output varchar (8000)
Select @ output = coalesce (@ output, '') + product + ','
From khinfoyxcp
Select left (@ output, Len (@ output)-1)

Declare @ output varchar (8000), @ khmc varchar (100)
Select @ khmc = kd_khmc, @ output = coalesce (@ output, '') + product + ','
From khinfo a inner join khinfoyxcp B on A. PID = B. PID
Select @ khmc as khmc, left (@ output, Len (@ output)-1) as [Output] into # B

The value of the same field is displayed in a tag stored procedure.