Thanks Jame for your response,

I managed to get the query working slightly in different way but still using left joins.

Here is my soloution.

select

id.[Invoice No]

id.[Customer Id]

,coalesce(ip.[Amount Paid], 0.0)

from

InvoiceData...

I have checked the logs and i am not getting any errors but the data access has gone very slow.

I will look at DBCC UPDATEUSAGE in BOL for more information....

Guys found the solution to my problem...but with someones help.

Removed - (select * from customer) --

and Added INVDATE.[LASTORDERDATE] in Group by

SELECT MAX([DATE NOTE ADDED]) AS LASTDATE,

...

Very good contained article - very much appreciated.

I have asked questions in forums and i have to admit that i have never been disappointed by SSC community.

The point I would...

You are right John i had that problem but case statement will handle that.

case ISNULL(SUM(InvoiceTotals.[Total Net]), 0)

when 0 then 0.0

else ((ISNULL(SUM(InvoiceTotals.[Total Net]), 0) -

ISNULL(SUM(InvoiceTotals.[Total CostBC]), 0)) /

ISNULL(SUM(InvoiceTotals.[Total Net]), 0))...

Firstly, thank you very much guys for all your help and secondly my apologies for not getting back very promptly.

Here is the query that worked for. I really appreciate the...

Here is the modified Query

select

StaffDetails.[Employee],

ISNULL(SUM(InvoiceTotals.[Total Net]),...

Here is the Original Query where [Nominal Code] is Employee Id

select sum([Total Net]) as TotalNet,sum([Total CostBC]) as TotalCost,

SD.[Nominal Code],SD.[Employee]

from Invoicetotals,(select [Nominal Code],Employee

                              from staffdetails

                               where department ='Sales' and...

Good News guys got it all working.

These are the steps i did, and i dont know but it might help anyone out there.

Our Webserver is outside DMZ on our network....

I am failing to understand how would uninstalling and reinstalling SS2005 will solve the problem?

Mits

Thank you for responding very quickly.

I will get you the exact error message tommorrow. I am at home now.

Mits

thanks  guys for all your suggestion. I will try them out and see how it goes.

Mits

Hi,

What i have read so far is you can only debug stored procedure in visual studio's enterprise edition and not in any other version.

Mits

Thank you all guys for your response. This is the first time i have asked anything in this forums and i will definitely come back.

Mits

Hi Guys n gals

I have found the solution to my above problem

follow this link http://www.sqlteam.com/item.asp?ItemID=11499

Mits