Here is my Query :
--select item_number from item where item_number like '%Test%'
For each item_number i would like to copy a .bmp file from the server and copy to my local drive.
-- copy \\server1\Images\<Item_number>.bmp c:\temp
Is it possible to run the above command in select statement somehow ?