> What is the best way to do this?
Best in what way? Technically you can execute multiple
statements against ms sql within a single cfquery. Though some
people prefer to encapsulate multiple statements in stored
procedures, rather than using cfquery.
That said, there are a few issues to be aware of when using
cfquery + INSERT under CF8.