InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:37:41 GMT20http://www.sqlservercentral.com/Forums/Topic776445-9-1.aspxTake a look at this Article[url]http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/[/url]Tue, 25 Aug 2009 01:44:36 GMTDave Ballantynehttp://www.sqlservercentral.com/Forums/Topic776445-9-1.aspxHi,try with the case when statement[code]select * from Store.STIPR,Store.STCategory whereiprdate = (case when @IPRdate is null then iprdate else @IPRdate end) andiprno = (case when @IPRNo is null then iprno else @IPRNo end) anddeliveredto = (case when @DeliveredTo is null then deliveredto else @DeliveredTo end) andclassification = (case when @Classification is null then classification else @Classification end) andrequiredfor = (case when @RequiredFor is null then requiredfor else @RequiredFor end) andstcategoryID = (case when @STCategoryID is null then stcategoryID else @STCategoryID end) andmainstatus = (case when @MainStatus is null then mainstatus else @MainStatus end) [/code]Mon, 24 Aug 2009 23:45:46 GMTarun.sashttp://www.sqlservercentral.com/Forums/Topic776445-9-1.aspxHi ,I have the table name stipr and category with the following fields as followsiprdateiprnodeliveredtoclassificationrequiredforstcategoryIDmainstatusand category table with the field ofstcategoryIDNow my requirement is i have to write the query with the different combination as followsfor ex:declare @IPRdate datetime, @IPRNo nvarchar(50), @DeliveredTo nvarchar(50), @Classification nvarchar(50), @RequiredFor nvarchar(50), @STCategoryID nvarchar(50), @MainStatus nvarchar(50)Beginif @IPRdate !=null and @IPRNo=null and @DeliveredTo = null AND @Classification = null AND @RequiredFor = null AND @STCategoryID = null AND @MainStatus = null Begin select * from Store.STIPR,Store.STCategory where IPRdate=@IPRdate Endelse if @IPRdate !=null and @IPRNo !=null and @DeliveredTo = null AND @Classification = null AND @RequiredFor = null AND @STCategoryID = null AND @MainStatus = null Begin select * from Store.STIPR,Store.STCategory where IPRdate=@IPRdate and IPRNo=@IPRNo EndEndi have the options of searching with all the possibilities.Should i need to write all the the combination as 7X7.or else is there any possibility with the single queryMon, 24 Aug 2009 23:01:24 GMTshalini_pdi