User Profile

Collapse

Profile Sidebar

Collapse
Doudy2013
Doudy2013
Last Activity: Apr 22 '13, 09:50 PM
Joined: Feb 27 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Doudy2013
    started a topic How to get all order ID which are not paid in SQL Server 2008?
    in SQL Server

    How to get all order ID which are not paid in SQL Server 2008?

    Hi , I want to get all order id numbers for selected customer which not payed till now, my data show as following:



    What I want is Write a SELECT statement that answers this question:

    Code:
    select orderID from order where customer id = @custID and Total cashmovementValue for current order id is less than total (sold quantity * salePrice ) for current order id.
    How to do it?

    Thanks....
    See more | Go to post
    Last edited by Rabbit; Mar 18 '13, 05:05 PM. Reason: Please use code tags when posting code.
    • Doudy2013
      started a topic How to calculate totals of wpf datagrid column with dataset which is created by addin
      in C Sharp

      How to calculate totals of wpf datagrid column with dataset which is created by addin

      I am trying to figure out what is the best way to calculate a total value of DataGrid column in wpf, I´m using dataset to display data from SQL server in my Resources(DataT emplate) & bind it to datagrid like below:

      DataTemplate:
      Code:
      <ResourceDictionary xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
                    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...