Ok here is what I would like to do:
run a query or view that gets a datatable (in t-sql) not c#
Then run through each record in the datatable that I have, and assign values to insert or update statements at my liesure.
That is what I would like it to do. Should be easy right?
And I don't want to have to use cursors to do it.
Can this be done?
I don't think it can, or haven't seen it in practice. Mostly I have to write code in c# to get sql to jump through the hoops I need it to with datatable or sets.
This is why T-Sql sucks. This is why I rant.
Unless I am wrong, then I would be pleasantly pleased, but I don't think I am wrong.