SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Atif Sheikh / Way to Check Multiple LIKE without dynamic SQL / Latest Posts

RE: Way to Check Multiple LIKE without dynamic SQL

franp-424154 — Thu, 16 Sep 2010 12:46:08 GMT

Thanks it's good to see how others put together T-SQL and its built-in functions to come up with clever solutions. Keeps the mind nimble.

RE: Way to Check Multiple LIKE without dynamic SQL

gil.milbauer — Thu, 16 Sep 2010 12:15:52 GMT

But, if it contains both strings, you'll get it in the output twice. You may need a DISTINCT.Also, you're not really using the CROSS APPLY functionality. This could just as easily be a JOIN (using ON instead of WHERE), since your function isn't using anything from @vTable, so it doesn't need to be re-executed for each row.

RE: Way to Check Multiple LIKE without dynamic SQL

bhatta — Thu, 16 Sep 2010 04:35:42 GMT

[quote][b]Atif-ullah Sheikh (9/16/2010)[/b][hr]@adudleyyou can find fnSplit on the net. just google it and you will find the code for it.@bhattaThis is just an approach of performing a task without dynamic SQL. Otherwise, I think using dynamic sql in such situations will be more helpful.:-)[/quote]Absolutly :)fn_split :)http://bi-tch.blogspot.com/2007/10/sql-clr-net-function-split.html

RE: Way to Check Multiple LIKE without dynamic SQL

Atif-ullah Sheikh — Thu, 16 Sep 2010 04:17:02 GMT

@adudleyyou can find fnSplit on the net. just google it and you will find the code for it.@bhattaThis is just an approach of performing a task without dynamic SQL. Otherwise, I think using dynamic sql in such situations will be more helpful.:-)

RE: Way to Check Multiple LIKE without dynamic SQL

bhatta — Thu, 16 Sep 2010 02:40:26 GMT

if you use function !!! write new fn_split_find and don't use cross apply .it's will be work more faste :-D)select * from @mytbl where fn_split_find(likestring,@param) >0

RE: Way to Check Multiple LIKE without dynamic SQL

adudley — Thu, 16 Sep 2010 02:13:55 GMT

Thanks for this, I didn't know about fn_split or the CROSS APPLY.

Way to Check Multiple LIKE without dynamic SQL

Atif-ullah Sheikh — Wed, 15 Sep 2010 20:17:44 GMT

Comments posted to this topic are about the item [B]Way to Check Multiple LIKE without dynamic SQL[/B]