Well there are some odd SQL tricks I have used one or two times,  you can run a single SQL select with a dynamic text/string and a TSQL function....  if you for example have a table of ID,Name to put into a dropdown you can make SQL build the complete HTML for the dropdown.... I'd have to dig out the code.... but it's kinda sweet how it works.