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 bkrike 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. partridge80

    Groupby problem

    Consider the following: Shop Product code Price 1 001 200 1 002 300 1 003 400 2 008 370 2 011...
  2. partridge80

    How do I join tables across servers?

    Can anyone give me an overview of this please?
  3. partridge80

    Selecting the latest months data from a file

    I have a file that contains a number of lines for each month. New data gets added to it each month. The month is in the format YYYYMM and I wish to create a smaller table that only contains the latest month's infomation. I hoped it was as easy as Select name, address from clientinfo...
  4. partridge80

    Pivot chart formatting

    I have just produced a pivot chart in excel but I wanted the series in a different order and so I right clicked on the series and selected format data series and changed the series order by moving up and down. The problem is that when I then make selections on the pivot chart, the formatting...
  5. partridge80

    Using variables in the same view that there were declared in

    Forgive me as I am very new to SQL. I've been finding that if you introduce a new variable in a view it seems you cannot use it in that particular view. Is this the case or am I missing something?
  6. partridge80

    Case Statement Problem

    In the following problem the variables 'BoxtypeA - H are varchars. A '1' can appear in any of them. bx1 - 8 are the corresponding money fields of BoxtypeA - H. I want Box1 to be the sum of bx's where there is a '1' in the corresponding Boxtype A- H. So what is wrong with this? (From a very...

Part and Inventory Search

Back
Top