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

Mark Breen marklbreen at gmail.com
Fri Sep 2 02:57:38 CDT 2011


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>
>
>


More information about the dba-SQLServer mailing list