News

I have a parameter in a SQL Server Reporting Services report, @Status, that can have one or more values: @Status = Open @Status = Closed @Status = Neutral SSRS then of course passes it into my ...
=IIF(IsNULL(Fields!Facility.Value), "N/A", Fields!Facility.Value)Why doesn't that work in a text box in a report?My syntax is correct isn't it?It says "Name IsNULL is not declared"I just need to ...
SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...