SELECT 'SYNCHRO.CARDS#1#186#2#10.02.2010#3#12:03#4#3#5#' as name
into #a1

--drop table #a2;
CREATE TABLE #a2(
 	 name varchar (max)
) ON [PRIMARY]


DECLARE @all int
SET @all=(SELECT REPLACE(SUBSTRING(name,LEN(name)-2,3), '#', '')
				FROM #a1)
DECLARE @calc int
SET @calc=1
DECLARE @Param varchar(5)
DECLARE @S varchar(5)

WHILE @calc<@all
BEGIN
SET @Param=STUFF('# #', 2, 1, REPLACE('# #', '#', '')+@calc)
SET @S=STUFF(@Param, 2, 1, REPLACE(@Param, '#', '')-1)
insert into #a2
SELECT SUBSTRING(name,CHARINDEX(@S,name)+case when @S='#0#' then 0 else 3 end,CHARINDEX(@Param,name)-(CHARINDEX(@S,name)+case when @S='#0#' then 0 else 3 end)) as params
FROM #a1

SET @calc=@calc+1

END;