Reported as spam.

Reported as spam.

You need to use a CASE expression.  Using an IF inside of an INSERT/VALUES statement could potentially violate the atomicity of that statement.

Drew

It's because all of your values are defined using absolute paths instead of relative paths.  Only the nodes definition should use an absolute path.  Changing to relative paths would allow...

You already have another thread on this very topic.  Please do not start duplicate threads.  It fragments the discussion.

Drew

Reported as spam.

Reported as spam.

Reported as spam.

This is the best that we can do given the limited information that you have given us.  If you want better answers, you'll have to provide more details about exactly...

I would think that you would want to use stored procedures rather than running dynamic SQL from a database table.

Drew

Reported as spam.

Reported as spam.

Reported as spam.