Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
How can I modify the above query in such a way that , it checks for split column, if the split is not <> 100 then it separates vendor_code separately under 2 columns vendor1_code and vendor2_code. If the split = 100 then generates vendor1_code
select dv.VENDOR_CODE,dv.VENDOR_NAME, d.THISDATE, sum(po.QUANTITY) , rfp.VENDOR_SHARE_PERCENT as SPLIT from fact_po_lines po inner join dim_product p on po.dim_product_id = p.dim_product_id and p.product_sku = '02128087' INNER JOIN DIM_DATE d ON po.ORDERED_DATE_ID = d.DIM_DATE_ID INNER JOIN FACT_PA_ITEM pai ON po.DIM_PRODUCT_ID = pai.DIM_PRODUCT_ID and po.DIM_VENDOR_ID = pai.DIM_VENDOR_ID INNER JOIN DIM_VENDOR dv ON po.DIM_VENDOR_ID = dv.DIM_VENDOR_ID INNER JOIN DIM_DATE deff ON pai.DIM_DATE_EFFECTIVE_ID = deff.DIM_DATE_ID INNER JOIN DIM_DATE dexp ON pai.DIM_DATE_EXPIRATION_ID = dexp.DIM_DATE_ID INNER JOIN DIM_VENDOR dv ON pai.DIM_VENDOR_ID = dv.DIM_VENDOR_ID INNER JOIN DIM_PRODUCT p ON pai.DIM_PRODUCT_ID = p.DIM_PRODUCT_ID INNER JOIN FACT_RFP_PRODUCT rfp ON pai.SOURCE_RFP_ID = rfp.SOURCE_RFP_ID and pai.DIM_PRODUCT_ID = rfp.DIM_PRODUCT_ID and pai.DIM_DATE_EFFECTIVE_ID = rfp.DIM_DATE_CREATE_ID where d.THISDATE = '19-DEC-14'-- and d.thisdate < '31-DEC-15' and d.thisdate between deff.THISDATE and dexp.THISDATE group by dv.vendor_code, dv.vendor_name, d.thisdate, rfp.vendor_share_percent order by d.thisdate, dv.vendor_code;
|How to add a suffix to a value in a column based on the value in another column||4||32|
|Return Rows as per Quantity of Columns Value In SQL||6||29|
|Error in sql query statment.||21||52|