perry.59

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

RE: how to select several columns with one being distinct

caffeinated - Monday, May 22, 2017 5:59 PM
Perhaps this?
USE [test]
go
select
    ComponentId,
    partRefId = MIN(partRefId),
    Name,
    DocumentId,
    SheetRef = MIN(SheetRef),
    LocationId,
    Effectivity,
    EffectivityId,
    DesignatorPrefix,
    Designator,
    DesignatorSuffix
FROM PartRef pr
JOIN PartDef pd
ON...

May 23, 2017 at 9:19 am

#1943822
RE: how to select several columns with one being distinct

May 22, 2017 at 2:08 pm

#1943651
RE: how to select several columns with one being distinct

sorry for breaking this up, this website is choking.
So here is a small script that does not quite get me where I want to go..

USE...

May 22, 2017 at 2:07 pm

#1943650
RE: how to select several columns with one being distinct

Ok, here's some code. This just creates two tables, a relation and adds some data

USE [test]
GO
/****** Object: Table PartRef] Script Date: 5/17/2017 11:01:50 AM...

May 22, 2017 at 1:56 pm

#1943648

Viewing 4 posts - 1 through 4 (of 4 total)