May 16, 2013 at 11:27 am
select
OrderNum,
OrderLine,
OrderRelease
FileTemplateName
from OrderLines
I would like to run a xcopy statement for each record and copy the file from FileTemplateName to
c:\OrderFiles\<OrderNUm>\<OrderLine>\<OrderRelease>\<OrderNum>_<OrderLine>_<OrderRelease>_FileTemplateName
May 16, 2013 at 1:13 pm
skb 44459 (5/16/2013)
selectOrderNum,
OrderLine,
OrderRelease
FileTemplateName
from OrderLines
I would like to run a xcopy statement for each record and copy the file from FileTemplateName to
c:\OrderFiles\<OrderNUm>\<OrderLine>\<OrderRelease>\<OrderNum>_<OrderLine>_<OrderRelease>_FileTemplateName
I am guessing that what you have is just the file name stored in the database and you want to make a physical copy of the existing file in the new location? Are these files in the directory on the sql server or another server? If they are on the same server I would think you could do this with CLR fairly easily. If they are on another server this could get pretty tricky.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 16, 2013 at 1:16 pm
I am guessing that what you have is just the file name stored in the database and you want to make a physical copy of the existing file in the new location?
Yes
Are these files in the directory on the sql server or another server?
Other File server
May 16, 2013 at 1:20 pm
skb 44459 (5/16/2013)
I am guessing that what you have is just the file name stored in the database and you want to make a physical copy of the existing file in the new location?Yes
Are these files in the directory on the sql server or another server?
Other File server
OK so is this a one time thing or do you need to do this repeatedly?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 16, 2013 at 1:22 pm
Its going to be ondemand . I am going to create a stored procedure for it and the select statement will have a where clause (Parameters).
May 16, 2013 at 1:25 pm
skb 44459 (5/16/2013)
Its going to be ondemand . I am going to create a stored procedure for it and the select statement will have a where clause (Parameters).
Can you post ddl and a few rows of sample data?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply