Forum Discussion
SQL - removing data
But wouldnt that remove the 2 days completely?
I only need to remove the figures for those 2 styles on those 2 days. i still want all other data from those 2 days.
Does it make sense?
then simply create cte
;with cte as(
Select
Case when style_number in (value1,value2) and date in (value1,value2) then null else style_number end as [style number]
from table
)
select * from cte where [style number] is not null
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
It seems more like a solution that i am looking for, however, i am still a rookie at SQLs, so i dont really know how to put it in. Can you show me how to put it in, in relation to the SQL i posted? 🙂
And thank you!;with cte as(SELECT TTL_CALC_COST,
STOCK_AGE,
COLLECTION_NAME,
COLLECTION_TERM,
STOCK_DATE,
STOCK_COUNTRY_NAME,
QUANTITY_TYPE,
WAREHOUSE_NAME,
SUPPLY,
ASSRTMNT_TYPE_NAME,
QUANTITY,
TTL_WHS_EUR,
BRAND_NAME,
STYLES_ID,
SALES_TYPE,
COUNTRY_CMP,
STYLE_CATEGORY_NAME,
STYLE_SUBCATEGORY_NAME,
STYLE_TYPE,
case when STYLE_NUMBER in (val1,val2) && Date in ("val1","val2") then null else STYLE_NUMBER end as [STYLE_NUM] ,
STYLE_NAME,
COLLECTIONS_ID,
ASSORTMENTS_ID,
ASSORTMENT_NAME,
CUSTOMER_GROUPS_ID,
GROUP_NAME,
SUBDEPARTMENT_ID
FROM DISCOVER.DISC_STOCK
Where SUBDEPARTMENT_ID = '21')select * from CTE where [style_num] is not null