If i understand you well...
If you would like to add holidays for each companies, you don't need cursor. All what you need is to use simple
INSERT INTO
with
SELECT
statement.
INSERT INTO Holidays (CompanyID, SomeField, OtherField, AnotherField, OneMoreField, SomeID1, SomeID2)
SELECT CompanyID, 'Day Description' AS SomeField, '' AS OtherField, datename(dw,(Convert(datetime, '01 January 2015', 103))) AS AnotherField,
Year(Convert(datetime, '01 January 2015', 103)) AS OneMoreField, 0 AS SomeID1, 1 AS SomeID2
FROM Companies
For further information, see here:
INSERT (T-SQL)[
^]
INSERT Examples (T-SQL)[
^]