Cacher is the code snippet organizer for pro developers

--SELECT TOP 10 * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd--412708


--Support Model--12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PM_PRODUCT_DIM_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.BASE_GRAIN_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.COMPANY_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_CLASSIFICATION_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_LINE_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_ORGANIZATION_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_GROUP_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.BUSINESS_UNIT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PLATFORM_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.MKTG_HIGH_LEVEL_AUDIENCE_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SPT_HIGH_LEVEL_AUDIENCE_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_MODEL_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SUPPORT_MODEL_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_SERIES_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_BIGSERIES_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.MKTG_PRODUCT_SUBCAT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SPT_PRODUCT_SUBCAT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.MKTG_PRODUCT_CAT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SPT_PRODUCT_CAT_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRIMARY_PRODUCT_TYPE_KY = 12169
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SECONDARY_PRODUCT_TYPE_KY = 12169


SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SUPPORT_MODEL_KY = 244619
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_SERIES_KY = 254588
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRODUCT_BIGSERIES_KY = 4058819
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SPT_PRODUCT_SUBCAT_KY = 314919
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.SPT_PRODUCT_CAT_KY = 82653
SELECT * FROM dbo.LUXOR_PM_PRODUCT_DIM lppd WHERE lppd.PRIMARY_PRODUCT_TYPE_KY = 12169


--ProductType--15
SELECT DISTINCT lppd.PRIMARY_PRODUCT_TYPE_KY
	,lppd.PRIMARY_PRODUCT_TYPE_NM
	,lppd.PRIMARY_PRODUCT_TYPE_DN
	,lppd.PRIMARY_PRODUCT_TYPE_SNI
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd

--Support Category--440
SELECT DISTINCT lppd.SPT_PRODUCT_CAT_KY
	,lppd.SPT_PRODUCT_CAT_NM
	,lppd.SPT_PRODUCT_CAT_SNI
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd

--Support SubCategory--1140
SELECT DISTINCT lppd.SPT_PRODUCT_SUBCAT_KY
	,lppd.SPT_PRODUCT_SUBCAT_NM
	,lppd.SPT_PRODUCT_SUBCAT_SNI
	,lppd.SPT_PRODUCT_SUBCAT_ABBRV_NM
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd

--Product BigSeries--4891
SELECT DISTINCT lppd.PRODUCT_BIGSERIES_KY
	,lppd.PRODUCT_BIGSERIES_NM
	,lppd.PRODUCT_BIGSERIES_DN
	,lppd.PRODUCT_BIGSERIES_SNI
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd

--Product Series--11907
SELECT DISTINCT lppd.PRODUCT_SERIES_KY
	,lppd.PRODUCT_SERIES_NM
	,lppd.PRODUCT_SERIES_DN
	,lppd.PRODUCT_SERIES_SNI
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd

--Support Model--153088
SELECT DISTINCT lppd.SUPPORT_MODEL_KY
	,lppd.SUPPORT_MODEL_NM
	,lppd.SUPPORT_MODEL_SNI,lppd.PRODUCT_LINE_CD
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd


SELECT PRIMARY_PRODUCT_TYPE_KY
	,SPT_PRODUCT_CAT_KY
	,SPT_PRODUCT_SUBCAT_KY
	,PRODUCT_BIGSERIES_KY
	,PRODUCT_SERIES_KY
	,SUPPORT_MODEL_KY
	,PRODUCT_LINE_KY
	,lppd.PRODUCT_LINE_CD
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd
ORDER BY PRIMARY_PRODUCT_TYPE_KY
	,SPT_PRODUCT_CAT_KY
	,SPT_PRODUCT_SUBCAT_KY
	,PRODUCT_BIGSERIES_KY
	,PRODUCT_SERIES_KY
	,SUPPORT_MODEL_KY
	,PRODUCT_LINE_KY
	,lppd.PRODUCT_LINE_CD
	
SELECT lppd.PRODUCT_LINE_KY, lppd.PRODUCT_LINE_CD, lppd.PRODUCT_LINE_NM,COUNT(PRODUCT_SERIES_KY) ProductSeriesCount
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd
GROUP BY lppd.PRODUCT_LINE_KY, lppd.PRODUCT_LINE_CD, lppd.PRODUCT_LINE_NM
ORDER BY lppd.PRODUCT_LINE_KY


----------------------------------------
SELECT * FROM dbo.ProductType pt
SELECT * FROM dbo.SupportCategory sc
SELECT * FROM dbo.SupportSubCategory ssc
SELECT * FROM dbo.ProductBigSeries pbs
SELECT * FROM dbo.ProductSeries ps
SELECT * FROM dbo.Product p
SELECT * FROM dbo.ProductLine pl

---------------------------------------

SELECT
	lppd.PRIMARY_PRODUCT_TYPE_KY,
	lppd.PRIMARY_PRODUCT_TYPE_NM
	,lppd.SPT_PRODUCT_CAT_KY
	,lppd.SPT_PRODUCT_CAT_NM
	,lppd.SPT_PRODUCT_SUBCAT_KY
	,lppd.SPT_PRODUCT_SUBCAT_NM
	,lppd.PRODUCT_BIGSERIES_KY
	,lppd.PRODUCT_BIGSERIES_NM
	,lppd.PRODUCT_SERIES_KY
	,lppd.PRODUCT_SERIES_NM	
	,lppd.SUPPORT_MODEL_KY
	,lppd.SUPPORT_MODEL_NM
	,COUNT(DISTINCT lppd.PRODUCT_LINE_KY)
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd
GROUP BY
	lppd.PRIMARY_PRODUCT_TYPE_KY,
	lppd.PRIMARY_PRODUCT_TYPE_NM
	,lppd.SPT_PRODUCT_CAT_KY
	,lppd.SPT_PRODUCT_CAT_NM
	,lppd.SPT_PRODUCT_SUBCAT_KY
	,lppd.SPT_PRODUCT_SUBCAT_NM
	,lppd.PRODUCT_BIGSERIES_KY
	,lppd.PRODUCT_BIGSERIES_NM
	,lppd.PRODUCT_SERIES_KY
	,lppd.PRODUCT_SERIES_NM
	,lppd.SUPPORT_MODEL_KY
	,lppd.SUPPORT_MODEL_NM HAVING COUNT(DISTINCT lppd.PRODUCT_LINE_KY) > 1
ORDER BY COUNT(DISTINCT lppd.PRODUCT_LINE_KY) DESC --11908


--Flags
SELECT lppd.ACTIVE_FG
	,lppd.LOGICAL_DELETE_FG
	,lppd.TANGIBLE_FG
	,lppd.SERIAL_FG
	,lppd.PMG_REQUEST_FG
	,lppd.RICH_TEXT_FG
	,lppd.SUPPORT_PUBLISH_FG
	,lppd.INCOMPL_HIER_FG
	,count(1)
FROM dbo.LUXOR_PM_PRODUCT_DIM lppd
GROUP BY lppd.ACTIVE_FG
	,lppd.LOGICAL_DELETE_FG
	,lppd.TANGIBLE_FG
	,lppd.SERIAL_FG
	,lppd.PMG_REQUEST_FG
	,lppd.RICH_TEXT_FG
	,lppd.SUPPORT_PUBLISH_FG
	,lppd.INCOMPL_HIER_FG
	
	---
	S: PS
	N: Base_Grain_KY Or Product_Model_KY not support model
	#: Base_Grain_KY Or Product_KY
	
	--Pmaster Tree as in https://pmaster.corp.hpe.com/ProductMaster.aspx
	Product Series
	  -> Product Model
	      -> Product Key