Re: Query needs to loop?

On Thu, 25 Aug 2005 14:55:34 -0700, DonSQL2222 wrote:

>Is this possible?
>A char variable length field contains this data: (for example)
>ABC,XYZ,GEF,CAB
>I need to query another table on the contents of each of these names that
>are separated by comma.
>I need to read ABC and then query another table for ABC in field1 and pick
>up some fields.
>Then, I need to do the same for XYZ, etc, reading across.
>How can I parse the field that's comma delim, and in one continuous select
>statment pick all the data from another table? Put a looping statement into
>the Select statement to read through the comma delim field until done?
>Thanks,
>Don

Hi Don,

http://www.sommarskog.se/arrays-in-sql.html

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Query needs to loop?
    ... I need to read ABC and then query another table for ABC in field1 and pick ... How can I parse the field that's comma delim, ... Put a looping statement into ...
    (microsoft.public.sqlserver.mseq)
  • Re: Order By - Using abs formula in 2003
    ... RecordSource property to the name of the query. ... and Size of the TranAmount field. ... >>> ABC -6.55 ...
    (microsoft.public.access.forms)
  • Re: Help with Crosstab Query to transpose data
    ... SQL from the menu in query design... ... ABC 01-Jan-1980 $2.10 ... ACE 01-Jan-1980 $12.40 ... I want to write a crosstab query that will transpose (to use an Excel ...
    (microsoft.public.access.queries)
  • Re: Exporting query with duplicates
    ... Just set up a report on the query, group on ID or name, force each group to start on a new page and add the fixed text around the report data controls... ... ABC Co. ... XYZ Inc. 4545 ... for each 'ID' with a 'subform' of sorts on each form that will list all ...
    (microsoft.public.access.externaldata)
  • Re: Change of field name causes application to crash
    ... I created a simple Sum query against the underlying ... AS ArriveNet, SumAS ABC ... FROM LookupInventoryCombinedNet ... But if the yes/no field comes from a table that is on the outer side ...
    (microsoft.public.access.modulesdaovba)