Hi Michael

thanks for looking at query.. yes you are right the other post is also mine but client changed the requirement. now they want to see if it is null...

Hi Johan

I need to compare the hr from in_datetime  and date_hr whatever the hr for in_Datetime that id should show the hr from #t table.

hope that will make sense

regards

hi Steve

could you please share you fnTally function

regards

Hi

Thanks for your reply.

Does that mean that I need to run below grant execute SP SQL Script for each SP for user?

GRANT create procedure ON DATABASE::[db name] TO [user_name]

GRANT execute...