Thanks Prashant it works..

Thanks for remembering sorry, if it really bothers you.

Any suggestions..?

Thanks Kingston..

But when i add the year in where condition the results is not as expected.. i am searching for nothing where the year is 2010, when i add that...

Account table values

MSISDNOpt_out_dateGroup

0NULL 0

1NULL ...

i have added that now.. but i am not sure what should be given under security tab.. can you please guide me in that case?

Where i will see the server objects? in SSMS..

I am sorry i dont know either!!

Particularly what i should do with linked servers?

SELECT acc.*, t.total FROM account as acc

JOIN (SELECT tx.msisdn as msisdn, sum(tx.amount) as total FROM accrued_transaction tx WHERE tx.year = 2010 AND tx.quarter = 2 AND (tx.opted_in is null OR...

Yes it works, thanks

K thanks, but there seems to be problem, i tested this query, it never goes in to else 'Absent' part, means when there is no transaction it has to...

yeah it works adding an END statement it works..

Thanks

I need to write a stored procedure in LRB and i need to call(exec) in the LRC Stored procedure. IS that correct?

I am sorry, i have to write only procedures, i dont have any rights to change it.. 🙂

i gotta to try of the SP what u have written before as...

I am sorry, QUERY works, but i could make the same in stored procedure.

i have PROCEDURE in lrc DB, how do i call lrb DB, in lrc procedure.

Thanks in advance