Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
UPDATE dbo.ConsultantPayWhenPaidReport SET ciConsultantReceipts = ISNULL(tcdConsultantReceipts,0) ,ciConsultantReceivableBalance = ISNULL(tcdConsultantReceivableBalance,0) ,prjConsultantWriteoff = ISNULL(ConsultantWriteoff,0) ,rReceiptDate = ISNULL(rDate,NULL) ,TotalPaidByClient =ISNULL(CASE WHEN rDate IS NOT NULL THEN viInvoiceAmount END,0) FROM dbo.ConsultantPayWhenPaidReport LEFT JOIN ( SELECT dbo.AxTransaction.tClientInvoice, dbo.AxReceipt.rDate, SUM(CASE WHEN rType = 0 AND gldType IN (8, 13) THEN - gldAmount END) AS tcdConsultantReceipts, SUM(dbo.AxGLDetail.gldAmount) AS tcdConsultantReceivableBalance, - SUM(CASE WHEN rType = 2 THEN gldAmount END) AS ConsultantWriteoff FROM dbo.AxTransaction LEFT OUTER JOIN dbo.AxGLDetail ON dbo.AxGLDetail.gldTransaction = dbo.AxTransaction.tKey LEFT OUTER JOIN dbo.AxReceipt ON dbo.AxGLDetail.gldReceipt = dbo.AxReceipt.rKey WHERE (dbo.AxTransaction.tActivityType = 3) AND (dbo.AxGLDetail.gldControlAccountType = 2) GROUP BY dbo.AxTransaction.tClientInvoice, dbo.AxReceipt.rDate )SUB ON SUB.tClientInvoice = ciKey
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|In SQL 2000 combine mulitple rows into a single row seperated by a semi colon||10||40|
|UPDATE JOIN multiple tables||5||21|
|Trouble installing msi file with msiexe.exe||2||18|
|T-SQL: Need Group By to use "fuzzy logic"??||3||21|