sql command error

[avi25b]

Respected Sir,

I run once sql querry in sql 2000 but show error. pls give me soluction now.

SELECT a.BILL_DATE,
COUNT (DISTINCT a.bill_number + ' ' + a.bill_date + ' ' + a.till_number) nob,
SUM (a.net_amt) bill_value
FROM bill_detail b, bill_header a
WHERE b.bill_date='10-feb-08'
AND a.bill_date = b.bill_date
AND a.bill_number = b.bill_number
AND a.till_number = b.till_number
AND a.bill_status = 'B'
--AND b.net_amt > 199
GROUP BY a.bill_date

show error--------------------

Server: Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.

[debasisdas]

The error message is self explanatory.

[avi25b]

SELECT TO_CHAR (&start_date, 'DD MON')
|| ' TO '
|| TO_CHAR (&end_date, 'DD MON YY') AS BILL_DATE,
COUNT (DISTINCT a.bill_number || a.bill_date || a.till_number) nob,
SUM (a.net_amt) bill_value
FROM bill_detail a, bill_header b
WHERE b.bill_date BETWEEN &START_DATE AND &END_DATE
AND a.bill_date = b.bill_date
AND a.bill_number = b.bill_number
AND a.till_number = b.till_number
AND b.bill_status = 'B'
--AND b.net_amt > 199
GROUP BY b.bill_date

HOW RUN ABOVE QUERRY IN SQL SERVER 2000

[deepuv04]

SELECT TO_CHAR (&start_date, 'DD MON')
|| ' TO '
|| TO_CHAR (&end_date, 'DD MON YY') AS BILL_DATE,
COUNT (DISTINCT a.bill_number || a.bill_date || a.till_number) nob,
SUM (a.net_amt) bill_value
FROM bill_detail a, bill_header b
WHERE b.bill_date BETWEEN &START_DATE AND &END_DATE
AND a.bill_date = b.bill_date
AND a.bill_number = b.bill_number
AND a.till_number = b.till_number
AND b.bill_status = 'B'
--AND b.net_amt > 199
GROUP BY b.bill_date

HOW RUN ABOVE QUERRY IN SQL SERVER 2000

try the following query

SELECT convert(varchar(15),@start_date, 106)
+ ' TO '
+ convert(varchar(15),@end_date, 106) AS BILL_DATE,
COUNT (DISTINCT a.bill_number || a.bill_date || a.till_number) nob,
SUM (a.net_amt) bill_value
FROM bill_detail a, bill_header b
WHERE b.bill_date BETWEEN @start_date AND @end_date
AND a.bill_date = b.bill_date
AND a.bill_number = b.bill_number
AND a.till_number = b.till_number
AND b.bill_status = 'B'
--AND b.net_amt > 199
GROUP BY b.bill_date

thnks