Abu Dina (2/6/2013)
I seem to have many IF statmements to check for columns before I build my dynamic insert statement.Any ideas?
'If' is a conditional statement ;so, when you need it , you use it ..
If that fieldMapping table has to be searched for creating dynamic sql then you can go on with it ;
another way could be , since you are not executing the sql's , and I suppose using the same variable elsewhere and deciding which to execute , you can put the conditions on executing the dynamic sql rather than setting the value to variables.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: