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 Chriss Miller 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. jaofos

    Possible Query?

    johpje = genius You rock man :)
  2. jaofos

    Possible Query?

    Multiple rows, not duplicate rows. Pretty much what I'm trying to do is pull the row containing the latest PrefChangeDate for each unique OracleID.
  3. jaofos

    Possible Query?

    Tried that.. still returned more rows than I want :(
  4. jaofos

    Possible Query?

    Well, guess I need to find a new way to go about getting this data since I can only use GROUP BY for up to 10 columns :(
  5. jaofos

    Possible Query?

    Using this Query: SELECT OracleID, FirstName+" "+LastName AS Name, Max([PrefChangeDate]) AS LastPrefChange, Client, TM, Extention, HireDate, Termed, TermDate FROM AgentPrefs WHERE PrefChangeDate Is Not Null GROUP BY OracleID, FirstName, LastName, Client, TM, Extention, HireDate...
  6. jaofos

    Possible Query?

    I added that, didn't seem to make a difference :(
  7. jaofos

    Installing Windows XP and Redhat 7.2 on same machine

    I had XP and RedHat 7.2 both installed on my Laptop not too long ago. I've also fooled around with installing RedHat on my desktop machine with XP. If your going to run XP / Linux dual booting, it's probably best to use the Grub bootloader. XP doesn't like Lilo for some reason.
  8. jaofos

    Possible Query?

    There is really no one difference between the rows that would cause it to pull them. After 10 columns added to the group by, it pulls one, if I had all the columns I want to pull, it ends up pulling all rows where PrefChangeDate != Null. I'm thinking of restructuring the database to maybe make...
  9. jaofos

    Possible Query?

    Hrm, one thing I just noticed. Once I go over 10 columns pulled from the table, that query no longer works, it starts pulling extra records.. My exact SELECT statement: SELECT OracleID, FirstName+" "+LastName AS Name, Max([PrefChangeDate]) AS LastPrefChange, Client, TM, Extention...
  10. jaofos

    Possible Query?

    Nevermind, I got it. Thanks a ton! :)
  11. jaofos

    Possible Query?

    Oops, forgot to mention I don't want duplicates. I only want the first record.
  12. jaofos

    Possible Query?

    Ok, I've been trying for a couple days to get this query to work work. Here's an example of the data I'm working with: ID | FirstName | LastName | LastUpdate ---------------------------------------------------- 999 | John | Doe | <null> 9999| Jane | Doe | <null> 999 | John | Doe |...

Part and Inventory Search

Back
Top