Thanks Grasshopper for quick reply.

you can not use cAST(rg.ReferredDecimalPoints) to add decimal point to numeric data type.you can not use variable inside numeric bracket.you have to pass static value.

you can...

Can you able to say what is type of FormattedValue column.

FormattedValue column strict to type so you can not assign other type except type of FormattedValue column.

Thanks,

Nishant

ID:nishantcomp2512

create a blank schedule job.

after creating job you can add schedule to it using stored procedure sp_add_jobschedule and stored procedure update schedule using sp_update_jobschedule.

http://msdn.microsoft.com/en-us/library/ms178560.aspx

http://msdn.microsoft.com/en-us/library/ms178560.aspx

Thanks,

Nishant

ID:nishantcomp2512