Database

DROP TABLE #Teste;
CREATE TABLE #Teste (
   IDField1 int
);
DECLARE @x int;
SET @x = 5;
IF (@x > 1)
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;
ELSE 
BEGIN
   INSERT INTO #Teste
   SELECT IDField1
   FROM   Table1;
END;

select convert(int, substring(data.field, 1, 1)) * 1,
       convert(int, substring(data.field, 2, 1)) * 2,
       convert(int, substring(data.field, 3, 1)) * 3,
       convert(int, substring(data.field, 4, 1)) * 4,
       convert(int, substring(data.field, 5, 1)) * 5,
       convert(int, substring(data.field, 6, 1)) * 6,
       convert(int, substring(data.field, 7, 1)) * 7,
       convert(int, substring(data.field, 8, 1)) * 8
       ...
from (select convert(varchar(63), 10101010101010)
       + replicate('0', 63-len(convert(varchar(63), 10101010101010))) as field
       ) data

declare @S as nvarchar(63)
set @S = '10101010101010'

declare @NS as nvarchar(128)
set @NS=''
declare @Len as int
SET @Len = LEN(@S)

declare @Counter as int
SET @Counter = 1
WHILE @Counter < = @Len
BEGIN
	if (SUBSTRING(@S,@Counter,1)='1')
		set @NS = @NS + ' ' + convert(nvarchar,@Counter)
	SET @Counter = @Counter + 1
END
select @NS