How to match MS SQL query value to a list of String Constants
Posted on 2009-02-23
I'm converting a series of payroll reports from IQ Objects (Informix) to MS SQL Reporting Services with SQL Server 2005. The SQL Query reads a data element representing a Department Number. I need to take this value and concatenate a string value representing the department number and name. For example, the returned value for my department is 15060. I want to display this in the report as 15060-MIS. I'm using MS Business Intelligence Studio as the development tool. Any Help with the source code is greatly appreciated.