SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Carleton / Wild Join Question / Latest Posts

RE: Wild Join Question

BudaCli — Wed, 06 Jan 2010 03:21:31 GMT

[quote][b]Chris Carter-210078 (12/30/2009)[/b][hr]The complete answer should be “It depends”. If you have a case sensitive collation designator you will get:Msg 208, Level 16, State 0, Line 3Invalid object name '#table1'.Since the script created a table #Table1 and tries to reference #table1[/quote] You're correct but based on what's given then you'll need to set collation to something that will provide with results for this scenario.

RE: Wild Join Question

Chris Carter-210078 — Wed, 30 Dec 2009 08:06:51 GMT

The complete answer should be “It depends”. If you have a case sensitive collation designator you will get:Msg 208, Level 16, State 0, Line 3Invalid object name '#table1'.Since the script created a table #Table1 and tries to reference #table1

RE: Wild Join Question

sknox — Thu, 24 Dec 2009 05:57:48 GMT

[quote][b]Hugo Kornelis (12/24/2009)[/b][hr][quote][b]Carleton (12/23/2009)[/b][hr]If you are unsure if the field contains a wildcard character when joining using the LIKE operator, you can avoid false positive results by observing this tip:[/quote]But what is the point of using LIKE if you do this? Why not simply use the = operator?[/quote]In general, you probably wouldn't use LIKE exactly like that, but with your own wildcards attached. For example, you may want to see if a string contains another string in its entirety. If the second string might have a wildcard in it, you'd have to do something like:[code="sql"]select * from #table1 t1 inner join #table2 t2 on t1.Col1 like '%' + REPLACE(REPLACE(t2.Col1,'%','[%]'),'_','[_]') + '%'[/code]Otherwise, the wildcard in the second string may cause false positives.

RE: Wild Join Question

Hugo Kornelis — Thu, 24 Dec 2009 05:10:27 GMT

[quote][b]Carleton (12/23/2009)[/b][hr]If you are unsure if the field contains a wildcard character when joining using the LIKE operator, you can avoid false positive results by observing this tip:[/quote]But what is the point of using LIKE if you do this? Why not simply use the = operator?

Wild Join Question

Carleton — Wed, 23 Dec 2009 22:14:47 GMT

Comments posted to this topic are about the item [B]Wild Join Question[/B]