Quick thought, as this is straight forward in T-SQL, why not do this in the source query?

😎

USE tempdb;

GO

DECLARE @TESTDATA TABLE

(

ID INT NOT NULL

,FNAME VARCHAR(8) NOT NULL

,QTY INT NOT NULL

);

INSERT INTO @TESTDATA(ID,FNAME,QTY)

VALUES

( 1,'John',2)

,( 2,'Paul',4)

,( 3,'Georg',8)

,( 4,'Ringo',16)

,( 5,'Peter',32)

,( 6,'Paul',64)

,( 7,'Mary',128)

,( 8,'Paul',256)

,( 9,'Art',512)

,(10,'Steve',1024);

SELECT

TD.ID

,STUFF(REPLICATE(CHAR(32),8),1,LEN(TD.FNAME),TD.FNAME) AS FName

,REPLICATE(CHAR(48),6 - LEN(CAST(TD.QTY AS VARCHAR(6)))) + CAST(TD.QTY AS VARCHAR(6)) AS Qty

FROM @TESTDATA TD;

Results

ID FName Qty

--- -------- ------

1 John 000002

2 Paul 000004

3 Georg 000008

4 Ringo 000016

5 Peter 000032

6 Paul 000064

7 Mary 000128

8 Paul 000256

9 Art 000512

10 Steve 001024