oo Ya ,,,

when i saw your first reply, i thought you were telling me to create it into 2 SP, now i tested what you had posted and it...

Thanks CirquedeSQLeil for your reply,,

i know i could do it the way you just mentioned, the thing that i want it to be in one stored procedure.

Thanks emily,, it did work 🙂

thanks emily for the reply,,

but i wanted to know how would i write the code for the if statement itself,, i mean ,, TimeStart is a datetime field, how...