for two integers @i & @j-2

the following should work

( looks like a slight overkill I know! )

select POWER(10,FLOOR(LOG10(@i)))*(FLOOR(@i)/POWER(10,FLOOR(LOG10(@i))))

*

...

you may need to repeat MOM's tip but using CHAR(10) - Line Feed and CHAR(13) - Carriage return. CHAR(9) is TAB.

On the other hand if you can preserve these...

try

declare @cmd varchar(255)

select @cmd = '"echo ' ? @cola ? ' ' ? @colb ? ' > c:\testsql.txt"'

exec master..xp_cmdshell @cmd , nooutput

(NB - change the ?'s to concat...

why not just Union the table with itself?

try using dynamic sql in the SP e.g.

EXEC ("Select * from " + @msLookUptable)