Hi Khalid,SBO has a Stored Procedure called SBO_SP_TransactionNotification. This will fire each time a transaction is affected in SBO. You can use this to "trigger" your own SP.Thank you,Aziz
Hi Mohamad,Check this query if it helps, sure it will need some modification:SELECT P."Code", P."CName",
[1] as 'Jan',
[2] as 'Feb',
[3] as 'Mar',
[4] as 'Apr',
[5] as 'May',
[6] as 'Jun',
[7] as 'Jul',
[8] as 'Aug',
[9] as 'Sep',
[10] as 'Oct',
[11]...