Why are you pulling in discharge date if the parameter value is "A"?
Don't you want to pull in where the active field is equal to "A"?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events