Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT 'http://foosite.com/' + RTRIM(li.imageStore)
- + '/ImageStore.dll?id=' + RTRIM(li.imageID)
- + '&raw=1&rev=' + RTRIM(li.imageVersion) AS imageUrl
- FROM ListingImages li
- FOR XML PATH ('image'), ROOT ('images'), TYPE
- <images>
- <image>
- <imageUrl>http://foosite.com/pics4/ImageStore.dll?id=7E92BA08829F6847&raw=1&rev=0</imageUrl>
- </image>
- </images>
- <images>
- <image>
- <imageUrl>http://foosite.com/pics4/ImageStore.dll?id=7E92BA08829F6847&raw=1&rev=0</imageUrl>
- </image>
- </images>
Add Comment
Please, Sign In to add comment