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.