Parameterized Expression: child

Showing posts with label child. Show all posts

Monday, March 26, 2012

Parent? Child? Distant Relative? Casual Aquaintance?

Hi all, I have a question that relates to a relationship in my stock performance database. It is a conceptual one, but is the only aspect of my database design that I am "losing sleep over" *LOL* (as if that could happen with me... ;) )

Anyway, Here are my tables/Keys, as setup

1) CurrentList - Primary Key is PortfolioID, StockID, BuyDate, Selldate.
- essentially, this table defines stock portfolios. A PortfolioID has one-to-many StockIDs (stocks in the portfolio), and each PortfolioID/StockID pair can further be grouped by BuyDate and Selldate (because a single stock may come in and out of a single portfolio over time).

2) StockProperty - Primary Key is StockID, CreateDate. This table is built on a daily basis from rows in the Currentlist. It represents the affected stocks currently in ANY portfolio. For example, the IBM stock may exist in more than one PORTFOLIO (PortfolioID) but there will still only be ONE row for IBM on a particular date (CreateDate) in the StockProperty table (since the stock is the same stock, regardless of how many portfolios it is in).

I am trying to figure out which is the parent table, and which the child...or if there IS an "enforceable" relationship at all!?!? None of the non-key data is the same in either table, so the only columns with a relationship is StockID, and StockProperty.Createdate - which must be between CurrentList.BuyDate and CurrentList.SellDate.

I guess that's my quandry (or one of myriad quandries in my life ;) ) - I can't really think of how to enforce (via foreign keys, etc) the relationship in the date range...AND...how to explain the relationship between the two tables (I lean toward CurrentList being Parent to StockProperty, but can't come to grips with what the probably obvious "standard" relationship description would be.

Any (preintable) thoughts?
Thanks!This is known as a many-to-many relationship, and is pretty common. An intermediary table (CurrentList, in your case) contains the primary keys of two unrelated parent tables (PortfolioID and StockID). In your example, your current list will have additonal composite key fields (BuyDate and SellDate) that describe a historical record of the many-to-many relationship.

That said, I suspect that you are going to run into more problems with your design. This is a very complicated business process to model, and you will likely run into many more many-to-many relationships and even more obscure structures before your get something robust and workable. I strongly recommend that you scale back the scope of your project if possible, and then add features as you verify your design through use.|||Okee-dokee, thanks for burning a few brain cells on this...

It's actually working in production, and as you probably guessed, this is just about 1/5th of the project's database, and the overall production database is working with no apparent design issues so far. I THINK I'm ok in that respect. As with all things, time and unforseen keystroke sequences will tell.

There are really only TWO tables involved at this part of the design though...the CurrentList and the StockProperty tables. A Currentlist row, however, can only be associated with ONE stockproperty row (in my example above, if the same stock is in the same currentlist multiple times, the BuyDate and SellDate in the CurrentList row will be different, resulting in a new and separate CurrentList row). (or were you saying that I SHOULD have the intermediary table?) Conversely, a StockProperty row can be associated with one-to-many CurrentList rows.

Anyway, I know it works, I'm just trying to step back and look at this segment of the design and try to figure out if it's designed the way it SHOULD be. Any time I see something like this that gives me trouble mapping out relationships onto paper - just is a design "uh-oh" red flag to me. (hey, Daddy, what's "paper"?)

I'm thinking that it really would be enough at one level to add a foreign key on StockID using CurrentList as the child, and StockProperty as the parent. That seems too simple though, and disregards the stockproperty.date to currentlist.daterange relationship.

Hmmm...I appreciate any insight anyone can provide...but no big rush or urgency. It's more to me like a "OK, it's out there, NOW what could I have done differently?" thing. Yeah, I know...NOT how to develop ideally, but The Machine coerced me...and now I just wanna make SURE, in retrospect, that my kid won't see this someday and think "Good God, Dad...WTF were you THINKING?" (she does that enough NOW ;) ).

parent/child text File Import

I have a file with a parent child records in the same file.

My game plan is to get it into a table recognize the parents and put them in the parent table and recognize the children and put them in the children table.

The problem I am having is the flat file import chokes on it because the column withs are different from line to line (parent / child).

Any thoughts or suggestions would be apprecaited.

Mardo

You'll need to import the data into the pipeline as a single wide column and then parse out the required values using a combination of the condistional split component and derived column component.

-Jamie

parent/child table error in sqlxml

When I try to select with sqlxml I recevie the following error related to one
relationship that has a composite key (all none composite key relationships
work).
Schema: the parent/child table of the relationship on
'ProductMetricsBreakDown' does not match.
The xsd is included that is causing the error is included
It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
error.
Any help would be greatly appreciated.
<?xml version="1.0" encoding="utf-8"?>
<xs:schema elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="AnnualBusinessModel" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Branch"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_FormUI"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="LinksToOtherDocuments" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="NotesAndConditions" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerAssessment" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerCompetency" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerIndustryVertical" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSalesVertical" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSpecialization" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="RevenueBreakdown" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Contact"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
child-key="AccountID" />
<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />


</xs:appinfo>
</xs:annotation>
<xs:element name="MicrosoftPartnerProfile"
sql:relation="MicrosoftPartnerProfile">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
<xs:element name="CertificationTierLevelID"
sql:field="CertificationTierLevelID" sql:datatype="varchar" />
<xs:element name="CompanyName" sql:field="CompanyName"
sql:datatype="varchar" />
<xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
sql:datatype="varchar" />
<xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
sql:datatype="int" />
<xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
<xs:element name="District" sql:field="District" sql:datatype="varchar" />
<xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
<xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
sql:datatype="int" />
<xs:element name="NumberOfSalesProfessionals"
sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfEmployeesPerUPP"
sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionals"
sql:field="NumberOfTechProfessionals" sql:datatype="int" />
<xs:element name="OrgHQLocationIndicator"
sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
<xs:element name="NumberOfSalesProfessionalsPerUPP"
sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="GlobalPartner" sql:field="GlobalPartner"
sql:datatype="varchar" />
<xs:element name="ActiveFlag" sql:field="ActiveFlag"
sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionalsPerUPP"
sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
sql:datatype="int" />
<xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_1000_14999_Percent"
sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
<xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
sql:datatype="decimal" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="AddressLine2" sql:field="AddressLine2"
sql:datatype="varchar" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="StateProvinceId" sql:field="StateProvinceId"
sql:datatype="varchar" />
<xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
<xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
<xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
<xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
sql:datatype="datetime" />
<xs:element name="ManagedBy" sql:field="ManagedBy"
sql:datatype="varchar" />
<xs:element name="ParentAccountID" sql:field="ParentAccountID"
sql:datatype="int" />
<xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
<xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
sql:datatype="varchar" />
<xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
sql:datatype="datetime" />
<xs:element name="ParentUPPId" sql:field="ParentUPPId"
sql:datatype="int" />
<xs:element name="CustomCampaign" sql:field="CustomCampaign"
sql:datatype="varchar" />
<xs:element name="PartnerSalesVertical"
sql:relation="PartnerSalesVertical"
sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerIndustryVertical"
sql:relation="PartnerIndustryVertical"
sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerGTM" sql:relation="PartnerGTM"
sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="GTMFocusID" sql:field="GTMFocusID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyID" sql:field="CompetencyID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FormUI" sql:relation="FormUI"
sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyCheckMode"
sql:field="CompetencyCheckMode" sql:datatype="varchar" />
<xs:element name="SpecializationCheckModel"
sql:field="SpecializationCheckModel" sql:datatype="varchar" />
<xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
sql:datatype="varchar" />
<xs:element name="IndustryVerticalsCheckMode"
sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="MBSVerticalsCheckMode"
sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
sql:datatype="varchar" />
<xs:element name="AssessmentsCheckMode"
sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
<xs:element name="AnnualBusinessCurrentMode"
sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
<xs:element name="BusinessPlanCurrentMode"
sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
<xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
sql:datatype="varchar" />
<xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
sql:datatype="varchar" />
<xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
sql:datatype="varchar" />
<xs:element name="NavContact" sql:field="NavContact"
sql:datatype="varchar" />
<xs:element name="NavBranch" sql:field="NavBranch"
sql:datatype="varchar" />
<xs:element name="NavCompetency" sql:field="NavCompetency"
sql:datatype="varchar" />
<xs:element name="NavSpecialization" sql:field="NavSpecialization"
sql:datatype="varchar" />
<xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
sql:datatype="varchar" />
<xs:element name="NavMBSVert" sql:field="NavMBSVert"
sql:datatype="varchar" />
<xs:element name="NavRevSummary" sql:field="NavRevSummary"
sql:datatype="varchar" />
<xs:element name="NavConditions" sql:field="NavConditions"
sql:datatype="varchar" />
<xs:element name="NavRhythm" sql:field="NavRhythm"
sql:datatype="varchar" />
<xs:element name="NavCampaigns" sql:field="NavCampaigns"
sql:datatype="varchar" />
<xs:element name="NavAssessments" sql:field="NavAssessments"
sql:datatype="varchar" />
<xs:element name="NavLinks" sql:field="NavLinks"
sql:datatype="varchar" />
<xs:element name="NavProducts" sql:field="NavProducts"
sql:datatype="varchar" />
<xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
sql:datatype="varchar" />
<xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
sql:datatype="varchar" />
<xs:element name="NavInvestments" sql:field="NavInvestments"
sql:datatype="varchar" />
<xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LinksToOtherDocuments"
sql:relation="LinksToOtherDocuments"
sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="DocumentUrl" sql:field="DocumentUrl"
sql:datatype="varchar" />
<xs:element name="DocumentTitle" sql:field="DocumentTitle"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
sql:datatype="int" />
<xs:element name="ConditionsOfSatisfaction"
sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
<xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
sql:relationship="MicrosoftPartnerProfile_PartnerA ssessment">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnnualBusinessModel"
sql:relation="AnnualBusinessModel"
sql:relationship="MicrosoftPartnerProfile_AnnualBu sinessModel">
<xs:complexType>
<xs:sequence>
<xs:element name="PartnerFiscalYearEndDate"
sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="AnnualRevenueInMillions"
sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
<xs:element name="RevenueGrowthPercentYOY"
sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="AnnualRevenuePerUPP"
sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="AnnualMSRevenueInMillions"
sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
<xs:element name="AnnualSoftMSRevenuePerUPP"
sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="MSRevenueGrowthPercentYOY"
sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="PercentCRM" sql:field="PercentCRM"
sql:datatype="decimal" />
<xs:element name="PercentERP" sql:field="PercentERP"
sql:datatype="decimal" />
<xs:element name="HighlightedProductSubcategoryID"
sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BusinessFocus" sql:relation="BusinessFocus"
sql:relationship="MicrosoftPartnerProfile_Business Focus">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BluePrintQuadrantID"
sql:field="BluePrintQuadrantID" sql:datatype="int" />
<xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
sql:datatype="varchar" />
<xs:element name="DistrictPref1" sql:field="DistrictPref1"
sql:datatype="int" />
<xs:element name="DistrictPref2" sql:field="DistrictPref2"
sql:datatype="int" />
<xs:element name="DistrictPref3" sql:field="DistrictPref3"
sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerSpecialization"
sql:relation="PartnerSpecialization"
sql:relationship="MicrosoftPartnerProfile_PartnerS pecialization">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SpecializationID" sql:field="SpecializationID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ProductMetricsBreakDown"
sql:relation="ProductMetricsBreakDown"
sql:relationship="AnnualBusinessModel_ProductMetri csBreakDown" >
<xs:complexType>
<xs:sequence>
<xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="ProductSubCategoryID"
sql:field="ProductSubCategoryID" sql:datatype="int" />
<xs:element name="MetricName" sql:field="MetricName"
sql:datatype="varchar" />
<xs:element name="ProductSubcategoryName"
sql:field="ProductSubcategoryName" sql:datatype="varchar" />
<xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
sql:datatype="decimal" />
<xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half1MSActual" sql:field="Half1MSActual"
sql:datatype="decimal" />
<xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
sql:datatype="decimal" />
<xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
sql:datatype="decimal" />
<xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half2MSActual" sql:field="Half2MSActual"
sql:datatype="decimal" />
<xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
sql:datatype="decimal" />
<xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
<xs:element name="TotalPercentage" sql:field="TotalPercentage"
sql:datatype="decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Branch" sql:relation="Branch"
sql:relationship="MicrosoftPartnerProfile_Branch">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BranchAccountID" sql:field="BranchAccountID"
sql:datatype="nvarchar" />
<xs:element name="ExecuteOnLocalMarketingCampaigns"
sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
sql:datatype="int" />
<xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
sql:datatype="int" />
<xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
sql:datatype="int" />
<xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
sql:datatype="int" />
<xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
sql:datatype="int" />
<xs:element name="ExecuteOnMSOpportunityForecasting"
sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="SubDistrictID" sql:field="SubDistrictID"
sql:datatype="int" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="StateProvinceID" sql:field="StateProvinceID"
sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="NumberOfLocalSalesProfessionals"
sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfLocalTechProfessionals"
sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
<xs:element name="BranchName" sql:field="BranchName"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>

</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
I resolved the problem. Since this productmetrics table was a child of the
annualbusinessmodel table, it had to be nested in the schema.
:>
"jb" wrote:

> When I try to select with sqlxml I recevie the following error related to one
> relationship that has a composite key (all none composite key relationships
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> 
> 
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
> sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
|||
> When I try to select with sqlxml I recevie the following error related to one
> relationship that has a composite key (all none composite key relationships
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> 
> 
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
> sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
> sql:datatype="int" />
> <xs:element name="ConditionsOfSatisfaction"
> sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
> <xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
> sql:relationship="MicrosoftPartnerProfile_PartnerA ssessment">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="AnnualBusinessModel"
> sql:relation="AnnualBusinessModel"
> sql:relationship="MicrosoftPartnerProfile_AnnualBu sinessModel">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="PartnerFiscalYearEndDate"
> sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="AnnualRevenueInMillions"
> sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
> <xs:element name="RevenueGrowthPercentYOY"
> sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
> <xs:element name="AnnualRevenuePerUPP"
> sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
> <xs:element name="AnnualMSRevenueInMillions"
> sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
> <xs:element name="AnnualSoftMSRevenuePerUPP"
> sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
> <xs:element name="MSRevenueGrowthPercentYOY"
> sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
> <xs:element name="PercentCRM" sql:field="PercentCRM"
> sql:datatype="decimal" />
> <xs:element name="PercentERP" sql:field="PercentERP"
> sql:datatype="decimal" />
> <xs:element name="HighlightedProductSubcategoryID"
> sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="BusinessFocus" sql:relation="BusinessFocus"
> sql:relationship="MicrosoftPartnerProfile_Business Focus">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="BluePrintQuadrantID"
> sql:field="BluePrintQuadrantID" sql:datatype="int" />
> <xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
> sql:datatype="varchar" />
> <xs:element name="DistrictPref1" sql:field="DistrictPref1"
> sql:datatype="int" />
> <xs:element name="DistrictPref2" sql:field="DistrictPref2"
> sql:datatype="int" />
> <xs:element name="DistrictPref3" sql:field="DistrictPref3"
> sql:datatype="int" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerSpecialization"
> sql:relation="PartnerSpecialization"
> sql:relationship="MicrosoftPartnerProfile_PartnerS pecialization">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SpecializationID" sql:field="SpecializationID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="ProductMetricsBreakDown"
> sql:relation="ProductMetricsBreakDown"
> sql:relationship="AnnualBusinessModel_ProductMetri csBreakDown" >
> <xs:complexType>
> <xs:sequence>
> <xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="ProductSubCategoryID"
> sql:field="ProductSubCategoryID" sql:datatype="int" />
> <xs:element name="MetricName" sql:field="MetricName"
> sql:datatype="varchar" />
> <xs:element name="ProductSubcategoryName"
> sql:field="ProductSubcategoryName" sql:datatype="varchar" />
> <xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half1MSActual" sql:field="Half1MSActual"
> sql:datatype="decimal" />
> <xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
> sql:datatype="decimal" />
> <xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half2MSActual" sql:field="Half2MSActual"
> sql:datatype="decimal" />
> <xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
> sql:datatype="decimal" />
> <xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
> <xs:element name="TotalPercentage" sql:field="TotalPercentage"
> sql:datatype="decimal" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="Branch" sql:relation="Branch"
> sql:relationship="MicrosoftPartnerProfile_Branch">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="BranchAccountID" sql:field="BranchAccountID"
> sql:datatype="nvarchar" />
> <xs:element name="ExecuteOnLocalMarketingCampaigns"
> sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
> <xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
> sql:datatype="int" />
> <xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
> sql:datatype="int" />
> <xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
> sql:datatype="int" />
> <xs:element name="ExecuteOnMSOpportunityForecasting"
> sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="SubDistrictID" sql:field="SubDistrictID"
> sql:datatype="int" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="StateProvinceID" sql:field="StateProvinceID"
> sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="NumberOfLocalSalesProfessionals"
> sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfLocalTechProfessionals"
> sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
> <xs:element name="BranchName" sql:field="BranchName"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> 
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
>
What do you mean, you had to nest it? Where? Under what node?
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities

Monday, March 26, 2012

Parent? Child? Distant Relative? Casual Aquaintance?

parent/child text File Import

parent/child table error in sqlxml

parent/child table error in sqlxml

Parameterized Expression

Blog Archive

About Me