Is Insert Values Faster than Insert Select?
I have a Procedure that inserts the same values 3 times into tables.
Should I use Insert Select 3 times or select the values into local variables then use insert values 3 times?
Which would be Faster?
Also if the Insert Select has one or more inner joins does that have a further negative impact on the speed?
(I'm using SQL 2014)