Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. yunvme

    Conditional Sum within a Group

    Thanks LB..it worked like a charm :-)
  2. yunvme

    Conditional Sum within a Group

    I have a crystal report that is linked to a stored procedure. in the crystal report i have the groups set to customer, date and rank. in the stored procedure i have created a rank where a customer exists more then once on the same day. what i need to do is create a sub total for the customer...
  3. yunvme

    Row Number to find Previous

    I have a database that stores customer information. what i need to do is show the customers previous rate. this is easy for customers that have a previous rate (by using row_number and selecting row_number 2)but not all customers have a previous rate so i need to select their current rate. here...
  4. yunvme

    IsNull and a Date Parameter

    LB...If you haven't been told today....YOU ROCK! ;-) it worked like a charm! thanks again!
  5. yunvme

    IsNull and a Date Parameter

    Hi, I have two tables (table A and table B). table A contains cusotmer information and table B contains customer activity information for the past 5 years. I have joined the two tables using left join as {tablea.customer_id}={tableb.customer_id} in both tables. what i'm trying to see if there...

Part and Inventory Search

Back
Top