User Profile

Collapse

Profile Sidebar

Collapse
avi25b
avi25b
Last Activity: Feb 12 '08, 10:18 AM
Joined: Feb 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • avi25b
    replied to sql command error
    in SQL Server
    How Run Above Querry In Sql Server 2000

    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
    ...
    See more | Go to post
    Last edited by avi25b; Feb 12 '08, 06:53 AM. Reason: NOT CORRECT QUERRY

      Leave a comment:

    • avi25b
      started a topic sql command error
      in SQL Server

      sql command error

      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...
      See more | Go to post
      No activity results to display
      Show More
      Working...