kurt your going to have to provide a lot more information, i think you need to "think outside of the box" on this one.
you can create a pdf from raw text, I can post an example of that, but as soon as you want formatting/images/ anything other than raw text, you are really talking about using something (Internet explorer for html, excel,word, etc),
and then converting a saved document from that medium to a pdf. it's something i've done in .NET and other languages, but it's not a one line wonder in TSQL, AFAIK.
tell us your real requirement...is it a report from Reporting Services you want to pdf for example?
what are you trying to do specifically?
Lowell