Hi Matak,
Could you please let me know the purpose of DATEADD(mi, (N-1)*15 as i am getting below error in your script.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'n'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'n'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'N'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'N'.
Thanks
Abhas.