Vertigo44 (6/25/2013)
Can someone show me how to select all patients that hasve seen more than one provider over the past month please? Would this be a cte?
You're not new here, so you should know that we require more from you than a plain English description of what you want which assumes that we magically understand your database's DDL.
Please read the link in my signature - it describes how to post questions of this nature to get the best responses.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.