Jump to content

jleachomg

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jleachomg

  • Rank
    Newbie
  1. Ok- thanks for the new way of looking at it.
  2. I have a nifty query that pulls data by orders.orderid > '85000' (and I update that number every week based on orders.) But I want it to automatically pull the most recent 3,000 orders instead of changing that number all the time, so I was hoping to set a variable which is Max(order.orderid)-3000, thus pulling the last 3000 order records. Here is my static select: SELECT Orders.OrderID, Orders.OrderStatus, Orders.CustomerID, Orders.ShippingMethodID, Orders.BillingFirstName, Orders.BillingLastName, Orders.BillingAddress1, Orders.BillingAddress2, Orders.BillingCity, Orders.BillingState,
×
×
  • Create New...