Resolved: Alternative solution
I just wanted to check if my alternative solution is also valid. It produced similar results as the attached solution. Is the 365 attached solution the "most correct" way to do this? If so, why? I know a few of the videos mention optimization, could my code be less efficient on a larger scale/table?
1 answers ( 1 marked as helpful)
Thanks for reaching out.
Yes, your solution is valid. It depends on some factors like created indexes and the number of records. But for this DB your solution is optimized.
Hope this helps.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?
does not rollback and i don't know what i have to do , i do all sug solution with no result