Thanks for the reply

Question

You cannot vote on your own post

0

if there 3 records in bill_detail table like this

INSERT INTO DETAIL

([objid], [x_billable_to], [x_bill_quantity], [x_billable_yn], [x_bill_rate],[COST_TYPE])

VALUES

(1, 'Customer', 3, 1, 20,'Parking'),

(2, 'Customer',...

CREATE TABLE BILL_DETAIL

([objid] int,[x_billable_to] varchar(19), [x_bill_quantity] int,

[x_billable_yn] int, [x_bill_rate] int, [COST_TYPE] varchar(19) )

;

INSERT INTO BILL_DETAIL

([objid], [x_billable_to], [x_bill_quantity], [x_billable_yn], [x_bill_rate],[COST_TYPE])

VALUES

(1, 'Customer', 3, 1, 20,'Parking'),

(2,...

Open the link http://sqlfiddle.com/#!3/c9ec9f/4 and update the query and click on the Runsql and it will give the data if the query executes without error

use this link http://sqlfiddle.com/#!3/c9ec9f/4

Table defination fields and some sample data is created in the above link for running the above query.

Please test it and send me the converted query...