You don't need to have a commented url string in a proc to do this - just press CTRL-ALT-R on any query pane from anywhere, and woolaa, instant browser.

good problem, but I think a better question might have been, what values are contained in the tmp table:

1,a,b

1,c,b

empty or no rows

error encountered

Forgive me, as I am just a grasshopper! (how rude)

anyway, I too was getting:

Incorrect syntax near 'SETS'.

but I am running SQL Server 2008 Management Studio.

Figured out that the Compatibility level...

I'm confused, if DateTime is only precise to 3.33 ms, why then is the answer just 1 ms off? Why not 3 ms?

I think these are more of what you are after;

Dundus

Nevron