Viewing 15 posts - 1 through 15 (of 15 total)
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...
March 12, 2007 at 4:13 am
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....
February 5, 2007 at 2:12 am
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,
...
November 20, 2006 at 8:51 am
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...
October 19, 2006 at 4:47 am
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))...
September 19, 2006 at 5:46 am
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...
September 19, 2006 at 2:38 am
Here is the modified Query
select
StaffDetails.[Employee],
ISNULL(SUM(InvoiceTotals.[Total Net]),...
September 15, 2006 at 10:06 am
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...
September 15, 2006 at 9:41 am
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....
June 20, 2006 at 5:57 am
I am failing to understand how would uninstalling and reinstalling SS2005 will solve the problem?
Mits
June 19, 2006 at 2:42 am
Thank you for responding very quickly.
I will get you the exact error message tommorrow. I am at home now.
Mits
November 2, 2005 at 1:30 pm
thanks guys for all your suggestion. I will try them out and see how it goes.
Mits
September 17, 2005 at 6:18 am
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
September 16, 2005 at 7:30 am
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
May 6, 2005 at 2:57 am
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
May 5, 2005 at 6:35 am
Viewing 15 posts - 1 through 15 (of 15 total)