Forum Discussion
Reference a value in a table to use in another SQL power Query
Hi All I have a value held in another PQ table. 1 row 1 column containing an invoice number. - Is it possible to use this particular invoice number and use in a SQL query without having to go int...
Double quote missing before the closing square bracket I think.
I notice you're missing a table alias for your SHIP_DATE_RETURN, not sure if that will cause you any abiguity issues.
This is just the query portion, make sure it goes inside the correct ().
[Query=" SELECT rd.SERIAL_NUMBER , rd.REF_NUM , rd.MODEL_ASC , pm.MODEL , rd.MOTO_PART_NUMBER , rd.ASC_SITE_ID , ras.ASC_SITE_NAME , rd.REPAIR_TYPE , acm.ASC_CUSTOMER_NAME , rd.WARR_CODE , rd.RMA_CREATION_DATE , rd.EXPIRY_DATE , rd.RECV_DATE , rd.SHIP_DATE_RETURN , rd.UNIT_STATUS , rd.PROJECT_NAME , rd.FINAL_UNIT_DETERMINATION , rd.INVOICE_NUMBER , rd.INVOICE_DATE , ROUND((SHIP_DATE_RETURN - rd.RECV_DATE)) AS AGE , (rd.RECV_DATE + 30) AS TAT , rd.LABCOST , rd.FREIGHT_COST FROM rdwadmin.rdw_repair_details rd , rdwadmin.rdw_part_master pm , rdwadmin.rdw_asc_customer_master acm , rdwadmin.rdw_asc_site ras WHERE rd.moto_part_number = pm.moto_part_number AND rd.ASC_CUSTOMER_NUMBER = acm.ASC_CUSTOMER_NUMBER AND rd.ASC_SITE_ID = ras.ASC_SITE_ID AND rd.INVOICE_NUMBER = '"& #"Current-Invoice"[CurrentInvoice]{0} &"' "]
KNP and if OP wants to pass on directly a query to SQL
let
Source = Sql.Database("serverName", "dbName", [Query="select * from tbl where WO='"&Table[C1]{0}&"'"])
in
Source
Table is following
Hi smpa01
Apologies, i only just read your reply. I have tried to pass to the SQL query and did have a couple of issues with PQ not liking the code, but it seems to have accepted an edited version.
However it does not bring any data back.
Really appreciate your support š