I fixed it.

there was nothing wrong with the if's.

first problem is I didn't write all the fields in the INSER INTO <table> (...All Fields...)

second is I didn't had the VALUES...

I have a kinda similar problem

I'm new to SQL and I'm now working on MS SQL 2000.

I've created an SP which will in one case to an insert and in...