title: Data conversion from Varchar to Date SQL server
body: <p>I have a <code>SourceTable</code> which contains two columns <code>First_Sale_Date</code> and <code>Last_Sale_Date</code> and both are of data type <code>varchar(10)</code>. The <code>First_Sale_Date</code> column contains date(mm/dd/yyyy format) and the <code>Last_Sale_Date</code> contain nothing. </p>
  
  <p>I need to load <code>SourceTable</code> data to Table 2 with same column(columns <code>First_Sale_Date</code> and <code>Last_Sale_Date</code>) but in <code>Table2</code> both columns are of <code>date</code> data type. the problem is when i load the data to <code>Table2</code> from <code>SourceTable</code>, the first column is loaded as converted date format but in the second column values shown as <code>NULL</code> . I want the <code>Table2</code> to be empty if there are no records in <code>SourceTable</code></p>
  
  <p>Please help me to fix this issue. Thank you for your time and help</p>