filter conditions based on condition..

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

I think you're looking at catch all queries.

Try this blog post by Gail[/url]

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Phil Parkin SSC Guru Points: 247183 More actions · Answer 2

Your selection logic is flawed. You should read Gail's article, but I think that this would be closer to what you need:

select * from test_data

where Eid = (case when @param='%' then Eid else @param end)

No doubt you already know this, but using select * is generally considered bad practice.

m4x SSC Enthusiast Points: 186 More actions · Answer 3

SSC Enthusiast

Points: 186

January 5, 2012 at 3:53 am

thanks Phil, i do know the implications of *..

m4x SSC Enthusiast Points: 186 More actions · Answer 4

Cadavre (1/5/2012)
I think you're looking at catch all queries.
Try this blog post by Gail[/url]

-- thanks for the way.. works better now..:)