Search results for query: *

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)

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

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

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

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

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';

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

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