Trying to produce output query results but not having any luck. Need to take a summed field and produce string output. Tried cast(field AS Varchar(5)) but it doesn't produce what I am looking for. Is there another way to format output from a query?
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.
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 …