Home Forums SQL Server 2017 SQL Server 2017 - Administration 0x004700DD24EBF06E46E0A707561C0BE83EC0 is changing to Binary on import RE: 0x004700DD24EBF06E46E0A707561C0BE83EC0 is changing to Binary on import

  • July 12, 2018 at 11:06 am

    #1997359

    justin.lamantia - Thursday, July 12, 2018 10:53 AM

    Here is the View Query...

    SELECT TOP (100) PERCENT dbo.CLEAR.ID, dbo.CLEAR.DESCRP, dbo.CLEAR_AUX.OWNER, dbo.CLEAR_AUX.EMAIL
    FROM  dbo.CLEAR INNER JOIN
         dbo.CLEAR_AUX ON dbo.CLEAR.ID = dbo.CLEAR_AUX.ID
    WHERE (NOT (dbo.CLEAR.DESCRP LIKE N'%----%'))
    ORDER BY dbo.CLEAR.DESCRP

    How do i convert the ID

    Roughly, something like this
    😎

    SELECT
      CONVERT(VARCHAR(36),CL.CLEAR.ID,0) AS ID
     ,CL.CLEAR.DESCRP
     ,CLA.OWNER
     ,CLA.EMAIL
    FROM dbo.CLEAR CL
    INNER JOIN dbo.CLEAR_AUX CLA
    ON dbo.CLEAR.ID = dbo.CLEAR_AUX.ID
    WHERE (NOT (dbo.CLEAR.DESCRP LIKE N'%----%'))
    ORDER BY dbo.CLEAR.DESCRP;