Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
;with tmp(VEND_ITEM_NO, MFG, MODEL, Data) as ( select VEND_ITEM_NO, MFG, LEFT(MODEL, CHARINDEX(',',MODEL+',')-1), STUFF(MODEL, 1, CHARINDEX(',',MODEL+','), '') from USER_TEMP_TABLE1 where MFG in ('SONY') union all select VEND_ITEM_NO, MFG, LEFT(Data, CHARINDEX(',',Data+',')-1), STUFF(Data, 1, CHARINDEX(',',Data+','), '') from tmp where Data > '' ) select VEND_ITEM_NO, MFG, MODEL from tmp order by VEND_ITEM_NO
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.