Create table from select distinct.

• mikej 14403

  Old Hand

  Points: 366

  More actions

  July 19, 2013 at 8:02 pm

  #296648

  I've tried a tested select distinct.

  I'm imputing the results from this query from one column into a table that I created that has two columns; a Pk column and the field to populate from the select distinct query.

  The error message points to and int value, which only the Pk column has.

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  July 20, 2013 at 6:00 am

  #1634249

  It is certainly a lot easier to help you if you post the actual SQL statement you use as well as the exact error message.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]