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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 1,744, Visits: 2,548
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)
I'm not fat, I'm gravity challenged.
Post #1476251
Posted Monday, July 22, 2013 3:25 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 2,763, Visits: 5,906
Scott,
I believe that Sue is mentioning the CTE that's included in the 8K Splitter that I mentioned.



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

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