title: CTE not Recognized
body: <p>why isn't my CTE accessible from my last selects?  I'm asking specifically how I have my CTEs listed, I'm missing something simple such as how I'm separating the last two</p>
  
  <pre><code>    with ParentsIdsWhoHaveInventoryWithManifests_CTE(brokerIds)
      as (...)
          ...)
          select someField from ParentsIdsWhoHaveInventoryWithManifests_CTE
  
      ;with SpecificBrokersTicketIds_CTE(ticketIds)
      as (...)
          select someFieldfrom ParentsIdsWhoHaveInventoryWithManifests_CTE
  
      ;with ProductionIdsWhichHaveManifests_CTE(productionIds)
      as (...)
          select productionIds from ProductionIdsWhichHaveManifests_CTE
  
      ;with InventoryRow_CTE(row)
      as (select row from Inventory where TicketId = @TicketId)
  
      ;with InvenotrySection_CTE(section)
      as (select section from Inventory where TicketId = @TicketId)
  
  
      select @ManifestId = ManifestId from Productions p where p.ProductionId = @ProductionId
      select @ProductionId as ProductionId_Used
      select @ManifestId as ManifestId_Used
      select @TicketId = TicketId from inventory where ProductionId = @ProductionId
  
  ...
  
  update Venue_ManifestDetails
          set Row = row from InventoryRow_CTE,
          Section = section from InvenotrySection_CTE
          where TicketId = @TicketId
  </code></pre>
  
  <p>The problem is it doesn't recognize <code>InventoryRow_CTE</code> or <code>InvenotrySection_CTE</code> CTEs in my update statement.</p>