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

help searching multiple words Expand / Collapse
Author
Message
Posted Sunday, April 21, 2013 2:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:18 AM
Points: 32, Visits: 326
Cool, thank you. Meanwhile i was trying to solve using my old attempt, got it also ..finally )

declare @Phrases TABLE
(
phrase varchar(100)
)

DECLARE @Searchs TABLE
(
word varchar(100)
)

declare @NumberWords tinyint

insert into @Searchs (word) select item from dbo.DelimitedSplit8K('they angry', ' ')

Select @NumberWords = COUNT(*) from @Searchs

insert into @Phrases values ('First time you''ve seen a giant, Jon Snow?')
insert into @Phrases values ('Well, don''t stare too long. They''re shy.')
insert into @Phrases values ('When they stop being shy, they get angry.')
insert into @Phrases values ('And when they''re angry,')
insert into @Phrases values ('I''ve seen them pound a man straight into the ground')
insert into @Phrases values ('like a hammer on a nail.')

select * from (select phrase, @NumberWords as NW,COUNT(phrase) as NP from @Phrases
inner join @Searchs on phrase like '%' + word + '%'
group by phrase) as Tmp
where Tmp.NW=Tmp.NP

Post #1444821
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse