I also have a column called customerid in "PaymentsSchedule" table whose value is 3, which I forgot to mention earlier.

I have a table called "PaymentDetail" as below:

IDPaymentIDSequenceOrderIDPaymentAmount

151390313999991123450.00

----------------------------------------------------------------------------------------------------------------------

Also I have...

Thanks a lot!

Thank You!

Below is my entire query. Please look at the code which starts as

SELECT ISNULL(x.CTTitle,x.CTTitle1) As TheTitle

....

...

...

I am getting the syntax error as Incorrect syntax near the keyword 'SELECT'.

Please...

Here is my query:

SELECTDISTINCT

CASE

WHEN DonorCompanyID -1 THEN d.OrderID + d.DonorCompanyID

ELSE d.ID

END REFERENCE,

CASE

WHEN DonorCompanyID -1 THEN d.OrderID

ELSE d.ID

END REFERENCE1,

o.OriginalOrderID,

d.Trandate,

d.donorcompanyId,

c.Name AS CName,

c.LCDistrictName,

od.ShipToID,

od.shiptoname,

CASE...

I am sorry I did not mention that I am using SQL Server 2000

Thank You so much!!!!! I just checked your reply, I will try this solution

not sure how to do that but I will try.

Can you please provide me the code if possible .

Thank You!

Thanks a lot!

I mean "with" clause with a common_table_expression in SQL Server 2000.

e.g. can I write as follows:

with x (startdate, enddate)

as

(

select ............

)