Hi Anukul,

This is the code i got worked.

/*

EXECUTE [SPGET_QUERY_HTML] 'select * from yourtablename'

SELECT * FROM ##TEMPhtml1

SELECT * FROM ##TEMPhtml2

*/

Create procedure [dbo].[SPGET_QUERY_HTML]

( @p_sqlstmt varchar(8000))

as

declare @columns varchar(8000)

declare @finalhtmlout varchar(8000)

declare @colHeader varchar(8000)

declare @Final varchar(8000)

Declare @sqlstmt varchar(8000)

-- drop temporary tables used.

IF EXISTS (SELECT * FROM tempdb.sys.objects WHERE name = '##TEMPhtml1')

DROP TABLE ##TEMPhtml1

IF EXISTS (SELECT * FROM tempdb.sys.objects WHERE name = '##TEMPhtml2')

DROP TABLE ##TEMPhtml2

-- prepare query

set @sqlstmt = 'select * into ##tempHTML1 from (' + @p_sqlstmt + ') as T1'

execute (@sqlstmt)

--Prepare columns details

SELECT @columns = COALESCE(@columns + ' + '' '' + ', '') + 'convert(varchar(100),isnull(' + column_name +','' ''))'

FROM tempdb.information_schema.columns where table_name='##tempHTML1'

--Prepare column Header

set @colHeader = ' '

SELECT @colHeader = @colHeader + ' '

FROM tempdb.information_schema.columns where table_name='##tempHTML1'

set @colHeader=@colHeader + ' '

--prepare final output

set @Final= 'Select '' '' into ##tempHTML2 from ##tempHTML1 '

execute( @Final)

set @finalhtmlout= ' ' + @colHeader

select @finalhtmlout= @finalhtmlout + [ ] from ##tempHTML2

set @finalhtmlout= @finalhtmlout + ' '

-- drop temporary tables used.

IF EXISTS (SELECT * FROM tempdb.sys.objects WHERE name = '##TEMPhtml1')

DROP TABLE ##TEMPhtml1

IF EXISTS (SELECT * FROM tempdb.sys.objects WHERE name = '##TEMPhtml2')

DROP TABLE ##TEMPhtml2

--return final output

select @finalhtmlout as HTMLoutput

Thanks,

Dosth