Dynamic script.

Declare @ClientServicecode as varchar(5000)

set @ClientServicecode = select Client_Code + '_' + REPLICATE('0',4-LEN(RTRIM(Service_Type_Code))) + RTRIM(Service_Type_Code) as ClientServiceCode

from JobTable

 

exec  @ClientServicecode

 

getting issue while framing a dynamic query of above.