I have a windows form that is connected to a SQL 2014 dataset. I just recently upsized the form from a local access table to a SQL server table. OH BOY!
A left over issue that I'm having is that I have a PK set on field called 'Record_ID' that is seeded from the server. The update command is throwing an error that the value is null. (that's my problem I think) The identical code worked fine for Access by SQL is wielding amighty fist I think (which is why I did it)
I'm using this code.
I'm left wondering if I can insert new and call an update to force the field to update and assign a value? The continue to add any information and update again?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …