Feeds:
Posts
Comments

Archive for the ‘SQL’ Category

count distinct

To know whether one external_item_key could have more than one subvendorid:

select external_item_key, count(distinct subvendorid)  from dbo.ETL_BULKINSERT_TARGET_HISTORY_POWERSHELL group by external_item_key;

select distinct count(distinct subvendorid)  from dbo.ETL_BULKINSERT_TARGET_HISTORY_POWERSHELL group by external_item_key;

Read Full Post »