Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tune up this SP
Message
From
31/05/2002 13:55:40
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
31/05/2002 13:25:27
Rajesh Halyal
Raj Software
Sangli, India
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: How to tune up this SP
Miscellaneous
Thread ID:
00663553
Message ID:
00663572
Views:
11
I would use a conditional statement. if name is NULL then have your select not include the name field in the where clause and if it is not null then include it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform