Purge data dynamically

I want to delete data from all the tables dynamically. I have a table that
consists of
columns:

RecID, -- Identity(1,1)
Table_Name,
Column_Name, -- Date column to use for purging in that table
NumberOfDays, -- Number of days to keep the data and delete before this day.

How can I write a dynamic SQL to include in a procedure? Thanks for your
response.

Never mind. I got it. If anyone needs the script, I can post.

"David" wrote:

> I want to delete data from all the tables dynamically. I have a table that
> consists of
> columns:
>
> RecID, -- Identity(1,1)
> Table_Name,
> Column_Name, -- Date column to use for purging in that table
> NumberOfDays, -- Number of days to keep the data and delete before this da
y.
>
> How can I write a dynamic SQL to include in a procedure? Thanks for your
> response.
>
>