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

    case help

    I'm not sure I understand your question correctly, but why don't you just add to your WHERE clause: AND f.matteridstring NOT IN (SELECT DISTINCT matteridstring FROM ripedata)
  2. PerBylund

    Multiple Datatypes and PIVO

    I'm working on a database that must be extremely flexible as to the "width" of the table Person. Thus, I have put static fields in the Person table and have another table, PersonStat (statistics), for "the rest" of the fields (which might change upon every import of data). Then I make a view...
  3. PerBylund

    Dynamic Fieldnames for View or Table

    Thanks, I'm using SQL Server 2005 so I'll try to use the PIVOT command. Just have to understand how to use it.
  4. PerBylund

    DB design suggestions needed

    I guess I need to clarify the solution a bit. What I'm suggesting is a table without explicit relations with other tables, but with implicit relations based on keywords (in the example the keywords are "service", "warranty" etc). The combination of keyword and the ID from the specific table...
  5. PerBylund

    DB design suggestions needed

    It seems to me you should keep the solution open for more objects and any combinations and thus explicit relations might be quite annoying when developing the system. I would make a "centralized" connections table for all other tables, e.g. - Service Table - Agreement Table - Contract Table -...
  6. PerBylund

    INSERT INTO without specifiying columns

    You don't have to specify fieldnames, at least not according to SQL Server Books Online. Try this syntax: INSERT INTO MySalesReason SELECT SalesReasonID, Name, ModifiedDate FROM AdventureWorks.Sales.SalesReason WHERE ReasonType = N'Marketing';
  7. PerBylund

    Dynamic Fieldnames for View or Table

    I'm working on creating a view (or table if a view isn't possible) based partly on the structured content of a table and partly on the dynamic structure in records in another table. The tables look like this: Table A: ID, Name, Address, City, State, ZipCode Table B: ID, Name, Value Table A...
  8. PerBylund

    Color Customization

    Hi all, I am supposed to change the colors in Microsoft Dynamics CRM 3.0 so that they reflect a certain "style." In this case the background colors on all pages in the web client should be in different kinds of orange instead of blue. I've browsed the SDK as well as the Microsoft CRM web site...

Part and Inventory Search

Back
Top