immaduddinahmed (8/16/2013)
...actulay this work is above my level thats why i am getting complexity 🙂
You're doing just fine - you've learned a huge amount in the time you've been posting on ssc.
Try this in your output list:
CASE WHEN al.CheckTime IS NULL THEN 'A' ELSE 'P' END
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden