Revision history  [back]

1- proerty code (suggestionquery)تقوم بعمل بارميتر

2-value select distinct top 75 s.code,s.name1,s.name2 from SizesAndColors s left join InvItem i on i.id = s.invItem_id where i.code = {FromSubCode} and (s.code like '%'+{sizeandcolor}+'%' or s.name1 like '%'+{sizeandcolor}+'%' or s.name2 like '%'+{sizeandcolor}+'%' )