SQL to fetch xml...how to ?? RRS feed

  • Question

  • Hi all,


    Could anybody help me on converting this sql query to xml query by attributes:


    SELECT   FilteredAccount.accountid, FilteredAccount.name

    FROM     FilteredAccount INNER JOIN

               FilteredContact ON FilteredContact.parentcustomerid = FilteredAccount.accountid

    WHERE   (FilteredContact.intercom_support_managerid = '{F31D9D73-EA8C-DF11-9F21-00215A1F6AE3}')


    please note that i have failed to do it with fetch xml builder


    any help will be appreciated,


    thanks in advance :)

    Monday, October 4, 2010 6:46 PM


All replies