Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anoi90
Starting Member
1 Post |
 Posted - 2014-10-07 : 12:48:06
|
| Hello everyone,I am new to SQL and I've never done it before. I begin to learn to make my daily task easier and less dependable on other team - slow process.Daily, I have to map thoursands of items into its correct category. Please see the attached for more information. What I have to do is Filter item by the ClSID and SCLISD, then look into the Label for where the item should be. For example from the attachment, CLSID = 1 and SCLSID = 23 - if in the label has the keyword "notebook", its NEW_CAT should be 14 and its NEW_CATNAME is LAPTOPS; CLSID = 1 and SCLSID = 23 - if in the Label contains Tablet PC, its NEW_CAT name should be 2474 and its NEW_CATNAME is PC LAPTOPS.CLSID = 3 and SCLSID = 54 - if in the Label contains Watch, its NEW_CAT name should be A6052 and its New_CATNAME is SMART WATCH.Basically, the work flow is looking into the CLSID, then SCLSID,then, Label and then assign a correct NEW_CAT and NEW_CATNAME of the item.I have written a code helping me but I can't get it look into specific CLSID and SCLSID.For example, i havewhen upper(Label) like upper ('%Tablet%PC%') then '2474 PC Laptops'Thank you for your help I couldn't attach either the file or image. Please lets me know if my explanation helps.Thank you, |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-07 : 13:38:15
|
| Please post your whole query, not just a bit of a case statement. |
 |
|
|
|
|
|
|
|
SQL auto search partial text string