Truncating a table with a condition

[purush]

Hi,

I need to truncate a table based on a conditon.........For a column 'Input' There will be two values A and B. I need to truncate only for the value A.

Previously when there was no condition I used to use Stored Procedrue to truncate the entire table.........Now can I use SP with a condition to truncate the table.......

Please suggest me an

Thanks in Advance.......
Purush

[nick.bond]

what database are you using?

you can't truncate with a condition, that would be performing a delete.

If you partition your table by the column in question you could drop the partition which will probably be quicker that a delete if you have a huge table.

[chulett]

Can you approach this as a series of discrete steps? Evaluate your condition, possibly truncate, etc - all controlled in a Sequence job by triggers?

[ray.wurlod]

Is the question IF condition THEN truncate ELSE don't or is the question truncate only certain rows?