SSRS Switch Statement

=Switch(Fields!Orders.Value < 100,"Red", Fields!Orders.Value > 100, "Green") The above statement is an example on how to use the 'Switch' statement in SQL Server Reporting Services. This example checks the 'Orders'…

Regular Expression

To replace or insert a character at the end of any line: Find what: \n Replace with: [what ever you want]\n To insert a new line: Find what: [character to…

SQL Keyword Search

Here's a quick code snippet to search through all the stored procedures in a SQL Server database for a keyword: SELECT o.object_id, o.name, SQLM.Definition FROM sys.objects o LEFT OUTER JOIN…