declare @comando sysname; DECLARE @IdUF varchar(2) DECLARE @DcrUF varchar(100) DECLARE cur CURSOR FOR SELECT IdUF, DcrUF FROM tUF OPEN cur set @comando = 'del d:\teste.txt'; EXEC master..xp_cmdshell @comando FETCH NEXT FROM cur INTO @IdUF, @DcrUF WHILE (@@FETCH_STATUS = 0) begin set @comando = 'echo ' + @IdUF + ' ' + @DcrUf + ' >> d:\teste.txt'; EXEC master..xp_cmdshell @comando FETCH NEXT FROM cur INTO @IdUF, @DcrUF end CLOSE cur DEALLOCATE cur EXEC master..xp_cmdshell 'type d:\teste.txt > caminho_da_impressora'; --(se for local coloque LPT1, se for na rede coloque o endereço \\servidor\impressora) EXEC master..xp_cmdshell 'del d:\teste.txt'