30 Sep 2018 by Maciej Los
Check this: DECLARE @commodity TABLE(id INT IDENTITY(1,1), parentID INT, [name] VARCHAR(30)) INSERT INTO @commodity(parentID, [name]) VALUES(null, 'foods'), (1, 'fruits'), (2, 'apple'), (2, 'orange'), (2, 'melon'), (1, 'sea foods'), (6, 'salmon'), (6, 'shrimp') DECLARE @saleDetail...