Recursive SQL statment using CTE “With as”

having such a table in a MS SQL Server 2005

where the table represents some employees and their tree structure in the organization, where each employee has a foreign key “ManagerID” which is  the ID of another Employee in the same table, and this table is represented with the following tree

Manipulating Visio “Shape Data” using VBA

recently i needed to write a macro that processes an MS  Visio 2007 page and and does some actions based on the contents of a custom defined stencil shapes, where this contents are saved as a Shape Data field in the shape

Coders who don’t code

Today was my first day at work, in a company called Andaulsia Healthcare Business Solutions  “AHBS” in my beloved Alex.

kind of i was surprised by the coding approach used there, it’s simply “No Coding”

Troubleshooting in ACM-ICPC Contest

i’ve participated in many contests as organizer, specifically in the technical stuff which is mainly two portions

• The IDE which is mainly “eclipse“
• The contest communication tool which can’t be except “pc2″

and in the last contest i’ve participated in it’s technical preparations i faced a number of troubles

lets take them one by one

1.Teams don’t connect to the Server which is a Linux Machine

• Solution : before you open the server edit the “pc2server” file and edit this line
• java -Djava.security.policy=policy.ini $PC2CN $*
• to be
• java -Djava.rmi.server.hostname=”10.106.0.35″ -Djava.security.policy=policy.ini $PC2CN $*
• of course change the ip according to your server ip

and make this edit in all the executables you will run {team, board, judge…..}