[dba-SQLServer] Fwd: Joining temp tables in SPROC

Francisco Tapia fhtapia at gmail.com
Fri Sep 2 10:47:01 CDT 2011


are you trying to find each instance of a string within a field?  if so that
is an interesting approach, let me know how it performs, I'm curious.



-Francisco
http://bit.ly/sqlthis   | Tsql and More...
 <http://db.tt/JeXURAx>

On Fri, Sep 2, 2011 at 12:57 AM, Mark Breen <marklbreen at gmail.com> wrote:

> Hello Francisco,
>
> I spent an hour or two yesterday morning working on my script, and I have
> to
> avoid temptation this morning to do the same.
>
> However, I cannot wait to try to implement your examples where.
>
> To further extend the exercise, I discovered yesterday that I may have
> multiple occurrences of the search string, and I need to capture each
> occurrence.  Yesterday morning, I was experimenting with finding a column
> where the string exists and then using a while loop to and charindex to
> search for all occurrences.  Does that sound right to you?
>
> Thanks for the articles, I will work on them and post back my results when
> I
> have something useful to post.
>
> Mark
>
>
>
> On 31 August 2011 17:07, Francisco Tapia <fhtapia at gmail.com> wrote:
>
> > I wrote up a script that leverages another developer's solution, I
> co-wrote
> > this article with Susan Harkins...
> >
> > http://www.devx.com/dbzone/Article/42340/1954?pf=true
> >
> > maybe you can extend or improve on what i've done to help leverage, I'm
> not
> > sure if the link will prompt you to have a free login account (i may have
> > my
> > browser cookies saved, if so I'll re-post the script here)
> >
> > http://www.devx.com/dbzone/Article/42340/1954/1763?supportItem=1
> >
> >
> > -Francisco
> > http://bit.ly/sqlthis   | Tsql and More...
> >  <http://db.tt/JeXURAx>
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list