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 derfloh 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. stapleman527

    Reading through cursors for multiple blocks of data

    Just wanted to give an update of what I found to work just in case anyone else stumbled upon this and wanted to use it. I started with what markros originally suggested and added to the order by statement and joined subsequent blocks. In the order by statement I concatenated all the fields I...
  2. stapleman527

    Reading through cursors for multiple blocks of data

    You are correct markros, the data should be selected chronologically. I will work on joining the different data sets and see what I come up with and post it back. Thanks for all of your help.
  3. stapleman527

    Reading through cursors for multiple blocks of data

    This is very helpful. Just one more question. This seems to work for one block of data, but how would I do it to get the data from the other blocks? Lets say for example that I get the name information from row 1 in a set, but I need to get the address info from the 3rd row. I see how I can get...
  4. stapleman527

    Reading through cursors for multiple blocks of data

    I am not exactly sure what this is doing...in the over clause the case is when First_Name is NULL what does the 99 and 1 do for you? I ran it and I am getting data on most of them, but I want to be clear on how it works since I will have to be doing it with other blocks of data.
  5. stapleman527

    Reading through cursors for multiple blocks of data

    No, once we find a record that has some of the information in the block we will take whatever that row has and not supplement it with any other data.
  6. stapleman527

    Reading through cursors for multiple blocks of data

    I have a project I am working on where I have a table full of client data that some clients have multiple records in, updates and such. I need to filter the data down to one record per client. The way I need to do this is to take each group of records for a client and order them by their...
  7. stapleman527

    SQL Select most recent of multiple groups

    Thanks. Both solutions work great. I like the simplicity of the code from RiverGuy, which was also very similar to the first few examples on that blog, but it is possible to have accounts where there are multiple rows for with the same date, it doesn't really matter which one of these I pick but...
  8. stapleman527

    SQL Select most recent of multiple groups

    I am working on a data migration project in which I have account data that I am massaging into a new format. I am also filtering out data that is not needed in the new system. For each account I can have 1 to n records that represent updates to the account and I want to create a query that will...

Part and Inventory Search

Back
Top