Using SQL to generate tinyget script

Started of with running tinyget each time:

select  'tinyget -srv:"dev.24.com" -uri:"/cdn/Files/cms/img/' + 

cast(RepositoryItemId as varchar(50)) + 

'/?w=800&h=600&id=' + cast(RepositoryId as varchar(50))  +'"'

from repositoryitem

 

Then created a script file with sql, and executed tinyget once using the script file

:

select  '-uri:/cdn/Files/cms/img/' + 

cast(RepositoryItemId as varchar(50)) + 

'/?w=800&h=600&id=' + 

cast(RepositoryId as varchar(50))  

from repositoryitem

Command used to execute this script file:

c:\>tinyget –srv:webserver –script:scriptfilename.txt –l 10 –x:2

That runs it 10 times over 2 threads using the output of the sql statement saved to a text file