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'…
=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'…
dbcc checkident ([table to re-seed], reseed, [value to set identity value at]) If you set the value to 0, the next inserted value will be 1
I ran into an issue the other day while importing data from an Excel file into SQL Server 2005. I had columns that contained fields that have more than 255…
This is a great tip to enable remote desktop: 1. Open the registry editor: Start --> Run --> regedit --> OK 2. Select the Connect Network Registry option under the…
Type 'gpedit.msc' at the command line Open this policy and click on 'Disabled' and then click 'OK'. To force this changes instead of rebooting just open a command window and…
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…
Sometimes services are left behind when you uninstall a program. To remove that service, just open a command prompt window and type: sc delete [service name] If you know how…
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…