Search results

  1. P

    Question No value given for one or more required parameters on join

    Yeah unfortunately this is giving me the same value for each Vendor. I wonder why it can't see the outer query?
  2. P

    Question No value given for one or more required parameters on join

    I'll try that InertiaM, not sure it will work for what I need in this situation. I will let you know. I may have to rethink my logic. Thanks! Paul
  3. P

    Question No value given for one or more required parameters on join

    :confused:Hello All, I have the following SQL query that runs against an Excel datasource and I'm getting the infamous "No value given for one or more required parameters" because of a join. It's erroring on the where t1.[trnVendorName] = v.[Vendor] part. It is acting like it can't see the...
Top Bottom