sqldba_newbie (9/8/2011)

---

I thought of the same that package would be...

This looks very much like the same question as was asked back in January on MSDN. See here for the full thread.

select ...

from vwSearchResult

where (len(COMPANY) - len(replace(COMPANY, 'ltd', '')) + len(CategoryName) - len(replace(CategoryName, 'ltd', '')) + len(comp_kws) - len(replace(comp_kws, 'ltd', '')) + len(locStr) - len(replace(locStr, 'ltd', ''))) > 0

GROUP BY ...

engrshafiq4 (9/7/2011)

---

Hi,

this is working fine for me.

select TOP 20 COMPANY,

len(COMPANY) - len(replace(COMPANY, 'piz', ''))

as numberofoccurences

from vwSearchResult order by numberofoccurences DESC

Can i do it for more...

That will take approximately 1 minute 30 seconds!

Given that [User::_LoadAssignments] is boolean, I'm wondering if the question mark is merely evaluating if the variable is true/false--> if true, then include the additional criteria of Prov.Scope and Prov.Facility;...

Just wondering where the Mozilla reference is coming from - could Firefox be involved?

engrshafiq4 (9/6/2011)

---

@SSCrazy

ok my questions are

1) how i will load table data to tempData(in your example)?

2) what are star ,Stir,My Fab Company etc in your example....eg (select 'star' Company union...

engrshafiq4 (9/6/2011)

---

Thanks for your reply

But i am facing project Deadline and do not have much time to implement these coding...

Can you please give me a stored procedure which do the...

And here is a soundex example.

;with tempData as

(select 'star' Company union select 'stir' union select 'My Fab Company')

select company from tempData

where soundex(company) like soundex('str')

engrshafiq4 (9/6/2011)

---

i want to search the no of characters in a field and to show the record having more characters matched.

how i can do these steps in stored proceedure

1)load all...

The code sample provided by ColdCoffee works fine except that it also assumed you would want to update strDomainName. So just exclude that part of the update and you're done:

UPDATE...

Perhaps the lack of response is the result of a lack of question.

harry.sh16 (8/29/2011)

---

I already have a package that loops through different (ADO) objects and loads 3 different excel destinations dynamically, need to change excel to access destination dynamically so that it...

So which bit is giving you problems? Are you able to import the file using a fixed-width flat-file connection manager? Or perhaps it is the breaking down of the data...