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 query,try 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)

Dynamic script.

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)