— This SQL reads in a varchar(10) field called work_hours that could have anything in it. It should be numeric represented as decimal.
— The CASE statement will produce either 0.00, or (if it is numeric) whatever is in the … Read the rest
Month: May 2014
SQL Server Reporting Services (SSRS) – Remove decimal position if zero
=Replace(Round(Fields!Rate.Value,2),”.00″,””)… Read the rest
Microsoft Visual Studio – Fixing a Broken Toolbox (in Visual Studio 2010 SP1)
When starting Visual Studio 2010, it would hang for about 30 seconds trying to load the toolbox. I found this solution online and it worked for me:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++
http://michaelcrump.net/fixing-a-broken-toolbox-in-visual-studio-2010-sp1
I was recently running into a situation where every time I … Read the rest
SQL Server Management Studio – Error message when you try to save a table in SQL Server: “Saving changes is not permitted”.
This problem occurs when “Prevent saving changes that require table re-creation” option is enabled.
Solution:
Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”.… Read the rest