Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:28 PM
Points: 786, Visits: 691
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, www.sommarskog.se
Post #1475748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse