Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
(select [listing_id] as 'Listing_ID', [property_type_id] as 'Property_Type_ID', [newspaper_id] as 'Newspaper_ID', null as 'House_Number', [House_Street] as 'House_Street', [Display_Address] as 'Display_Address', [ZIP] as 'ZIP', [rental_or_sale] as 'rental_or_Sale', [price] as 'Price', [Bedrooms_ID] as 'Bedrooms_ID', [Agent_ID], [Agent_Contact_1], [Agent_Phone_1], [Agent_Email_1], [Agent_Picture_1], [Comments] as 'description/CDATA', [Full_baths], [Acres], [Listing_Photo_1] as 'adImages/imges1', [Listing_Photo_2] as 'adImages/imges2', [Listing_Photo_3] as 'adImages/imges3', [Listing_Photo_4] as 'adImages/imges4', [Listing_Photo_5] as 'adImages/imges5', [Listing_Photo_6] as 'adImages/imges6', [Listing_Photo_7] as 'adImages/imges7' from dbo.vView1 for xml path('ad'), type, elements ) FOR XML path('export') END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.