January 2012 – Page 3 – James Software Development Corner

Microsoft Outlook – Click a link restriction

If you get this error when clicking a link in Outlook…

“This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator”

…try this fix from Microsoft:

http://support.microsoft.com/kb/310049…

SQL Server Reporting Services (SSRS) – Dealing with alternating colors on rows with column sorting in a list report in SSRS Reports

Let’s say you have an address database table and you define a column for row number such as this:

SELECT ROW_NUMBER() OVER(ORDER BY LName) AS 'RowNumber',*
FROM   NameAndAddressTable
ORDER BY LName, FName

If you want to alternate between LightGrey and …

Microsoft Office 2010 Icon Problem in Windows 7

All of a sudden, my office 2010 icons defaulted to… well that ugly nothing icon. After doing a day of research, I finally found my solution here:

http://social.technet.microsoft.com/Forums/en/w7itproui/thread/d5efec0c-e967-4127-b217-15da34d7fb00

Thanks, mag00n!

First make sure you are able to view hidden and …

SQL Server – How to use a IF…ELSE statement in SQL

IF (SELECT product from product_table WHERE product_type = @productType) = 'HAM'
BEGIN 

SELECT product 
  FROM product_table
  LEFT OUTER JOIN meat_table b on b.product = product_table.product
 WHERE vendor = @vendor END 
ELSE

SELECT product
  FROM product_table
  LEFT OUTER JOIN veggie_table b

…

SQL Server Reporting Services (SSRS) – How to display all the values of a Parameter in a SSRS Report

In your expression method of the textbox, instead of:

=Parameters!someParameter.Value

Do this instead:

=Join(Parameters! someParameter .Value, ", ")

This will join all the values, separated by a comma.…

SQL Server Management Studio – How to remove “Server name” items from history

In the search box, type Command Prompt
Navigate to the root directory – Type cd\ then hit enter
Type DEL /S SqlStudio.bin and hit enter. (This should find every instance of the file and delete it from the system).

Note: …

SQL Server – Dealing with padding zeroes to fields in a SQL Select to correct sorting order

Let’s say you have a varchar field on a SQL table that is a length of 10 and it contains only integers.
If the value of one of the fields is 5, it is stored as ‘5’, not ‘0000000005’. This …

Adobe Flash CS5.5 and AS3 – Rounding to specific decimal places

I put together this paddle ball game (break out).

I set the ball speed to .5

I increment the speed by .1 after each level.

I got these results:

0.5
0.6
0.79999999
0.89999999
etc.

What I wanted was:

…

Quick Time – Fixing Quicktime Error 46: Could not load or find the QuickTime ActiveX control

Out of the blue, I get this error when trying to launch the Quicktime Player. I tried many solutions from the internet, but to no avail. I found this video that finally showed me how to fix it for me. …

Quick Time Pro – Issue when attempting to unregister Quicktime Pro 7 and re-register to a different computer

This issue drove me crazy for days. You would think the obvious solution would be to go through the Edit Menu, to Preferences, then Registration and simply remove the name and key. It appears that it is gone until you …