Database

Declare @Usr varchar(50),
    @SQL as varchar(5000)

Declare csrPV Cursor Fast_Forward For
    Select name
    From sysusers
    Where issqluser = 1
        and hasdbaccess = 1
        AND name NOT IN ('dbo','IBMSQLDBA')

OPEN csrPV 

FETCH NEXT FROM csrPV INTO @Usr

WHILE @@FETCH_STATUS = 0
BEGIN

    Set @SQL = 'DROP USER [' + @Usr + ']'
    Print @SQL
    exec (@SQL)

    Set @SQL = 'CREATE USER [' + @Usr + '] FOR LOGIN [' + @Usr + '] WITH DEFAULT_SCHEMA=[dbo]'
    print @SQL
    exec (@SQL)

    Set @sql = 'ALTER LOGIN [' + @Usr + '] ENABLE'
    exec (@SQL)

    EXEC sp_addrolemember N'db_owner', @Usr

    FETCH NEXT FROM csrPV INTO @Usr
END
CLOSE csrPV
DEALLOCATE csrPV

SELECT
    S.shipId,
    S.number,
    S.reference,
    S.[weight],
    SA.addressLine As Source,
    DA.addressLine As Destination
FROM
    Shipments As S
    
    -- Source address:
    INNER JOIN ShipmentAddresses As SSA
    ON SSA.shipmentId = S.shipId And SSA.typeOfAddress = 0
    INNER JOIN Addresses As SA
    ON SA.addressId = SSA.addressId
    
    -- Destination address
    INNER JOIN ShipmentAddresses As DSA
    ON DSA.shipmentId = S.shipId And DSA.typeOfAddress = 1
    INNER JOIN Addresses As DA
    ON DA.addressId = DSA.addressId
;