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. alicorn2

    Comparing two rows from a table, reporting differences

    Thanks, George! I do need a variable, since I need to send it off on its merry way in the world (i.e. to email) afterwards, but I didn't think of building it all in one big select/case statement. Thank you! :)
  2. alicorn2

    I should have said...

    My ex-boyfriend had debt collectors who called our number, and when he moved out (and I kept the same phone number) I occasionally got calls for him. I basically said "he doesn't live here anymore, but I know he works, or used to work anyway, XYZ company. Here's their phone number, perhaps...
  3. alicorn2

    Splitting Strings from Event Log

    Have a look at http://forge.mysql.com/snippets/view.php?id=4 -- it's for mysql but you could probably use the same logic to make code that works for you.
  4. alicorn2

    Comparing two rows from a table, reporting differences

    Here's the actual code, if it helps... This has been changed to run interactively in Query Analyzer, rather than running as a stored procedure and sending email at the end, rather than a select *... but you should get the idea! declare @newPID int, @oldPID int , @Val varchar(30), @oVal...
  5. alicorn2

    Comparing two rows from a table, reporting differences

    No thoughts? Is the way I'm doing it the best/only way?
  6. alicorn2

    sql server client

    Query Analyzer, perhaps? If so, get your SQL Server install disks, act like you're trying to install server, and at some point in the installation it will say "oh hey, you can't install server on a workstation! do you want to install the client tools only?" and then say yes. :)
  7. alicorn2

    Set a field to be unique

    If the entries are already null, then they're not unique. You can create the index with NO CHECK (remove the checkmark from "Check existing data on creation") which means "from this point on, make sure it's unique" but it's probably better if you fill in the data first. You should also...
  8. alicorn2

    problem w/ GROUP BY

    I haven't tested this but could you change CASE WHEN COUNT(P.State) > 1 THEN 'Various' END to something like: CASE WHEN MIN(P.State) <> MAX(P.State) THEN 'Various' ELSE MIN(P.State) END
  9. alicorn2

    Comparing two rows from a table, reporting differences

    I have a table called Position that has a structure similar to the following: PositionID - unique key PersonnelID - foreign key Company Start Date End Date Address1 City etc etc etc When a new row is inserted, I want to compare it to the previous row for the same personnel ID, and then send an...
  10. alicorn2

    compare two tables

    If this is something you have to do frequently, you might want to investigate Red Gate's SQL bundle. They have various compare tools, one of which compares the data in two SQL databases. I don't know if that would help you with this particular problem, since your files are MDB and CSV, but...

Part and Inventory Search

Back
Top