Using inline insert query. Not a stored procedure

Quick question, can you give us some more information, i.e. what determines the order of the rows, where is the data coming from and what are you trying to insert...

My query in the dataset works fine. not sure why i am getting this error message

Hi All,

Thanks for your help.

All your solutions worked!

Regards,

Mani

Hi,

I agree with your point. But if i have more columns you mean to say i need seperate seperate tables?

Can you please mention the subtable columns which can be sperated...