Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Create table from select distinct. Expand / Collapse
Posted Friday, July 19, 2013 8:02 PM


Group: General Forum Members
Last Login: Wednesday, September 18, 2013 9:09 PM
Points: 16, Visits: 28
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.
Post #1475723
Posted Saturday, July 20, 2013 6:00 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, September 15, 2016 9:40 AM
Points: 886, Visits: 857
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.

Erland Sommarskog, SQL Server MVP,
Post #1475748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse