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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dbasch

  1. dbasch

    Convert from flat file to relational and back to flat...I think...

    Thanks PruSQLer. I found a similar solution here: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid543871_tax285649,00.html However, I have about a hundred different colors and am using Interbase/Firebird which does not have CASE or COALESCE. It appears I will...
  2. dbasch

    Convert from flat file to relational and back to flat...I think...

    Hello all, I have a flat file such as: Model Color A1 Black A1 White A1 Blue B2 White B2 Black B2 Yellow I need the data in a different horizontal flat file structure for usage with OSCommerce: Model Color1 Color2 Color3 A1 Black White...
  3. dbasch

    DISTINCT predicate and multiple fields

    If you want a display that looks like company recordCreator ---------------------- Microsoft ! swampBoogie, dbasch Microhard ! aleb, bleb I want a display that looks like: company recordCreator ---------------------- Microsoft ! swampBoogie Microhard ! dbasch Microflag ! powlin That is not...
  4. dbasch

    DISTINCT predicate and multiple fields

    > Which value from the recordCreator column should be chosen? All of them. Or, all that are distinct. I think you are thinking of a subquery. DISTINCT is a SELECT predicate and I am not using it in a subquery. I have tried to use subqueries to solve my issue but with no luck. I can only use...
  5. dbasch

    DISTINCT predicate and multiple fields

    Hello, I am trying to do a query such as: SELECT DISTINCT [Qualified Leads].[Company], [Qualified Leads].[Record Creator] FROM [Qualified Leads]; This returns all of the records that have fields taht are a combination of unique values. However, what I really need is just the company field to...
See more

Part and Inventory Search

Back
Top