locked
Content Query Web Part Only returns 15 WorkflowStatus Column Values. RRS feed

  • Question

  • I am using a CQWP to pull back values from approximately 50 webs under a single site collection. Each web has a list with a single item that contains site data. These items are all built off of the same content type, and have a workflow associated which identifies the state of the process that each site is in.

    I can successfully pull all the data from these items, except for the Workflow Status column. The items are all returned, but the Workflow status for all but the first 15 items is returned as 8, instead of the expected value of 15-22 (It is an 8 stage process). I have traced this back to the SPInternalRequest.CrossListQuery function, and the SQL that it generates. Specifically the tblOrds.joinOrds = 0 condition that is set in the SQL from this CrossListQuery function.

     

    My question: Is this a bug, which is incorrectly limiting my ability to pull back data from WorkflowStatus column types, or is this a part of the overall design that just doesn't make sense to me??

     

    Saturday, January 28, 2012 4:22 AM

All replies

  • Hello,

     

    Thank you for your question.

     

    We are trying to involve someone familiar with this topic to further look at this issue.

     

    This may take some time. Thanks for your patience.

     

    Thanks,


    Pengyu Zhao

    TechNet Community Support

    Wednesday, February 1, 2012 10:11 AM
  • Hi,

    I've tried to repro this but I am not able to based off of your comments.  Can you tell us how you've configured the CQWP webpart?


    Regards, Savoeurn Va Microsoft Online Community Support

    Tuesday, February 7, 2012 11:09 PM
  • Content Type: AuditInformation

    Fields:
    Title -> Text
    Organization -> Lookup
    AuditWor -> Workflow Status (Values between 15-22)
    AuditNumber -> Text

    CQWP Definition:

    <webParts>
      <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
        <metaData>
          <type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
          <importErrorMessage>Cannot import this Web Part.</importErrorMessage>
        </metaData>
        <data>
          <properties>
            <property name="FilterType3" type="string" />
            <property name="PageSize" type="int">-1</property>
            <property name="SortBy" type="string" />
            <property name="ChromeState" type="chromestate">Normal</property>
            <property name="AllowZoneChange" type="bool">True</property>
            <property name="ContentTypeBeginsWithId" type="string">0x0100F132384C21CDBA40853CA2E349C19AC6</property>
            <property name="ServerTemplate" type="string">100</property>
            <property name="Height" type="string" />
            <property name="FilterField2" type="string" />
            <property name="SystemViewFields" type="string" />
            <property name="ParameterBindings" type="string" null="true" />
            <property name="FeedTitle" type="string" />
            <property name="AllowMinimize" type="bool">True</property>
            <property name="ContentTypeName" type="string" />
            <property name="TitleUrl" type="string" />
            <property name="AllowConnect" type="bool">True</property>
            <property name="DisplayColumns" type="int">1</property>
            <property name="XslLink" type="string" null="true" />
            <property name="ExportMode" type="exportmode">All</property>
            <property name="GroupBy" type="string" />
            <property name="DataSourcesString" type="string" />
            <property name="WebUrl" type="string" />
            <property name="AllowHide" type="bool">True</property>
            <property name="AdditionalGroupAndSortFields" type="string" null="true" />
            <property name="FeedDescription" type="string" />
            <property name="WebsOverride" type="string" />
            <property name="CommonViewFields" type="string">AuditNumber;Title;Organization;AuditWor</property>
            <property name="DisplayName" type="string" />
            <property name="ChromeType" type="chrometype">TitleOnly</property>
            <property name="AdditionalFilterFields" type="string" null="true" />
            <property name="NoDefaultStyle" type="string" null="true" />
            <property name="FilterValue3" type="string" />
            <property name="BaseType" type="string" />
            <property name="FireInitialRow" type="bool">True</property>
            <property name="SortByDirection" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+SortDirection, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Desc</property>
            <property name="DataFields" type="string" />
            <property name="GroupStyle" type="string">DefaultHeader</property>
            <property name="DataColumnRenames" type="string" />
            <property name="HeaderXslLink" type="string" />
            <property name="AllowEdit" type="bool">True</property>
            <property name="MissingAssembly" type="string">Cannot import this Web Part.</property>
            <property name="HelpUrl" type="string" />
            <property name="ViewFieldsOverride" type="string" />
            <property name="FilterField1" type="string" />
            <property name="UseCache" type="bool">True</property>
            <property name="ShowUntargetedItems" type="bool">False</property>
            <property name="HelpMode" type="helpmode">Modeless</property>
            <property name="DataSourceID" type="string" />
            <property name="ListName" type="string" />
            <property name="FilterType1" type="string" />
            <property name="Default" type="string" />
            <property name="FilterType2" type="string" />
            <property name="FilterOperator1" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
            <property name="ViewFlag" type="string" />
            <property name="FilterOperator3" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
            <property name="FilterOperator2" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterFieldQueryOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Eq</property>
            <property name="GroupByFieldType" type="string" />
            <property name="UseCopyUtil" type="bool">True</property>
            <property name="Description" type="string">Use to display a dynamic view of content from your site on a web page</property>
            <property name="Filter1ChainingOperator" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterChainingOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Or</property>
            <property name="ItemLimit" type="int">100</property>
            <property name="SortByFieldType" type="string" />
            <property name="ListGuid" type="string" />
            <property name="ViewContentTypeId" type="string" />
            <property name="ItemXslLink" type="string">/Style Library/XSL Style Sheets/raw.xsl</property>
            <property name="FeedEnabled" type="bool">False</property>
            <property name="MainXslLink" type="string">/Style Library/XSL Style Sheets/raw.xsl</property>
            <property name="TitleIconImageUrl" type="string" />
            <property name="Filter2ChainingOperator" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+FilterChainingOperator, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Or</property>
            <property name="FilterValue1" type="string" />
            <property name="ListsOverride" type="string" />
            <property name="GroupByDirection" type="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart+SortDirection, Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c">Desc</property>
            <property name="Direction" type="direction">NotSet</property>
            <property name="QueryOverride" type="string" />
            <property name="UseSQLDataSourcePaging" type="bool">True</property>
            <property name="Width" type="string" />
            <property name="FilterByAudience" type="bool">False</property>
            <property name="FilterValue2" type="string" />
            <property name="SampleData" type="string">&lt;dsQueryResponse&gt;
                        &lt;Rows&gt;
                            &lt;Row Title="Item 1" LinkUrl="http://Item1" Group="Group Header" __begincolumn="True" __begingroup="True" /&gt;
                            &lt;Row Title="Item 2" LinkUrl="http://Item2" __begincolumn="False" __begingroup="False" /&gt;
                            &lt;Row Title="Item 3" LinkUrl="http://Item3" __begincolumn="False" __begingroup="False" /&gt;
                        &lt;/Rows&gt;
                        &lt;/dsQueryResponse&gt;</property>
            <property name="Xsl" type="string">&lt;xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:cmswrt="http://schemas.microsoft.com/WebPart/v3/Publishing/runtime" exclude-result-prefixes="xsl cmswrt x" &gt; &lt;xsl:import href="/Style Library/XSL Style Sheets/Header.xsl" /&gt; &lt;xsl:import href="/Style Library/XSL Style Sheets/scorecard.xsl" /&gt; &lt;xsl:import href="/Style Library/XSL Style Sheets/raw.xsl" /&gt; &lt;/xsl:stylesheet&gt;</property>
            <property name="CacheXslStorage" type="bool">True</property>
            <property name="Hidden" type="bool">False</property>
            <property name="Title" type="string">PATS Performance Dashboard</property>
            <property name="ShowWithSampleData" type="bool">False</property>
            <property name="CacheXslTimeOut" type="int">86400</property>
            <property name="ItemStyle" type="string">AuditResults</property>
            <property name="AllowClose" type="bool">True</property>
            <property name="FilterField3" type="string" />
            <property name="CatalogIconImageUrl" type="string" />
          </properties>
        </data>
      </webPart>
    </webParts>

    XSL Stylesheet:

    <xsl:stylesheet
        version="1.0"
        exclude-result-prefixes="x xsl cmswrt cbq" 
        xmlns:x="http://www.w3.org/2001/XMLSchema"
        xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
        xmlns:cmswrt="http://schemas.microsoft.com/WebPart/v3/Publishing/runtime"
        xmlns:cbq="urn:schemas-microsoft-com:ContentByQueryWebPart">
        <xsl:output method="xml" indent="yes" />
        <xsl:param name="cbq_isgrouping" />
        <xsl:param name="cbq_columnwidth" />
        <xsl:param name="Group" />
        <xsl:param name="GroupType" />
        <xsl:param name="cbq_iseditmode" />
        <xsl:param name="cbq_viewemptytext" />
        <xsl:param name="SiteId" />
        <xsl:param name="WebUrl" />
        <xsl:param name="PageId" />
        <xsl:param name="WebPartId" />
        <xsl:param name="FeedPageUrl" />
        <xsl:param name="FeedEnabled" />
        <xsl:param name="SiteUrl" />
        <xsl:param name="BlankTitle" />
        <xsl:param name="BlankGroup" />
        <xsl:param name="UseCopyUtil" />
        <xsl:param name="DataColumnTypes" />
        <xsl:param name="ClientId" />
        <xsl:template match="/">
    <xmp><xsl:copy-of select="*"/></xmp>
            <!--xsl:call-template name="OuterTemplate" /-->
        </xsl:template>
        <xsl:template name="OuterTemplate">
            <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row" />
            <xsl:variable name="RowCount" select="count($Rows)" />
            <xsl:variable name="IsEmpty" select="$RowCount = 0" />
                <table id="cbqwp" cellspacing="0" cellpadding="0" class="cbq-layout-main">
                    <tr>
                        <xsl:choose>
                            <xsl:when test="$IsEmpty">
                                 <xsl:call-template name="OuterTemplate.Empty" >
                                     <xsl:with-param name="EditMode" select="$cbq_iseditmode" />
                                 </xsl:call-template>
                            </xsl:when>
                            <xsl:otherwise>
                                 <xsl:call-template name="OuterTemplate.Body">
                                     <xsl:with-param name="Rows" select="$Rows" />
                                     <xsl:with-param name="FirstRow" select="1" />
                                     <xsl:with-param name="LastRow" select="$RowCount" />
                                </xsl:call-template>
                            </xsl:otherwise>
                        </xsl:choose>
                    </tr>
                </table>
                <xsl:if test="$FeedEnabled = 'True'">
                    <div class="cqfeed">
                        <xsl:variable name="FeedUrl1" select="concat($SiteUrl,$FeedPageUrl,'xsl=1&amp;web=',$WebUrl,'&amp;page=',$PageId,'&amp;wp=',$WebPartId)" />
                        <a href="{cmswrt:RegisterFeedUrl( $FeedUrl1, 'application/rss+xml')}"><img src="\_layouts\images\rss.gif" border="0" alt="{cmswrt:GetPublishingResource('CbqRssAlt')}"/></a>
                    </div>
                </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.Empty">
            <xsl:param name="EditMode" />
            <td>
                <xsl:if test="$EditMode = 'True'">
                    <div class="wp-content description">
                        <xsl:value-of disable-output-escaping="yes" select="$cbq_viewemptytext" />
                    </div>
                </xsl:if>
            </td>
        </xsl:template>
        <xsl:template name="OuterTemplate.Body">
            <xsl:param name="Rows" />
            <xsl:param name="FirstRow" />
            <xsl:param name="LastRow" />
            <xsl:variable name="BeginColumn1" select="string('&lt;td id=&quot;column&quot; width=&quot;')" />
            <xsl:variable name="BeginColumn2" select="string('%&quot; valign=&quot;top&quot;&gt;')" />
            <xsl:variable name="BeginColumn" select="concat($BeginColumn1, $cbq_columnwidth, $BeginColumn2)" />
            <xsl:variable name="EndColumn" select="string('&lt;/td &gt;')" />
            <xsl:for-each select="$Rows">
                <xsl:variable name="CurPosition" select="position()" />
                <xsl:if test="($CurPosition &gt;= $FirstRow and $CurPosition &lt;= $LastRow)">
                    <xsl:variable name="StartNewGroup" select="@__begingroup = 'True'" />
                    <xsl:variable name="StartNewColumn" select="@__begincolumn = 'True'" />
                    <xsl:choose>
                        <xsl:when test="$cbq_isgrouping != 'True'">
                            <xsl:if test="$CurPosition = $FirstRow">
                                <xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
                            </xsl:if>
                        </xsl:when>
                        <xsl:when test="$StartNewGroup and $StartNewColumn">
                            <xsl:choose>
                                <xsl:when test="$CurPosition = $FirstRow">
                                    <xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
                                    <xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
                                    <xsl:value-of disable-output-escaping="yes" select="concat($EndColumn, $BeginColumn)" />
                                    <xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:when>
                        <xsl:when test="$StartNewGroup">
                            <xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
                            <xsl:call-template name="OuterTemplate.CallHeaderTemplate"/>
                        </xsl:when>
                        <xsl:when test="$StartNewColumn">
                            <xsl:choose>
                                <xsl:when test="$CurPosition = $FirstRow">
                                    <xsl:value-of disable-output-escaping="yes" select="$BeginColumn" />
                                </xsl:when>
                                <xsl:otherwise>
                                    <xsl:value-of disable-output-escaping="yes" select="concat($EndColumn, $BeginColumn)" />
                                </xsl:otherwise>
                            </xsl:choose>
                        </xsl:when>
                        <xsl:otherwise>
                        </xsl:otherwise>
                    </xsl:choose>
                    <xsl:call-template name="OuterTemplate.CallItemTemplate">
                        <xsl:with-param name="CurPosition" select="$CurPosition" />
                    </xsl:call-template>
                    <xsl:if test="$CurPosition = $LastRow">
                        <xsl:call-template name="OuterTemplate.CallFooterTemplate"/>
                        <xsl:value-of disable-output-escaping="yes" select="$EndColumn" />
                    </xsl:if>
                </xsl:if>
            </xsl:for-each>
        </xsl:template>
        <xsl:template name="OuterTemplate.CallHeaderTemplate">
            <xsl:apply-templates select="." mode="header">
            </xsl:apply-templates>
        </xsl:template>
        <xsl:template name="OuterTemplate.CallItemTemplate">
        <xsl:param name="CurPosition" />
            <xsl:choose>
                <xsl:when test="@Style='NewsRollUpItem'">
                    <xsl:apply-templates select="." mode="itemstyle">
                       <xsl:with-param name="EditMode" select="$cbq_iseditmode" />
                    </xsl:apply-templates>
                </xsl:when>
                <xsl:when test="@Style='NewsBigItem'">
                    <xsl:apply-templates select="." mode="itemstyle">
                       <xsl:with-param name="CurPos" select="$CurPosition" />
                    </xsl:apply-templates>
                </xsl:when>
                <xsl:when test="@Style='NewsCategoryItem'">
                    <xsl:apply-templates select="." mode="itemstyle">
                       <xsl:with-param name="CurPos" select="$CurPosition" />
                    </xsl:apply-templates>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:apply-templates select="." mode="itemstyle">
                    </xsl:apply-templates>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:template>
        <xsl:template name="OuterTemplate.CallFooterTemplate">
            <div id="footer">
            </div>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetSafeLink">
            <xsl:param name="UrlColumnName"/>
            <xsl:if test="$UseCopyUtil = 'True'">
                <xsl:value-of select="concat('/_layouts/CopyUtil.aspx?Use=id&amp;Action=dispform&amp;ItemId=',@ID,'&amp;ListId=',@ListId,'&amp;WebId=',@WebId,'&amp;SiteId=',$SiteId)"/>
            </xsl:if>
            <xsl:if test="$UseCopyUtil != 'True'">
                <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
                    <xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
                </xsl:call-template>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetTitle">
            <xsl:param name="Title"/>
            <xsl:param name="UrlColumnName"/>
            <xsl:if test="string-length($Title) != 0">
                <xsl:value-of select="$Title"/>
            </xsl:if>
            <xsl:if test="string-length($Title) = 0">
                <xsl:if test="$UseCopyUtil = 'True'">
                    <xsl:value-of select="$BlankTitle" />
                </xsl:if>
                <xsl:if test="$UseCopyUtil != 'True'">
                    <xsl:call-template name="OuterTemplate.GetPageNameFromUrl">
                        <xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
                    </xsl:call-template>
                </xsl:if>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.FormatColumnIntoUrl">
            <xsl:param name="UrlColumnName"/>
            <xsl:variable name="Value" select="@*[name()=$UrlColumnName]"/>
            <xsl:if test="contains($DataColumnTypes,concat(';',$UrlColumnName,',URL;'))">
                <xsl:call-template name="OuterTemplate.FormatValueIntoUrl">
                    <xsl:with-param name="Value" select="$Value"/>
                </xsl:call-template>
            </xsl:if>
            <xsl:if test="not(contains($DataColumnTypes,concat(';',$UrlColumnName,',URL;')))">
                <xsl:value-of select="$Value"/>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.FormatValueIntoUrl">
            <xsl:param name="Value"/>
            <xsl:if test="not(contains($Value,', '))">
                <xsl:value-of select="$Value"/>
            </xsl:if>
            <xsl:if test="contains($Value,', ')">
                <xsl:call-template name="OuterTemplate.Replace">
                    <xsl:with-param name="Value" select="substring-before($Value,', ')"/>
                    <xsl:with-param name="Search" select="',,'"/>
                    <xsl:with-param name="Replace" select="','"/>
                </xsl:call-template>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.Replace">
            <xsl:param name="Value"/>
            <xsl:param name="Search"/>
            <xsl:param name="Replace"/>
            <xsl:if test="contains($Value,$Search)">
                <xsl:value-of select="concat(substring-before($Value,$Search),$Replace)"/>
                <xsl:call-template name="OuterTemplate.Replace">
                    <xsl:with-param name="Value" select="substring-after($Value,$Search)"/>
                    <xsl:with-param name="Search" select="$Search"/>
                    <xsl:with-param name="Replace" select="$Replace"/>
                </xsl:call-template>
            </xsl:if>
            <xsl:if test="not(contains($Value,$Search))">
                <xsl:value-of select="$Value"/>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetSafeStaticUrl">
            <xsl:param name="UrlColumnName"/>
            <xsl:variable name="Url">
                <xsl:call-template name="OuterTemplate.FormatColumnIntoUrl">
                    <xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
                </xsl:call-template>
            </xsl:variable>
            <xsl:value-of select="cmswrt:EnsureIsAllowedProtocol($Url)"/>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetColumnDataForUnescapedOutput">
            <xsl:param name="Name"/>
            <xsl:param name="MustBeOfType"/>
            <xsl:if test="contains($DataColumnTypes,concat(';',$Name,',',$MustBeOfType,';'))">
                <xsl:value-of select="@*[name()=$Name]"/>
            </xsl:if>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetPageNameFromUrl">
            <xsl:param name="UrlColumnName"/>
            <xsl:variable name="Url">
                <xsl:call-template name="OuterTemplate.FormatColumnIntoUrl">
                    <xsl:with-param name="UrlColumnName" select="$UrlColumnName"/>
                </xsl:call-template>
            </xsl:variable>
            <xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
                <xsl:with-param name="Url" select="$Url"/>
            </xsl:call-template>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetPageNameFromUrlRecursive">
            <xsl:param name="Url"/>
            <xsl:choose>
                <xsl:when test="contains($Url,'/') and substring($Url,string-length($Url)) != '/'">
                    <xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
                        <xsl:with-param name="Url" select="substring-after($Url,'/')"/>
                    </xsl:call-template>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:value-of select="$Url"/>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:template>
        <xsl:template name="OuterTemplate.GetGroupName">
            <xsl:param name="GroupName"/>
            <xsl:param name="GroupType"/>
            <xsl:choose>
                <xsl:when test="string-length(normalize-space($GroupName)) = 0">
                    <xsl:value-of select="$BlankGroup"/>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:choose>
                        <xsl:when test="$GroupType='URL'">
                            <xsl:variable name="Url">
                                <xsl:call-template name="OuterTemplate.FormatValueIntoUrl">
                                    <xsl:with-param name="Value" select="$GroupName"/>
                                </xsl:call-template>
                            </xsl:variable>
                            <xsl:call-template name="OuterTemplate.GetPageNameFromUrlRecursive">
                                <xsl:with-param name="Url" select="$Url"/>
                            </xsl:call-template>
                        </xsl:when>
                        <xsl:otherwise>
                            <xsl:value-of select="$GroupName" />
                        </xsl:otherwise>
                    </xsl:choose>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:template>
        <xsl:template name="OuterTemplate.CallPresenceStatusIconTemplate">
            <xsl:if test="string-length(@SipAddress) != 0">
              <span class="presence-status-icon"><img src="/_layouts/images/imnhdr.gif" onload="IMNRC('{@SipAddress}')" ShowOfflinePawn="1" alt="" id="{concat('MWP_pawn_',$ClientId,'_',@ID,'type=sip')}"/></span>
            </xsl:if>
        </xsl:template>
      </xsl:stylesheet>

    Wednesday, February 8, 2012 4:10 PM
  • Also. This is pulling from 50 subwebs, a single list on each called General Information where the content type in the previous post is located. There is only a single AuditInformation item in this list, this is controlled by an EventHandler attached to the General Information List.

    The workflow that sets the status (15-22) is a Visual Studio State Workflow. The states are as follows

    15 - Audit Announced
    16 - Entrance Conference
    17 - Audit Work
    18 - Exit Conference
    19 - Draft Report
    20 - Final Report
    21 - Corrective Action
    22 - Audit Closure

    I can attach the SQL query that is generated by the CrossListQuery SPInternalRequest as well if you want to see the issue specifically. 

    LMK, 

    And thanks for the help it is appreciated :)

    Wednesday, February 8, 2012 4:14 PM
  • Here is the output from the CQWP.. Note the AuditWorkflowStatus column is populated manually to show the "correct" value / status of the AuditWor field.

    <dsQueryResponse>
        <Rows>
          <Row ListId="{F3BA2883-84C9-4037-9ADB-0AEA6F79CA3F}" WebId="{0CD0B6E9-D795-40B1-9ABA-39D5BAA659F9}" ID="1" Title="" FileRef="Audit 060/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:19" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:57:33" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="16.0000000000000" AuditNumber="Audit 060 Testing" WorkingTitle="Audit 060 Testing" AuditOrganization="1;#GAO" AuditWor="16" LinkUrl="http://sharepoint/Audit 060/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:19 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="True" __begingroup="False" />
          <Row ListId="{047C823F-B3DA-4E70-99FB-0BA20DA2FF73}" WebId="{22103B05-EF3B-48CA-B0C4-89BFA57691ED}" ID="1" Title="" FileRef="Audit 034/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:01" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:38:16" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 034 Testing Purposes" WorkingTitle="Audit 034 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="21" LinkUrl="http://sharepoint/Audit 034/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:01 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{3C451B7C-F977-47F2-A875-0BA2E123CDD3}" WebId="{255D9A04-120E-40A7-92EE-D31BD2DCC68E}" ID="1" Title="" FileRef="Audit 054/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:14" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:17:43" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 054 Testing" WorkingTitle="Audit 054 Testing" AuditOrganization="1;#GAO" AuditWor="21" LinkUrl="http://sharepoint/Audit 054/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:14 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{7CBE2162-5348-4A25-A6A7-10DE92F85E59}" WebId="{9251FE05-7C0F-4B3E-97BA-31E13F23EEC5}" ID="1" Title="" FileRef="Audit 053/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:13" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:06:53" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 053 Testing" WorkingTitle="Audit 053 Testing" AuditOrganization="1;#GAO" AuditWor="19" LinkUrl="http://sharepoint/Audit 053/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:13 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{6F4EC3BE-CE75-4770-A225-1464452E5B3B}" WebId="{23BCBB7B-9157-498D-8EEF-8B9512912C21}" ID="1" Title="" FileRef="Audit 027/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:55" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:56:20" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 027 Testing Purposes" WorkingTitle="Audit 027 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="22" LinkUrl="http://sharepoint/Audit 027/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:55 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{12B52EF7-67B1-48BD-9D12-180ADE9C942C}" WebId="{B9B3A6BD-2562-4FA0-8F7A-37F905245C7C}" ID="1" Title="" FileRef="Audit 035/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:01" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:43:18" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="21.0000000000000" AuditNumber="Audit 035 Testing Purposes" WorkingTitle="Audit 035 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="21" LinkUrl="http://sharepoint/Audit 035/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:01 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{43FE0506-D134-4A9B-8BCC-1FC5A2322F88}" WebId="{D26F08E7-9B95-41A8-B2B9-217D534195D9}" ID="1" Title="" FileRef="Audit 032/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:59" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 08:26:23" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="18.0000000000000" AuditNumber="Audit 032 Testing Purposes" WorkingTitle="Audit 032 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="18" LinkUrl="http://sharepoint/Audit 032/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:59 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{B37D3302-3858-4A48-BE21-1FF819A7720F}" WebId="{092D1032-DBD7-47EE-8B3F-4AED25CBD92D}" ID="1" Title="" FileRef="Audit 044/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:07" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 10:54:13" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 044" WorkingTitle="Audit 044" AuditOrganization="1;#GAO" AuditWor="15" LinkUrl="http://sharepoint/Audit 044/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:07 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{F6B94F28-BB86-4F8B-8FC9-20AEDF82D224}" WebId="{311ECA93-05BD-4937-B096-678BFDBBD40E}" ID="1" Title="" FileRef="Audit 045/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:08" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 11:04:23" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 045" WorkingTitle="Audit 045" AuditOrganization="1;#GAO" AuditWor="15" LinkUrl="http://sharepoint/Audit 045/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:08 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{CF3BF0D8-2965-4411-ABDC-2C1907955E23}" WebId="{FA039EB7-F755-40E5-B799-6BFD77F15D86}" ID="1" Title="" FileRef="Audit 066/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:23" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 12:47:58" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 066 Testing" WorkingTitle="Audit 066 Testing" AuditOrganization="1;#GAO" AuditWor="22" LinkUrl="http://sharepoint/Audit 066/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:23 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{09C960B1-271D-43EE-830C-30D4CFC79CD8}" WebId="{3784AB03-D296-4C1B-AEF3-5E5754BDD99D}" ID="1" Title="" FileRef="Audit 019/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:50" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:30:06" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="17.0000000000000" AuditNumber="Audit 019 Testing Purposes" WorkingTitle="Audit 019 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="17" LinkUrl="http://sharepoint/Audit 019/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:50 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{D3FE6D84-8A0B-4450-8123-37767A69DADC}" WebId="{D511D7D8-19E9-4F1A-A278-31141643BBD6}" ID="1" Title="" FileRef="Audit 043/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:06" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 10:22:09" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 043 Testing" WorkingTitle="Audit 043 Testing" AuditOrganization="2;#OIG" AuditWor="15" LinkUrl="http://sharepoint/Audit 043/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:06 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{E71ED73F-2B7D-468B-AB75-37C315B94525}" WebId="{626FFF68-484A-4FFB-AF23-610414D75427}" ID="1" Title="" FileRef="Audit 014/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:46" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:08:52" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 014 Testing Purposes" WorkingTitle="Audit 014 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="15" LinkUrl="http://sharepoint/Audit 014/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:46 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{078E361B-AD08-4A67-B30B-387F4118B8E5}" WebId="{BA2F6763-8E07-4C57-9634-E3A58FE81667}" ID="1" Title="" FileRef="Audit 021/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:51" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 07:36:17" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 021 Testing Purposes" WorkingTitle="Audit 021 Testing Purposes" AuditOrganization="2;#OIG" AuditWor="19" LinkUrl="http://sharepoint/Audit 021/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:51 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{BB8A431D-9079-4BF5-9D92-394E37273B86}" WebId="{BE4554AF-0AAC-494A-B4EB-9591CA860004}" ID="1" Title="" FileRef="Audit 069/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:25" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:57:52" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 069 Testing " WorkingTitle="Audit 069 Testing " AuditOrganization="1;#GAO" AuditWor="22" LinkUrl="http://sharepoint/Audit 069/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:25 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{A0853025-40C6-4855-A655-3F8A9AE58BA8}" WebId="{A6A131B7-2F07-4CBF-8B9C-EB2F449A3538}" ID="1" Title="" FileRef="Audit 047/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:10" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 08:34:15" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 047 Testing" WorkingTitle="Audit 047 Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 047/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:10 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{C976F5D0-9992-4377-A6A9-40ED8301A909}" WebId="{0C1224DD-2129-46B5-86C0-0410BE634802}" ID="1" Title="" FileRef="Audit 009/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:13:41" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-27 06:37:59" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="16.0000000000000" AuditNumber="Audit 009 for Testing" WorkingTitle="Audit 009 for Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 009/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:13:41 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{9570B806-2B41-4F9C-954B-43A17657EE58}" WebId="{42B3E518-11D8-4C83-B42E-E7B79FC12438}" ID="1" Title="" FileRef="Audit 064/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:22" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:19:25" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="22.0000000000000" AuditNumber="Audit 064 Testing" WorkingTitle="Audit 064 Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 064/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:22 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{BBB57FB0-8A33-445C-BB44-4524B4A9E1B6}" WebId="{69DAAC47-F243-47DB-B77C-F31DD4A57430}" ID="1" Title="" FileRef="Audit 052/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:13" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:04:43" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 052 Testing" WorkingTitle="Audit 052 Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 052/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:13 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{9FD04AE7-B853-4D71-91BA-4713D51FDD90}" WebId="{3011411E-5994-4BF2-BF7D-215FC644A9E3}" ID="1" Title="" FileRef="Audit 065/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:22" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 11:25:30" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="15.0000000000000" AuditNumber="Audit 065 Training" WorkingTitle="Audit 065 Training" AuditOrganization="2;#OIG" AuditWor="8" LinkUrl="http://sharepoint/Audit 065/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:22 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
          <Row ListId="{BD6BA8A9-42E1-4B5E-A71A-48D1A25255F4}" WebId="{445F5303-90F4-4253-B307-7B6B9EEE7246}" ID="1" Title="" FileRef="Audit 056/Lists/General Information/1_.000" _x007B_1d22ea11_x002D_1e32_x002D_424e_x002D_89ab_x002D_9fedbadb6ce1_x007D_="1" Modified="2012-02-07 07:14:16" Author="DC\Administrator" Editor="DC\Administrator" Created="2012-01-30 10:43:02" PublishingRollupImage="" _Level="1" Comments="" AuditWorkflowStatus="19.0000000000000" AuditNumber="Audit 056 Testing" WorkingTitle="Audit 056 Testing" AuditOrganization="1;#GAO" AuditWor="8" LinkUrl="http://sharepoint/Audit 056/Lists/General Information/1_.000" PubDate="Tue, 07 Feb 2012 15:14:16 GMT" ImageUrl="" ImageUrlAltText="" Description="" Style="AuditResults" GroupStyle="DefaultHeader" __begincolumn="False" __begingroup="False" />
    </Rows>

    </dsQueryResponse>

    Wednesday, February 8, 2012 4:49 PM
  • Here is the SQL query generated

    exec sp_executesql N' DECLARE @tblListOrds TABLE(WebId uniqueidentifier NOT NULL,ListId uniqueidentifier NOT 
    NULL,[ListProperty.DraftVersionVisibility] nvarchar(255) NOT NULL,JoinOrd int NOT NULL,ColumnOrd1 int NOT 
    NULL,ColumnOrd2 int NOT NULL,ColumnOrd3 int NOT NULL,ColumnOrd4 int NOT NULL,ColumnOrd5 int NOT NULL,ColumnOrd6 
    int NOT NULL,ColumnOrd7 int NOT NULL,ColumnOrd8 int NOT NULL,ColumnOrd9 int NOT NULL,ColumnOrd10 int NOT 
    NULL,ColumnOrd11 int NOT NULL,ColumnOrd12 int NOT NULL,ColumnOrd13 int NOT NULL,ColumnOrd14 int NOT 
    NULL,ColumnOrd15 int NOT NULL,ColumnOrd16 int NOT NULL,ColumnOrd17 int NOT NULL,ColumnOrd18 int NOT 
    NULL,ColumnOrd19 int NOT NULL,ColumnOrd20 int NOT NULL,ColumnOrd21 int NOT NULL,ColumnOrd22 int NOT 
    NULL,ColumnOrd23 int NOT NULL,ColumnOrd24 int NOT NULL,ColumnOrd25 int NOT NULL,ColumnOrd26 int NOT 
    NULL,ColumnOrd27 int NOT NULL,ColumnOrd28 int NOT NULL,ColumnOrd29 int NOT NULL,ColumnOrd30 int NOT 
    NULL,ColumnOrd31 int NOT NULL,ColumnOrd32 int NOT NULL,ColumnOrd33 int NOT NULL,ColumnOrd34 int NOT 
    NULL,ColumnOrd35 int NOT NULL,ColumnOrd36 int NOT NULL,NvpLookupListId uniqueidentifier,JoinKeyId1 
    uniqueidentifier,JoinKeyId2 uniqueidentifier,ScopeId uniqueidentifier,PRIMARY KEY CLUSTERED(ListId)) INSERT 
    INTO @tblListOrds SELECT 
    ''0CD0B6E9-D795-40B1-9ABA-39D5BAA659F9'',''F3BA2883-84C9-4037-9ADB-0AEA6F79CA3F'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''255D9A04-120E-40A7-92EE-D31BD2DCC68E'',''3C451B7C-F977-47F2-A875-0BA2E123CDD3'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''9251FE05-7C0F-4B3E-97BA-31E13F23EEC5'',''7CBE2162-5348-4A25-A6A7-10DE92F85E59'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''23BCBB7B-9157-498D-8EEF-8B9512912C21'',''6F4EC3BE-CE75-4770-A225-1464452E5B3B'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''B9B3A6BD-2562-4FA0-8F7A-37F905245C7C'',''12B52EF7-67B1-48BD-9D12-180ADE9C942C'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''D26F08E7-9B95-41A8-B2B9-217D534195D9'',''43FE0506-D134-4A9B-8BCC-1FC5A2322F88'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''092D1032-DBD7-47EE-8B3F-4AED25CBD92D'',''B37D3302-3858-4A48-BE21-1FF819A7720F'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''311ECA93-05BD-4937-B096-678BFDBBD40E'',''F6B94F28-BB86-4F8B-8FC9-20AEDF82D224'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''FA039EB7-F755-40E5-B799-6BFD77F15D86'',''CF3BF0D8-2965-4411-ABDC-2C1907955E23'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''3784AB03-D296-4C1B-AEF3-5E5754BDD99D'',''09C960B1-271D-43EE-830C-30D4CFC79CD8'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''D511D7D8-19E9-4F1A-A278-31141643BBD6'',''D3FE6D84-8A0B-4450-8123-37767A69DADC'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''626FFF68-484A-4FFB-AF23-610414D75427'',''E71ED73F-2B7D-468B-AB75-37C315B94525'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''BA2F6763-8E07-4C57-9634-E3A58FE81667'',''078E361B-AD08-4A67-B30B-387F4118B8E5'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''BE4554AF-0AAC-494A-B4EB-9591CA860004'',''BB8A431D-9079-4BF5-9D92-394E37273B86'',0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''A6A131B7-2F07-4CBF-8B9C-EB2F449A3538'',''A0853025-40C6-4855-A655-3F8A9AE58BA8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''0C1224DD-2129-46B5-86C0-0410BE634802'',''C976F5D0-9992-4377-A6A9-40ED8301A909'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''42B3E518-11D8-4C83-B42E-E7B79FC12438'',''9570B806-2B41-4F9C-954B-43A17657EE58'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''69DAAC47-F243-47DB-B77C-F31DD4A57430'',''BBB57FB0-8A33-445C-BB44-4524B4A9E1B6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''3011411E-5994-4BF2-BF7D-215FC644A9E3'',''9FD04AE7-B853-4D71-91BA-4713D51FDD90'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''445F5303-90F4-4253-B307-7B6B9EEE7246'',''BD6BA8A9-42E1-4B5E-A71A-48D1A25255F4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''66A13004-0114-45BE-9DB1-518117D8580D'',''0D95B742-804F-4B41-9954-49C3B2341D6F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''DB25875F-D3DC-4767-815C-F1C73BD5B3CA'',''CE9BF355-D98B-4322-81DF-4BF867620286'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''F8F72549-C3C9-4A4E-95F6-43496DD21C70'',''7160B97C-E27D-4B54-BF70-5011B944345B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''2077B01F-FE84-448A-852F-4BEE6F8BC105'',''34C81D0A-FFFC-47A8-A6C5-5221DA497541'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''777F7A86-B3FF-4A0C-B7BC-7AD7746C8D9E'',''F83A72F6-ADEB-427E-A5BF-5674BCEDD020'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''6730BC94-A41A-4AAD-8167-534BF2C5AAAE'',''48B95AF6-9DB9-4644-8D79-56B8CC1EE1AA'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''A03FAE2E-BEE0-44F7-95E3-DB202237DDBD'',''1D7928FC-19A7-4B19-803C-5BBA408295EC'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''5396B777-894A-4835-811F-DD60516369DF'',''FD024F49-F47A-4C78-B6E6-60259BEB4C5E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''3C755533-44E5-4913-841D-CC05F94EE6AF'',''0C69CB41-D661-4FFE-BABF-60607222C7F2'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''4E763E24-0A33-4C8A-8BC7-D99C8D5E9DCE'',''904CD6D9-166A-4D4E-806B-60812B783171'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''5BC581B6-AA03-44E2-9D45-5F116BDDB1F8'',''AD34FFC6-0165-4BD4-9331-65FFF5A7ADB5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''14182C89-8548-4E3B-96F8-8680B681B6CC'',''9D8ED991-2386-4BCC-B10E-6D38FC45520F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''E92265BD-1ED4-4E64-ACF4-30D9321A2513'',''7098EEBC-27B1-4CA9-99D6-7161027E5DA8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''B771A5A8-B777-40FB-8D46-4501D4D6B3A5'',''D0B40F2E-82E7-446A-915F-73D49B10598B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''DA54AE93-DFA4-4625-9A97-0789012DFBA6'',''C06624D7-731B-40BF-A141-7C15C79EB951'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''0AF4F04F-9508-4170-8DAC-9929CAFCF581'',''AA89CCA6-91B3-4762-9817-84BE53EB946B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''A58500A5-93F2-449D-9ECD-4C125177CD7A'',''EE00ABF7-E6C4-4DA5-9B1E-8D948B9161E5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''BD3F9E9E-B521-41CD-B5D5-D3998BA32E20'',''4ECA8E54-6D12-4142-B0B0-9258B25C16BD'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''2913198C-0209-44C0-9B91-863693A5A4E3'',''D643FEFD-0DAC-41D1-B6C4-95C0879E610A'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''C8FBEFE3-8143-4AF3-B782-CF7F2F1196C9'',''FA637CA5-18D0-4B5E-8C69-9A5088EBE12F'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''CA19406E-1DD2-4369-A440-B9F92CBF50D5'',''E4ECC8E5-BC95-44D2-92F0-9BC5281C3C20'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''5C692D11-3705-48EB-9F85-62DAC5AF38A7'',''1352E156-A430-4F46-B7AD-9CE31B8E2343'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''18C17BC8-FC0A-49BE-8B7D-1D845F6B43D3'',''9B69781B-13E0-4D8F-B77F-9D02FA6777D7'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''5DFFB9D2-430A-4BE1-AA8D-F3D333BE7F6B'',''1DBA79E7-ED8B-46C0-93BA-9D4573C2F916'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''3CECB6D7-23C2-4054-A3B1-7D9579EC5A2F'',''4BD0D246-C17E-4470-8DF3-9E2EC177D0AF'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''C6567A4B-386D-4188-A5A5-7D05B8973EB3'',''38FC6788-B59A-4D30-88A2-9F380B20D162'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''F443B039-9D74-492A-94AB-8EAF50F55461'',''057D92ED-AAD4-4DF2-93B1-A3899A8F3A79'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''028AE423-E639-4537-8535-6261305EBEF5'',''7AAF52C4-C6CD-4F87-9037-A5539A76BFCB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''C867CBBE-3C39-4C78-9205-F41B7036D08A'',''BDF10512-D4E9-4B58-826B-A5CCFBDB92AF'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''BAE8BC0F-1A1B-4502-B093-0068474B6990'',''8AC841D0-604B-4CBE-8085-A6E5D01E519E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''A0888268-861C-4B39-8EC7-80CD82E64A4A'',''82EC51A8-0BAD-451D-B0EF-AA8F5E242B91'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''7A9F2D62-8637-4F12-AB18-7A91E86DA20A'',''F92FFA25-C4F9-4059-9C88-B0455E35C70B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''3DC60C5C-E493-4FA1-A1F1-211F85FF73F4'',''40894565-2129-428C-B3BB-B199631C302A'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''E37FB398-265D-4ED5-AE8B-453F7BFB0D15'',''BD0D6A70-C957-4E3F-AA96-B1A379CA0CB1'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''C29E3983-1294-45C9-B397-95623735EC23'',''2E7C94C1-5161-4FDE-9330-B999DD8DA7FE'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''2E9854EC-668F-4367-A461-28AEEB25E644'',''9BEDA60D-DD3E-4ACD-8CE1-BF1317B4D813'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''DF94F663-27E8-4AD5-A3E1-F953FB9B70B7'',''5E2FB189-9846-428E-B7CE-C3B589AB2F69'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''536A0085-C946-4A0A-B121-1B5AF6D4B583'',''D91D6FFA-5AE4-46C2-81B2-C79D7D7F440E'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''F836CF08-C04B-4075-9A2A-20BE58A8DF1D'',''C097490A-CFBB-4FCB-9758-C84EC4461F5B'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''9D89E123-FE94-48BE-BAE8-1CE8B0B04827'',''23558449-CEEB-4193-8B9D-CFEDAA5E66FB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''D596681B-47BA-4012-8871-0A0925F02551'',''9A40CEB4-AF0C-416B-8F90-D0C092B99290'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''B29D141F-A7E6-4414-BCCF-E6C1006D1BB8'',''68CE2F7E-0117-4BAD-8785-D4C135B096C6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''6A3A562D-113D-411D-970C-984601BF5913'',''435D6089-F16A-4785-9615-D52F4AD81635'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''05699AE4-166B-45C6-AC15-AFC36D1D4CCE'',''73C82FFF-72A4-42D0-ABD4-D898500E4532'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''CE22C111-CBF0-4159-800A-D34F4F75B00C'',''AAE39E49-7FD4-41B7-AF02-DBEEA7217CE4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''7A07F323-37CC-4DEF-8834-454283391D49'',''954F6280-7F4B-4EDA-86F4-E2C46081FCAE'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''76BA2A65-8733-4B13-9462-774BB297FB3B'',''036C0DB5-F966-4B9B-9FDB-E2EA7C95BDE5'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''A393245A-8E21-45E0-AC03-55D9593203F4'',''B7CC4715-6B1D-4A2A-9CA3-EB4E8E8F1910'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''06F42124-9C98-4750-B7CD-1426B6D9D7E9'',''0C5E440F-B719-4362-B8F7-EC4A339AAE97'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''2DD0A418-9259-45E1-B185-BEAAD3B05DB7'',''E7C4C973-BDF8-4630-9F0C-ED28039B59FC'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''11FB3492-92A3-4779-8808-036CD1802004'',''CAA069F4-D786-44A0-B799-EDF37390891D'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''C119470F-2682-4663-AE51-880781EDDF42'',''151A38E2-3C4B-4568-A636-F1F9549C9CD9'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''42002752-600B-4A06-A83A-9327A32D980A'',''F2162027-8A01-493C-84C2-F4DEB66AC30D'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''AC361E85-FAA2-4E49-8C17-2125049AD230'',''4156B5B2-111D-45ED-BA12-F5DB21260B68'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''704D0317-33F7-46D8-B893-ABED31D7E9CA'',''73E181B7-B1F1-45BA-A0E3-F796A22F20D8'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''68B85DDC-C03D-46F4-97CF-B523AEBFE154'',''286D690E-4FF3-4CDB-BE0C-F93FA9613EA4'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''93D9816C-C0E1-498A-996A-E237CCA6324D'',''990577D1-92A2-4A24-B0A0-FA085537E433'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''9F246E70-E728-4534-90BE-13CE06307D9C'',''08E8EADD-5E9B-46B1-AE6C-FA6F5D033BC6'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''BAD4DBD8-7F28-40B1-9F48-10E5DEC0EC87'',''E90F59D9-37C0-4DB9-8C48-FB0CC13003CB'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    INSERT INTO @tblListOrds SELECT 
    ''2BADDBCD-078A-4D68-A226-6856BE52C30A'',''32786351-590D-4341-A1A4-FB926D445524'',0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,''A027475E-B572-48D6-9FD8-6B5DDAD637C6'',''BCD50F31-5DE1-4F98-95CD-BF045141E569'',''774DB73E-2FA4-4C9D-B382-E57E50F64460'' 
    SELECT UserData.[tp_ID] AS QryCol0,ListOrds.[WebId] AS QryCol1,ListOrds.[ListId] AS 
    QryCol2,UserData.[tp_Created] AS QryCol3,t1.[Type] AS QryCol4,CASE WHEN DATALENGTH(t1.DirName) = 0 THEN 
    t1.LeafName WHEN DATALENGTH(t1.LeafName) = 0 THEN t1.DirName ELSE t1.DirName + N''/'' + t1.LeafName END  AS 
    QryCol5,UserData.[tp_ModerationStatus] AS QryCol6,UserData.[tp_Level] AS QryCol7,UserData.[ntext1] AS 
    QryCol8,UserData.[nvarchar1] AS QryCol9,UserData.[tp_Modified] AS QryCol10,UserData.[tp_Author] AS 
    QryCol11,t2.[nvarchar1] AS QryCol12,t2.[tp_ID] AS QryCol13,t2.[nvarchar4] AS QryCol14,t2.[nvarchar5] AS 
    QryCol15,t2.[tp_Created] AS QryCol16,UserData.[tp_Editor] AS QryCol17,t3.[nvarchar1] AS QryCol18,t3.[tp_ID] AS 
    QryCol19,t3.[nvarchar4] AS QryCol20,t3.[nvarchar5] AS QryCol21,t3.[tp_Created] AS QryCol22,NULL AS 
    QryCol23,NULL AS QryCol24,NULL AS QryCol25,UserData.[float1] AS QryCol26,UserData.[nvarchar3] AS 
    QryCol27,UserData.[nvarchar9] AS QryCol28,UserData.[int3] AS QryCol29,t4.[nvarchar1] AS 
    QryCol30,UserData.[nvarchar11] AS QryCol31,t5.[Status1] AS QryCol32,t1.[ScopeId] AS QryCol33,t1.[Id] AS 
    QryCol34,ListOrds.[ListProperty.DraftVersionVisibility] AS QryCol35 FROM @tblListOrds AS ListOrds INNER LOOP 
    JOIN UserData WITH(NOLOCK) ON ListOrds.ListId=UserData.tp_ListId AND ListOrds.JoinOrd=0  INNER JOIN Docs AS t1 
    WITH(NOLOCK) ON ( 1 = 1  AND UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = 
    @L2 AND t1.DirName = UserData.tp_DirName  AND t1.LeafName = UserData.tp_LeafName  AND t1.Level = 
    UserData.tp_Level  AND t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, 
    INDEX=AllUserData_PK) ON (UserData.[tp_Author]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND 
    t2.[tp_RowOrdinal] = 0 AND ( (t2.tp_IsCurrent = 1) )  AND t2.[tp_CalculatedVersion] = 0  AND 
    t2.[tp_DeleteTransactionId] = 0x  AND t2.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t3 
    WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[tp_Editor]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND 
    t3.[tp_RowOrdinal] = 0 AND ( (t3.tp_IsCurrent = 1) )  AND t3.[tp_CalculatedVersion] = 0  AND 
    t3.[tp_DeleteTransactionId] = 0x  AND t3.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t4 
    WITH(NOLOCK, INDEX=AllUserData_PK) ON (UserData.[int3]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND 
    t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent = 1) )  AND t4.[tp_CalculatedVersion] = 0  AND 
    t4.[tp_DeleteTransactionId] = 0x  AND t4.tp_ListId = ListOrds.JoinKeyId2) LEFT OUTER JOIN Workflow AS t5 
    WITH(NOLOCK) ON ( CAST ( CAST (UserData.[nvarchar11]AS VARBINARY) AS UNIQUEIDENTIFIER)=t5.[ID] AND 
    UserData.[tp_RowOrdinal] = 0 AND t5.SiteId = @L2 AND t5.ListId = UserData.tp_ListId AND t5.ItemId = 
    UserData.tp_Id) WHERE ((UserData.[tp_ContentTypeId])  >= 0x0100F132384C21CDBA40853CA2E349C19AC6 AND 
    (UserData.[tp_ContentTypeId]) <= 0x0100F132384C21CDBA40853CA2E349C19AC6 + 0xff) UNION ALL SELECT 
    UserData.[tp_ID] AS QryCol0,ListOrds.[WebId] AS QryCol1,ListOrds.[ListId] AS QryCol2,UserData.[tp_Created] AS 
    QryCol3,t1.[Type] AS QryCol4,CASE WHEN DATALENGTH(t1.DirName) = 0 THEN t1.LeafName WHEN DATALENGTH(t1.LeafName) 
    = 0 THEN t1.DirName ELSE t1.DirName + N''/'' + t1.LeafName END  AS QryCol5,UserData.[tp_ModerationStatus] AS 
    QryCol6,UserData.[tp_Level] AS QryCol7,UserData.[ntext1] AS QryCol8,UserData.[nvarchar1] AS 
    QryCol9,UserData.[tp_Modified] AS QryCol10,UserData.[tp_Author] AS QryCol11,t2.[nvarchar1] AS 
    QryCol12,t2.[tp_ID] AS QryCol13,t2.[nvarchar4] AS QryCol14,t2.[nvarchar5] AS QryCol15,t2.[tp_Created] AS 
    QryCol16,UserData.[tp_Editor] AS QryCol17,t3.[nvarchar1] AS QryCol18,t3.[tp_ID] AS QryCol19,t3.[nvarchar4] AS 
    QryCol20,t3.[nvarchar5] AS QryCol21,t3.[tp_Created] AS QryCol22,NULL AS QryCol23,NULL AS QryCol24,NULL AS 
    QryCol25,UserData.[float1] AS QryCol26,UserData.[nvarchar3] AS QryCol27,UserData.[nvarchar9] AS 
    QryCol28,UserData.[int3] AS QryCol29,t4.[nvarchar1] AS QryCol30,UserData.[nvarchar11] AS QryCol31,8 AS 
    QryCol32,t1.[ScopeId] AS QryCol33,t1.[Id] AS QryCol34,ListOrds.[ListProperty.DraftVersionVisibility] AS 
    QryCol35 FROM @tblListOrds AS ListOrds INNER LOOP JOIN UserData WITH(NOLOCK) ON 
    ListOrds.ListId=UserData.tp_ListId AND ListOrds.JoinOrd=1  INNER JOIN Docs AS t1 WITH(NOLOCK) ON ( 1 = 1  AND 
    UserData.[tp_RowOrdinal] = 0 AND t1.SiteId = UserData.tp_SiteId AND t1.SiteId = @L2 AND t1.DirName = 
    UserData.tp_DirName  AND t1.LeafName = UserData.tp_LeafName  AND t1.Level = UserData.tp_Level  AND 
    t1.IsCurrentVersion = 1 AND (1 = 1)) LEFT OUTER JOIN AllUserData AS t2 WITH(NOLOCK, INDEX=AllUserData_PK) ON 
    (UserData.[tp_Author]=t2.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t2.[tp_RowOrdinal] = 0 AND ( 
    (t2.tp_IsCurrent = 1) )  AND t2.[tp_CalculatedVersion] = 0  AND t2.[tp_DeleteTransactionId] = 0x  AND 
    t2.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t3 WITH(NOLOCK, INDEX=AllUserData_PK) ON 
    (UserData.[tp_Editor]=t3.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t3.[tp_RowOrdinal] = 0 AND ( 
    (t3.tp_IsCurrent = 1) )  AND t3.[tp_CalculatedVersion] = 0  AND t3.[tp_DeleteTransactionId] = 0x  AND 
    t3.tp_ListId = ListOrds.JoinKeyId1) LEFT OUTER JOIN AllUserData AS t4 WITH(NOLOCK, INDEX=AllUserData_PK) ON 
    (UserData.[int3]=t4.[tp_ID] AND UserData.[tp_RowOrdinal] = 0 AND t4.[tp_RowOrdinal] = 0 AND ( (t4.tp_IsCurrent 
    = 1) )  AND t4.[tp_CalculatedVersion] = 0  AND t4.[tp_DeleteTransactionId] = 0x  AND t4.tp_ListId = 
    ListOrds.JoinKeyId2) WHERE ((UserData.[tp_ContentTypeId])  >= 0x0100F132384C21CDBA40853CA2E349C19AC6 AND 
    (UserData.[tp_ContentTypeId]) <= 0x0100F132384C21CDBA40853CA2E349C19AC6 + 0xff)',N'@L0 uniqueidentifier,@L2 
    uniqueidentifier',@L0='00000000-0000-0000-0000-000000000000',@L2='3B93D04F-7A20-4A69-9E97-611C553FFCB7'

    Notice that the first 15 INSERT INTO Statements have the followign pattern

    INSERT INTO @tblListOrds SELECT ''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,0,1

    but after the first 15 INSERT INTO STATEMENT the pattern becomes

    INSERT INTO @tblListOrds SELECT ''22103B05-EF3B-48CA-B0C4-89BFA57691ED'',''047C823F-B3DA-4E70-99FB-0BA20DA2FF73'',0,1,1

    If I take this QUERY and update these insert statements to all follow the first pattern, all results are returned as expected.

    Otherwise only the first 15 rows are returned the the correct values, with the remaining rows returning AuditWor = 8

    Thanks,

    Mike

    Wednesday, February 8, 2012 4:54 PM
  • Also.. I just realized I posted this in SP2010 forum. I am having this issue on SP 2007. I have tried to fix on SP1, SP2, and SP3.

    Sorry for the inconvienience. Can you still help?

    Wednesday, February 8, 2012 5:52 PM
  • Hi,

    Yes, we can still help.  We will try to repro this with the new information.


    Regards, Savoeurn Va Microsoft Online Community Support

    Thursday, February 16, 2012 2:55 AM
  • Any luck? In the meantime I have added a step to shuffle the actual Workflow Status variable over to another field, which is working in the interim.

    Wednesday, February 29, 2012 4:55 PM
  • Hi Mr Pullen,

    Sorry about the long delay in response, I’ve been out of the office for some time. As for this repro, I still cannot get it to repro on our
    side with the new information.  There might be something else on your farm that we are not seeing.   If you would like to investigate this further, you could open a paid support ticket and discuss with an engineer on a 1:1 basis to determine the cause of this on
    your environment.

    In the meantime, members of the community are welcome to contribute to this thread.


    Regards, Savoeurn Va Microsoft Online Community Support

    Friday, March 30, 2012 10:04 PM