Comments by Member 14936854

Member 14936854 3-May-21 12:05pm View

could you please help me with the query

Member 14936854 22-Mar-21 6:49am View

if any one of the column is having Valid Lvl 1 then update validation as Yes to a set

Member 14936854 22-Mar-21 6:44am View

tried this but not getting correct result

Member 14936854 22-Mar-21 6:44am View

update d set d.[validation]=case when d3.Output >0 then 'Yes' else 'No' end
from #tempx1 d
outer apply ( select top 1 count(*) as Output
from #tempx1 d2
where d2.abc= d.abc
and d2.id=d.id
and [Check at LVL 1]='Valid Lvl 1'
or [Check_at_LVL 2]='Valid Lvl 1'
group by d2.id,d2.abc
order by d2.Id desc) d3

Member 14936854 22-Mar-21 6:42am View

Yes query

Member 14936854 18-Mar-21 10:36am View

Nope it’s different then this I have to populate count where level ends at 1

Member 14936854 18-Mar-21 6:53am View

in above table if you see count of 2 in level is 5 and which is populated to last value or end of level 1

Member 14936854 18-Mar-21 6:51am View

Thank for the query But i need count at column level ends with 1 as shown in table for level=2

Member 14936854 17-Mar-21 9:07am View

how to update column with above value i am getting error Windowed functions can only appear in the SELECT or ORDER BY clauses.

Member 14936854 17-Mar-21 4:05am View

if it is 2 then update as comp available for level 1

Member 14936854 17-Mar-21 4:04am View

then next row value of level 1

Member 14936854 13-Mar-21 6:26am View

Here is the out put i need

BOM Lvl ref Parent Item
2SZ46AV 0 2SZ46AV NULL
2SZ46AV 1 934253-142 2SZ46AV
2SZ46AV 1 722979-002 2SZ46AV
2SZ46AV 2 708984-001 722979-002
2SZ46AV 1 L16720-001 2SZ46AV
2SZ46AV 1 L37344-001 2SZ46AV
2SZ46AV 2 933274-001 L37344-001

Member 14936854 13-Mar-21 6:22am View

Thanks for the query i tried but its not working with my data here is my data

id bom lvl ref
38843 2SZ46AV 0 2SZ46AV
38844 2SZ46AV 1 934253-142
38845 2SZ46AV 1 722979-002
38846 2SZ46AV 2 708984-001
38847 2SZ46AV 1 L16720-001
38848 2SZ46AV 1 L37344-001
38849 2SZ46AV 2 933274-001
38850 2SZ46AV 2 L47720-001

Member 14936854 13-Mar-21 0:43am View

https://i.stack.imgur.com/1P3TZ.png

Member 14936854 13-Mar-21 0:40am View

Parent item should populate value of product no where lvl =0 for lvl 1 and for lvl 2 it has to populate lvl 1 like wise for all rows

Member 14936854 17-Dec-20 2:01am View

Input file is in that format and i have to convert it to output file as shown in output table

Comments by Member 14936854 (Top 16 by date)