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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.