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...

Hi..,

Thanks for the code., I got this working. but i have a trouble if the records gets more. bcoz in your code you are using varchar to hold the HTML...