Sorry to say this, instead of helping me you guys are writing......

I am not a Database person.... Just trying to solve some problem and I hope that this forum would...

main problem is with line IDETAIL.ChargeTypeID *= CHARGE.ChargeTypeID. in query where clause.

I have to rewrite the query for SQL server 2005

when I try to run this sql in SQL server...

Jason,

I couldn't get your comment "Just make changes as appropriate to the commented section. "

It would be great If you can rewrite the whole query. I don' know the...

Thanks,

I couldn't get it, This query is not using tblChargeType table

Here are the details

[tblChargeType](

[ChargeTypeID] [tinyint] NOT NULL,

[ChargeType] [varchar](60) NULL,

[ShowInvoice] [tinyint] NULL,

[ShowPO] [tinyint] NULL,

[ShowService] [tinyint] NULL,

[ShowRevenue] [tinyint] NULL,

[CompanyID] [int] NOT NULL CONSTRAINT [DF_tblChargeType_CompanyID] DEFAULT (1),

[StatusID] [tinyint] NOT NULL CONSTRAINT [DF_tblChargeType_StatusID]...