xp_write_file strange behavior export blob fails on call works on select

[Former Member]

Can someone point out the error or my ways. I'm using xp_write_file to export BLOBs to TIFF images. When i run the Select query it works great, only does the first 110 rows, and will create more images if i page down...not to desirable for 170,000 images. So, I try to substitute CALL for SELECT and i get a syntax error near line 1 ',' Here is my select statement, why won't call work?

SELECT xp_write_file('c:inetpubwwwrootimagesimagesc02' || ImageID || '' || ImageDetailID || '.tiff', Image), CAST(ImageID AS VARCHAR) || '' || CAST(ImageDetailID AS VARCHAR) || '.tiff' FROM c04.imagedetail

[Former Member]

Take out the extra fields referenced in your select, and limit it to JUST the xp_write_file procedure:

SELECT 
    xp_write_file('c:\\inetpub\\wwwroot\\images\\imagesc02\\' || ImageID || ImageDetailID || '.tiff', Image) 
FROM 
    c04.imagedetail