on 05-08-2016 6:22 PM
See Attached - I need a query that selects an Item Alias from a UDT.
In this query the SiteID may be blank in some cases in the UDT.
So there would be a BP Code, Item Code, and SiteID(again in some cases the SiteID may be blank in the UDT and then I only want the BP Code and Item Code.
BP Code Item Code Site ID ALIAS
AA 123 1 Fred (Fred would be selected)
BB 234 2 Dan (Dan would be selected)
CC 345 John (John would be selected even though it is blank)
My Query:
AND ISNULL(T0.[U_SiteID], 99999999) = $[ORDR.ShipToCode]
just replace your query last part with this one.
Basically u use ISNULL to change U_SiteID to a non existing value such as 9999999 in your case, and then compare with ShipToCode.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.