hai,
i want a delete query for deleting the multiple tables data on daily basis..i.e,the data will be delete every 24 hrs...
these are my sp's
delete from Appointment Where UserId='5effd331-3fa4-4ef4-a358-40babc2890c8'
delete from Campaign where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'
delete from Contact where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'
delete from CompanyProduct where ProviderId='5effd331-3fa4-4ef4-a358-40babc2890c8'
delete from CompanyProvider where CreatedUserId='5effd331-3fa4-4ef4-a358-40babc2890c8'
please help me....
thanks and regards,
your's rk