Dear nitinpatel31,

problem solved.

Thanks.

Regards

Praveen

Thanks for reply.

Plz tell me how to give sysadmin server role to your sql server login and login.

Regards

Praveen

Hi,

when You store query in the variable single quote(') is used for

string terminater. Thatswhy, value of @intMonth variable is not concatenate into query. You can use query with following...