 <p>Convert your month and year columns to strings concatenated with '-'s and add '-01' to the end. Then convert to a date.</p> <pre><code>UPDATE t SET t.[Date] = convert(date, convert(varchar(4), t.[Year]) + '-' + convert(varchar(2), t.[Month]) + '-01') FROM Table t </code></pre> <p>This will create a date for all records in your table.</p>