SQL question

Discussion in 'ASP .Net' started by =?Utf-8?B?TWlrZQ==?=, Dec 2, 2004.

  1. I have 2 columns that i need to subtract together then display that result in
    my datagrid, how can i do this in my SQL statement?

    ex:
    I need:

    Begining_Cars - Sold_Cars = Remaining_Cars

    and display Remaining_Cars in my grid
    =?Utf-8?B?TWlrZQ==?=, Dec 2, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?TWlrZQ==?=

    Ben Lucas Guest

    select Beginning_Cars - Sold_Cars as Remaining_Cars
    from TableName

    --
    Ben Lucas
    Lead Developer
    Solien Technology, Inc.
    www.solien.com

    "Mike" <> wrote in message
    news:...
    >I have 2 columns that i need to subtract together then display that result
    >in
    > my datagrid, how can i do this in my SQL statement?
    >
    > ex:
    > I need:
    >
    > Begining_Cars - Sold_Cars = Remaining_Cars
    >
    > and display Remaining_Cars in my grid
    Ben Lucas, Dec 2, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dna
    Replies:
    1
    Views:
    1,272
  2. William \(Bill\) Vaughn
    Replies:
    0
    Views:
    442
    William \(Bill\) Vaughn
    Aug 21, 2003
  3. David Browne
    Replies:
    0
    Views:
    456
    David Browne
    Aug 21, 2003
  4. ecoolone
    Replies:
    0
    Views:
    754
    ecoolone
    Jan 3, 2008
  5. Jules
    Replies:
    6
    Views:
    150
    Jules
    Jul 15, 2003
Loading...

Share This Page