• Here is the query that I am using

    SELECT DISTINCT TOP 10

    PLastName

    ,PFirstName

    ,PBorough

    ,PState

    ,PZip5

    ,PIdentificationType

    ,PIssuedBy

    ,SCity

    ,SState

    ,InspectionDate

    ,InspectionTime

    FROM vwECB

    FOR XML RAW('MOV')

    ,ROOT('ECBXML')

    ,elements

    ,BINARY BASE64;