The continuity is very slightly more clear in the novels. Episode 0 is the movie that the SOS Brigade films to show at the school festival during "Live Alive". In the novels, the BriagadeBrigade makes the movie during The Sigh of Haruhi Suzumiya, the second novel in the series, which is adapted to anime in the last four episodes of Series 2.
The novels The Melancholy of Haruhi Suzumiya and The Boredom of Haruhi Suzumiya both take place before The Sigh, so the episodes based on those novels--"The Melancholy of Haruhi Suzumiya" parts 1-6, "The Boredom of Haruhi Suzumiya", "Mysterique Sign", and "Remote Island Syndrome", all take place before Episode 0. As senshin mentions, "Live Alive", "Day of Sagittarius", and "Someday in the Rain" take place after Episode 0. "The Day of Sagittarius" was in the fifth novel, The Rampage of Haruhi Suzumiya, and "Live Alive" and "The Adventures of Mikuru Asahina Episode 00" (our Episode 0) were in the sixth novel, The Wavering of Haruhi Suzumiya. Both of these novels are random collections of shorts that cover different time periods.