Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
SELECT sysCode || ' - ' || codeDescription AS CodeSelection FROM sysCodes ORDER BY sysCode
BR549 - Portable Light Retriever CC212 - West Virginia Nothing Grinder FB900 - Left-Handed Metric Adjustable Wrench VS829 - Radial Spectrum Weeble Balancer
in my normal SQL code and it matches the [whatsits] to the user-selected items; but not any more. I realize that the selections are an array, but need to somehow "strip off" everything past the the "-" (which I added in the SQL statement). That's the rub - if I can just get rid of the "-" and all of the information to the right of it, the list will re-match what appears in the [whatsit] column of the table.
WHERE whasit IN (:UserSelectedStuff)
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.