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!

Search results for query: *

  • Users: dbasch
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...

Part and Inventory Search

Back
Top