Search pattern - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Search pattern

Author

Topic

Dev@nlkss

134 Posts

Posted - 2008-12-15 : 10:00:16

Hi Visakh,
Its Working fine
thanks for ur reply
i have one more requirement
its really urgent

I am Working on Filter criteria...Filter criteria should allow user to retreive names that match any/all of criteria entered from 6 textboxes...
which is the best way to write a query.
if i am not clear plz forgiv and try to understand
its really urgent
thanks in advance

Satya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-15 : 10:40:00

just make a procedure with 6 parameters @Param1,@param2,...@Param6
then pass values from 6 textboxes to sp
then in sp the where condition will like


WHERE (field1=@Param1 OR @param1 IS NULL)
AND (field2=@Param2 OR @param2 IS NULL)
AND (field3=@Param3 OR @param3 IS NULL)
....
AND (field6=@Param6 OR @param6 IS NULL)

also make default values of parameters as NULL

Dev@nlkss

134 Posts

Posted - 2008-12-16 : 03:49:53

Hi visakh,
its working
thanks a lot
and i also have to work on DBA apsects
my basic areas are
1.daily backups
2.performance tuning
3.index creation
is there any material or free online links for these topics
plz sugest me
and also on sql reporting services

Satya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources