Can someone show me a sample SQL server script that I can look at that uses the "With Clause"?

I am trying to use this clause to iterate through 200 databases that contain the same table that I am trying to run a query on. I am trying to avoid using a cursor because the query time takes too long as well as using a while a loop.

Can someone advise me as to what I can do.

Thank you.

sql-server-2008 sql-server-2008-r2
Edit
Report