set @FOUR_LEVEL_SCALE = 0

set @FIVE_LEVEL_SCALE = 0

set @SIX_LEVEL_SCALE = 0

set @AUTOMATIC_EXAMPLE_SCALE = 0

end

insert into @temporary_Statistics_tmpTable values(@NAME,'''+@type+''',@EXAMPLE_GUID,@STORY_URL,@EXAMPLE_TOTAL,@ZERO_LEVEL_SCALE,@ONE_LEVEL_SCALE,@TWO_LEVEL_SCALE,@THREE_LEVEL_SCALE,@FOUR_LEVEL_SCALE,@FIVE_LEVEL_SCALE,@SIX_LEVEL_SCALE,@AUTOMATIC_EXAMPLE_SCALE,@COUNTNUM);

set @count=@count-1

end

if object_id(''tempdb..#tmp'') is not null

begin

drop table #tmp

end;

if object_id(''tempdb..#tmptable'') is not null

begin

drop table #tmptable

end

select * from @temporary_Statistics_tmpTable

'

EXECUTE SP_EXECUTESQL @RunSQL