Dynamic script.

Question

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.

Ravi Kiran Chanduri · Answer

Hi Maahi Following will work for you 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 When you are working with dynamic querytry to print it before you execute it just pint the @ClientServicecode with Print @ClientServicecod The printed result should be able to executable without any issue. If you are finding any issue  try to resolve it .

Midhun T P · Answer

Hi Please try like below - Declare @ClientServicecode as varchar (5000) set @ClientServicecode = 'select CONCAT(Client_Code' '_' 'REPLICATE(' '0' '4-LEN(RTRIM(Service_Type_Code))) + RTRIM(Service_Type_Code)) as ClientServiceCode from JobTable' EXEC (@ClientServicecode)