Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

search values in a temp table with like operator Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 2:03 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 2,029, Visits: 3,025
You don't need a CTE. In this case, it would just add complexity for no real reason that I can see .

SQL DBA,SQL Server MVP('07, '08, '09)
"In America, every man is innocent until proven broke!" Brant Parker
Post #1476251
Posted Monday, July 22, 2013 3:25 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 3,497, Visits: 7,547
Scott,
I believe that Sue is mentioning the CTE that's included in the 8K Splitter that I mentioned.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1476292
Posted Tuesday, July 23, 2013 7:42 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, September 22, 2013 4:06 AM
Points: 54, Visits: 64
Exactly! But thanks to all of you!! Great help!

Susanne
Post #1476575
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse