declare @tempTbl table( catid as int, subcatid as int,prod_id as int, productname as varchar(100) ,imagename as varchar(100),unitprice as int,listprice as int,onsale as varchar(100), hotprod as varchar(100), prodDescription as varchar(100), caption as varchar(100), title as varchar(100) , prodfilename as varchar(100),rating as int,psubtype as varchar(100),sizelabel as varchar(100))