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
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: Yesterday @ 3:41 PM
Points: 3,033, Visits: 4,641
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)

"If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them." James Blackburn, in closing argument in the "Fatal Vision" murders trial
Post #1476251
Posted Monday, July 22, 2013 3:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 5,328, Visits: 12,050
Scott,
I believe that Sue is mentioning the CTE that's included in the 8K Splitter that I mentioned.



Luis C.
General Disclaimer:
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