Store Procedure to create Insert statement from exisiting records

/* 
---------------------------------------------------------------------------------------------------------------------------------------- 
Author : Bharat Panthee

Name of the Procedure : GenerateInsertStatement
---------------------------------------------------------------------------------------------------------------------------------------- 

Purpose :This Procedure is used generate Insert  scripts for a table 

---------------------------------------------------------------------------------------------------------------------------------------- 


---------------------------------------------------------------------------------------------------------------------------------------- 

Input Parameters : Table Name, Primary value range (@strRange = starting value,  @fnlRange = final value)

 Expected Output : Generate script for Insert statement for given range of values

---------------------------------------------------------------------------------------------------------------------------------------- */ 

Create procedure GenerateInsertStatement @strRange varchar(20),@fnlRange varchar(20),@TableName varchar(300)
AS
Begin
	set nocount on
	Declare @sqlStatement varchar(2000)
	Declare @insertStatementColumnName varchar(8000)
	Declare @insertStatement nvarchar(max)
	Declare @Fetchvalue varchar(2000)
	Declare @col_Name varchar(500)
	Declare @tempcol_Name varchar(500)
	Declare @data_type varchar(100)
	Declare @tempdata_type varchar(100)
	Declare @Primary_col_Name varchar(500)
	Declare @Primaryid int
	
	if object_id('tempdb..##col_name_col','U') IS NOT NULL
	drop table ##col_name_col
		if object_id('tempdb..##fetchvalue','U') IS NOT NULL
	drop table ##fetchvalue
				
	Create table ##col_name_col(column_name varchar(500), data_type varchar(100))

	Declare column_col cursor for select Column_name,data_type from information_schema.columns where table_name = @TableName order by ordinal_position asc
	open column_col

	fetch next from column_col into @col_Name,@data_type
	set @Primary_col_Name = @col_Name
	if not exists(select [object_id] from sys.columns where [name] =  @col_Name and column_id = 1 and is_identity =1)
	begin
		set @insertStatementColumnName = @col_Name
		insert into ##col_name_col values(@col_Name,@data_type)
	end
	else 
		set @insertStatementColumnName = ''

	fetch next from column_col into @col_Name,@data_type
	while @@fetch_status =0
	begin
		if @insertStatementColumnName = ''
			set @insertStatementColumnName = @col_Name
		else
			set @insertStatementColumnName = @insertStatementColumnName + ',' + @col_Name 

		insert into ##col_name_col values(@col_Name,@data_type)
		fetch next from column_col into @col_Name,@data_type
	end
	close column_col
	deallocate column_col
	set @sqlStatement = ' declare rec_col cursor for Select ' + @Primary_col_Name + ' from ' + @TableName + '  where  ' + @Primary_col_Name + ' between ' + @strRange + ' and ' + @fnlRange
	exec (@sqlStatement)
	open rec_col
	fetch next from rec_col into @Primaryid
	While @@fetch_status = 0 
	begin
		Declare column_col cursor for select * from ##col_name_col
		open column_col
		fetch next from column_col into @tempcol_Name,@tempdata_type
		set @insertStatement = 'insert into ' + @TableName + '(' + @insertStatementColumnName + ') Values ('
		while @@fetch_status = 0
		BEGIN
			exec ('select ' + @tempcol_Name + ' into ##fetchvalue from ' + @TableName + ' where ' + @Primary_col_Name + ' = ' + @Primaryid )
			--print @tempcol_Name
			if @tempdata_type = 'datetime' or @tempdata_type='numeric' 
				set @Fetchvalue = cast ((select * from ##fetchvalue) as varchar(100))
			else 
			begin	
				set @Fetchvalue = (select * from ##fetchvalue)
			end
			if isnull(@Fetchvalue,'') = '' 
				set @Fetchvalue = 'NULL'
			drop table ##fetchvalue
			set @Fetchvalue = ltrim(rtrim(@Fetchvalue))
			if @tempdata_type = 'int' or @tempdata_type='numeric' 
			begin
			if right(@insertStatement,8)	= 'Values ('
				set	@insertStatement = @insertStatement + '' + @Fetchvalue
			else
				set	@insertStatement = @insertStatement + ',' + @Fetchvalue
			end
			else
			BEGIN	
				if @Fetchvalue = 'NULL'
				BEGIN
					if right(@insertStatement,8)	= 'Values ('
						set	@insertStatement = @insertStatement + '' + @Fetchvalue
					else
						set	@insertStatement = @insertStatement + ',' + @Fetchvalue
				END	
				else 
				begin
					if right(@insertStatement,8)	= 'Values ('	
						set	@insertStatement = @insertStatement + '''' + @Fetchvalue + ''''
					else
						set	@insertStatement = @insertStatement + ',''' + @Fetchvalue + ''''
				end	
			END
			fetch next from column_col into @tempcol_Name,@tempdata_type
		END
		set @insertStatement = @insertStatement + ')'
		close column_col
		deallocate column_col
		print @insertStatement
		set @insertStatement = ''
		fetch next from rec_col into @Primaryid
	end
	close rec_col
	deallocate rec_col
	--select * from  ##col_name_col
	drop table ##col_name_col
End