Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning CASE statement versus dynamic Query RE: CASE statement versus dynamic Query
sergeyledenev
SSC Enthusiast
Points: 130
More actions
February 8, 2012 at 4:41 pm
#1444837
I was using the xml format for the output. Tha app sorted the set by itself. The major benefit is the indexed value field - which is any of the contact's info.
As there should be the reasonable amount of records - the task is affordable for the app