Viewing 4 posts - 1 through 4 (of 4 total)
I tried doing it by using variables... but i need run this query behind excel sheet using MS query...
when i run the query using integer variables, it's running fine in...
September 17, 2009 at 12:01 am
I tried doing it by using variables... but i need run this query behind excel sheet using MS query...
when i run the query using integer variables, it's running fine in...
September 16, 2009 at 11:58 pm
Error :-
Cannot perform an aggregate function on an expression containing an aggregate or a subquery
September 16, 2009 at 10:14 am
getting the error on :
sum(case when (age.days_dlq + datediff(dd,(select max(invoice_date) from AR_HEADER WHERE BUSINESS_UNIT_ID IN (SELECT BUSINESS_UNIT_ID FROM CHANNELS_LIBERTY WHERE REGION = 'EMEA')),'2009-september-25')) < 1 then age.ar else 0 end)...
September 16, 2009 at 10:10 am
Viewing 4 posts - 1 through 4 (of 4 total)