Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us what you are actually trying to do.
(http://www.sqlservercentral.com/Forums/Topic383628-131-1.aspx)
The code posted there only saves a copy of a pdf, you sound like you want to create your own pdfs using data found in your database? If you can provide the details of what you want to accomplish we can help you figure out a good way to it. Using t-sql with sp_OACreate to generate a pdf is not the best way.
_______________________________________________________________
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/