Search results

  1. C

    Loop through a table to find value and us in SQL query

    Yes, thanks, did see reply 5. Yes, there are a lot of columns with similar naming conventions. It comes from a file pulled from a billing system that is provided in the format. Once you get the DB you'll see the V2 table which is the main table. In essence I'm trying to figure out which...
  2. C

    Loop through a table to find value and us in SQL query

    I think I know my problem/limitation. I'm trying to use a record value from a table as a reference to a column name in a query (see bold below). I don't know if this is possible and if so how to make it work. INSERT INTO V2_Amend ( customer_id, customer_name, Defendant_Watch_46 ) SELECT...
  3. C

    Loop through a table to find value and us in SQL query

    That is a big part of my issue I think. I don't know the correct format for the field references. Also, I want the field reference to also be a label in the query, which is usually set with "label" inverted commas.
  4. C

    Loop through a table to find value and us in SQL query

    So after years of getting great value from the site I've been stumped and need to post my first question! Thanks for all the advice in advance and sorry of the questions seems overly simple. I'm trying to grab a name in the ProductsXref table and use it in a query that appends records to a...
Top Bottom