Welcome to the Ranch, Ashwani! I've moved your question to a better suited forum, the Ranch Office forum is just for discussions about this site.
Saif Asif wrote:I think you have an error in your SQL. shouldnt it be something like this...
No, that was not the problem. The COLUMN keyword needs only be specified when adding just one column, without the brackets. When the columns are put into the brackets, the COLUMN keyword must not be specified.
The problem is that column names cannot be parametrized. You need to specify the column names right in the text of the statement, no question marks there. Only literals (text, date or numeric) can be parametrized. That should fix it.
Putting in that "this is urgent" doesn't really help around here. First, it isn't our problem. Next, a lot of folks will say "hmmm...this was posted a while ago and it's urgent, so i'm probably too late. I'll go help someone else".