MS SQL Server MSEQ - Re: Break out Pipe Values

Author

Re: Break out Pipe Values

Phil

2006-10-24, 6:49 pm

Hi Arnie,

Thanks for the response, those links were great.

The only problem that I have is that I need the employment ID each time I
get one of the area codes and the code from the links just breaks up the area
codes but does not allow me to get any other fields of data, if you can offer
and more advice or links it would be much appreciated.

Thanks Phil

"Arnie Rowland" wrote:

> You are treating a field like an array. It's not really a good idea -as you
> are finding out.
>
> Look up the use of patindex() in Books Online. I think that you will become
> very good at using patindex().
>
> Also, these resources may help you.
>
> Arrays and Lists in SQL Server
> http://www.sommarskog.se/arrays-in-sql.html
> http://www.realsqlguy.com/?p=9
> http://www.aspfaq.com/2248
> http://realsqlguy.com/twiki/bin/vie...g
ToTable
> 2005-
> http://omnibuzz-sql.blogspot.com/20...-recursive.html
>
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:9BDC616D-590D-468C-BB80- FB3FBFC1703C@microso
ft.com...
>
>
>

Arnie Rowland

2006-10-24, 6:49 pm

I'm sure, that if you will look though that material again, you will see
that it is a easy task to include additional columns from the table -even as
you are deconstruction a single field.

Having the deconstructed data, without any way to relate it to the remainder
of the data would be worthless -n'est-ce pas?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:1A886F4B-9AEC-44F0-A7D2- C7126DC9965C@microso
ft.com...[color=darkred]
> Hi Arnie,
>
> Thanks for the response, those links were great.
>
> The only problem that I have is that I need the employment ID each time I
> get one of the area codes and the code from the links just breaks up the
> area
> codes but does not allow me to get any other fields of data, if you can
> offer
> and more advice or links it would be much appreciated.
>
> Thanks Phil
>
> "Arnie Rowland" wrote:
>

Sponsored Links