Hi,
You can try doing something like the following.
I have used a fictitious table variable, because the structure and data from your table weren't included in the information....

Hi Sam,
The select statement which you are inserting with is implicitly converting the blank values to integers.

If you run the select below the insert on its own,...