Timeline for How to find all positions of a string within another string
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 2, 2015 at 16:44 | comment | added | bummi | @Misiu as expected Aaron Bertrands solutions is not just more elegant but even much faster then mine and should be the accepted solution. You may test this easily with a bigger input, using his example just add SET @name=Replicate(@name,5000) before the call SELECT pos FROM dbo.FindPatternLocation(@name, 'ali'); and try the same with my slow procedure. | |
| Nov 2, 2015 at 12:16 | comment | added | Misiu |
I know this is old question, but I have question about performance. I've build two functions that search of 1 in string that contains only zeros and ones. I've used Your solution and @aaron-bertrand, but I got same results and same performance. Which solution would it better?
|
|
| May 11, 2013 at 9:07 | vote | accept | Ario | ||
| May 11, 2013 at 8:59 | history | edited | bummi | CC BY-SA 3.0 |
added 825 characters in body
|
| May 11, 2013 at 8:38 | history | answered | bummi | CC BY-SA 3.0 |