I thought the solution presented fixed the problem, however it did not.
The attached documents show the error messages after a couple different changes to the expression.
I can't find any examples of expressions that add multiple numeric fields after the "THEN" portion of the CASE WHEN expression.
Is this type of statement just not valid? case.docx CASE-WHEN-errors.docx
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …