- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
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)
|SSRS reports -- "The subscription encrypted content was removed."||63||80|
|SQL Server 2008 R2 - Execution Plan||3||28|
|t-sql look for records in two tables||2||19|
|SSRS 2008 Multi Value Parameter Filter using OR||3||18|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!