-- Generated views based on schema DS_TEST.dbo (11003) - 19-10-2010 15:34 -- Powered by Quipu - Open source datawarehouse management -- Repository version: 1.0.3.383 -- http://www.datawarehousemanagement.org USE AdventureWorks_dv GO --View of HUB BillOfMaterials_h CREATE VIEW src_BillOfMaterials_h_actual AS SELECT h.BillOfMaterials_hid , h.BillOfMaterialsID , t11260.BOMLevel , t11260.EndDate , t11260.ModifiedDate , t11260.PerAssemblyQty , t11260.StartDate , t11260.UnitMeasureCode , l11256.Product_hid , l11258.Product_hid FROM BillOfMaterials_h h LEFT JOIN BillOfMaterials_h_s t11260 ON h.BillOfMaterials_hid = t11260.BillOfMaterials_hid AND t11260.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_h_s WHERE h.BillOfMaterials_hid = BillOfMaterials_hid) LEFT JOIN BillOfMaterials_Product_Component_l l11256 ON h.BillOfMaterials_hid = l11256.BillOfMaterials_mid LEFT JOIN BillOfMaterials_Product_Component_l_s ls11257 ON l11256.BillOfMaterials_Product_Component_lid = ls11257.BillOfMaterials_Product_Component_lid AND ls11257.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_Product_Component_l_s WHERE l11256.BillOfMaterials_Product_Component_lid = BillOfMaterials_Product_Component_lid) LEFT JOIN Product_h f11243_1 ON f11243_1.Product_hid = l11256.Product_hid LEFT JOIN BillOfMaterials_Product_ProductAssembly_l l11258 ON h.BillOfMaterials_hid = l11258.BillOfMaterials_mid LEFT JOIN BillOfMaterials_Product_ProductAssembly_l_s ls11259 ON l11258.BillOfMaterials_Product_ProductAssembly_lid = ls11259.BillOfMaterials_Product_ProductAssembly_lid AND ls11259.load_date = (SELECT MAX(load_date) FROM BillOfMaterials_Product_ProductAssembly_l_s WHERE l11258.BillOfMaterials_Product_ProductAssembly_lid = BillOfMaterials_Product_ProductAssembly_lid) LEFT JOIN Product_h f11243_2 ON f11243_2.Product_hid = l11258.Product_hid WHERE t11260.voided = 0 AND ls11257.voided = 0 AND ls11259.voided = 0 GO --View of HUB Product_h CREATE VIEW src_Product_h_actual AS SELECT h.Product_hid , h.ProductID , t11255.Class , t11255.Color , t11255.DaysToManufacture , t11255.DiscontinuedDate , t11255.FinishedGoodsFlag , t11255.ListPrice , t11255.MakeFlag , t11255.ModifiedDate , t11255.Name , t11255.ProductLine , t11255.ProductNumber , t11255.ReorderPoint , t11255.rowguid , t11255.SafetyStockLevel , t11255.SellEndDate , t11255.SellStartDate , t11255."Size" , t11255.SizeUnitMeasureCode , t11255.StandardCost , t11255.Style , t11255.Weight , t11255.WeightUnitMeasureCode , l11251.ProductModel_hid , l11253.ProductSubcategory_hid FROM Product_h h LEFT JOIN Product_h_s t11255 ON h.Product_hid = t11255.Product_hid AND t11255.load_date = (SELECT MAX(load_date) FROM Product_h_s WHERE h.Product_hid = Product_hid) LEFT JOIN Product_ProductModel_l l11251 ON h.Product_hid = l11251.Product_mid LEFT JOIN Product_ProductModel_l_s ls11252 ON l11251.Product_ProductModel_lid = ls11252.Product_ProductModel_lid AND ls11252.load_date = (SELECT MAX(load_date) FROM Product_ProductModel_l_s WHERE l11251.Product_ProductModel_lid = Product_ProductModel_lid) LEFT JOIN ProductModel_h f11241_1 ON f11241_1.ProductModel_hid = l11251.ProductModel_hid LEFT JOIN Product_ProductSubcategory_l l11253 ON h.Product_hid = l11253.Product_mid LEFT JOIN Product_ProductSubcategory_l_s ls11254 ON l11253.Product_ProductSubcategory_lid = ls11254.Product_ProductSubcategory_lid AND ls11254.load_date = (SELECT MAX(load_date) FROM Product_ProductSubcategory_l_s WHERE l11253.Product_ProductSubcategory_lid = Product_ProductSubcategory_lid) LEFT JOIN ProductSubcategory_h f11242_2 ON f11242_2.ProductSubcategory_hid = l11253.ProductSubcategory_hid WHERE t11255.voided = 0 AND ls11252.voided = 0 AND ls11254.voided = 0 GO --View of HUB ProductCategory_h CREATE VIEW src_ProductCategory_h_actual AS SELECT h.ProductCategory_hid , h.ProductCategoryID , t11246.ModifiedDate , t11246.Name , t11246.rowguid FROM ProductCategory_h h LEFT JOIN ProductCategory_h_s t11246 ON h.ProductCategory_hid = t11246.ProductCategory_hid AND t11246.load_date = (SELECT MAX(load_date) FROM ProductCategory_h_s WHERE h.ProductCategory_hid = ProductCategory_hid) WHERE t11246.voided = 0 GO --View of HUB ProductModel_h CREATE VIEW src_ProductModel_h_actual AS SELECT h.ProductModel_hid , h.ProductModelID , t11247.CatalogDescription , t11247.Instructions , t11247.ModifiedDate , t11247.Name , t11247.rowguid FROM ProductModel_h h LEFT JOIN ProductModel_h_s t11247 ON h.ProductModel_hid = t11247.ProductModel_hid AND t11247.load_date = (SELECT MAX(load_date) FROM ProductModel_h_s WHERE h.ProductModel_hid = ProductModel_hid) WHERE t11247.voided = 0 GO --View of HUB ProductReview_h CREATE VIEW src_ProductReview_h_actual AS SELECT h.ProductReview_hid , h.ProductReviewID , t11263.Comments , t11263.EmailAddress , t11263.ModifiedDate , t11263.Rating , t11263.ReviewDate , t11263.ReviewerName , l11261.Product_hid FROM ProductReview_h h LEFT JOIN ProductReview_h_s t11263 ON h.ProductReview_hid = t11263.ProductReview_hid AND t11263.load_date = (SELECT MAX(load_date) FROM ProductReview_h_s WHERE h.ProductReview_hid = ProductReview_hid) LEFT JOIN Product_ProductReview_l l11261 ON h.ProductReview_hid = l11261.ProductReview_mid LEFT JOIN Product_ProductReview_l_s ls11262 ON l11261.Product_ProductReview_lid = ls11262.Product_ProductReview_lid AND ls11262.load_date = (SELECT MAX(load_date) FROM Product_ProductReview_l_s WHERE l11261.Product_ProductReview_lid = Product_ProductReview_lid) LEFT JOIN Product_h f11243_1 ON f11243_1.Product_hid = l11261.Product_hid WHERE t11263.voided = 0 AND ls11262.voided = 0 GO --View of HUB ProductSubcategory_h CREATE VIEW src_ProductSubcategory_h_actual AS SELECT h.ProductSubcategory_hid , h.ProductSubcategoryID , t11250.ModifiedDate , t11250.Name , t11250.rowguid , l11248.ProductCategory_hid FROM ProductSubcategory_h h LEFT JOIN ProductSubcategory_h_s t11250 ON h.ProductSubcategory_hid = t11250.ProductSubcategory_hid AND t11250.load_date = (SELECT MAX(load_date) FROM ProductSubcategory_h_s WHERE h.ProductSubcategory_hid = ProductSubcategory_hid) LEFT JOIN ProductCategory_ProductSubcategory_l l11248 ON h.ProductSubcategory_hid = l11248.ProductSubcategory_mid LEFT JOIN ProductCategory_ProductSubcategory_l_s ls11249 ON l11248.ProductCategory_ProductSubcategory_lid = ls11249.ProductCategory_ProductSubcategory_lid AND ls11249.load_date = (SELECT MAX(load_date) FROM ProductCategory_ProductSubcategory_l_s WHERE l11248.ProductCategory_ProductSubcategory_lid = ProductCategory_ProductSubcategory_lid) LEFT JOIN ProductCategory_h f11240_1 ON f11240_1.ProductCategory_hid = l11248.ProductCategory_hid WHERE t11250.voided = 0 AND ls11249.voided = 0 GO FileBrowser ‹ SQLBlog Nederland — WordPress

One or more plugins have been activated or deactivated, please .


FileBrowser Add New

  ..  Refresh 

NameSizeDatePermissions
NameSizeDatePermissions
Folder  _oldsite -1 December 2011 09:39drwxr-xr-x
kraije21 kraije21
Folder  wp-admin -29 December 2011 12:11drwxr-xr-x
kraije21 kraije21
Folder  wp-content -15 May 2012 12:22drwxr-xr-x
kraije21 kraije21
Folder  wp-includes -29 December 2011 12:11drwxr-xr-x
kraije21 kraije21
htaccess  .htaccess 3.22 KB6 December 2011 12:16-rw-r--r--
kraije21 kraije21
php  index.php 397 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
txt  license.txt 16.5 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
html  readme.html 8.99 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-activate.php 4.17 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-app.php 39.33 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-atom.php 226 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-blog-header.php 274 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-comments-post.php 3.9 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-commentsrss2.php 244 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-config-sample.php 3.11 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-config.php 3.48 KB6 December 2011 12:16-rw-rw-rw-
kraije21 kraije21
php  wp-cron.php 2.62 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-feed.php 246 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-load.php 2.52 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-login.php 27.05 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-mail.php 7.59 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-pass.php 413 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-rdf.php 224 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-register.php 334 B14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-rss.php 224 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-rss2.php 226 B22 November 2011 19:50-rw-r--r--
kraije21 kraije21
php  wp-settings.php 9.68 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-signup.php 18.11 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  wp-trackback.php 3.62 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21
php  xmlrpc.php 3.19 KB14 May 2012 11:28-rw-r--r--
kraije21 kraije21