create the Store Procedure create Dynamic Query and Paging
Here we Create Store Procedure For the Create the Dynamic Query and also paging and also insert data when page no is first Create Procedure Gia_Search ( @Shape varchar ( 64 )= '' , @color Varchar ( 64 )= '' , @purity varchar ( 64 )= '' , @polish varchar ( 64 )= '' , @cut Varchar ( 64 )= '' , @pricemax varchar ( 50 )= '' , @pricemin varchar ( 50 )= '' , @caratMax varchar ( 50 )= '' , @caratmin varchar ( 50 )= '' , @symm varchar ( 64 )= '' , @fls varchar ( 64 )= '' , @userid varchar ( 64 )= '' , @PageNumber varchar ( 50 )= 0 , @PageSize Varchar ( 50 )= 0 ) As Begin SET NOCOUNT ON ; Declare @Search varchar ( max )= '' , @wherclause varchar ( max )= '' if @PageNumber = '1' begin insert into gia_search_history ( user_id , shape_seq , color_seq , purity_Seq , Polish_s