Comments by Bharath from India (Top 5 by date)

I am looking for something like this :
insert into #temptable
exec dbo.spGetInformation @input
where output_of_sp= condn

I dont have permission to edit the spGetInformation to include an output param

select * from dbo.FUNCTION_split('1,2,3',',') OPTION (MAXRECURSION 0)
This in one of the fixes i have figured out..
Any other suggestions are welcome!!

I am using this split function inside a stored procedure