T_SQL

T_SQL copied to clipboard

itsapep

The correct option should be ORDER BY ProductCategoryID ASC, ListPrice DESC I've ran the code and option 3 fits the requirement more with the added sorting from ProductCategoryID ASC \m/

briczy

The correct script is ``` DECLARE @OrderID int = 0 -- Declare a custom error if the specified order doesn't exist DECLARE @error VARCHAR(30) = 'Order #' + cast(@OrderID as...

schwaggs

The original query was ``` DECLARE @___ datetime = GETDATE(); DECLARE @___ datetime = DATEADD(dd, 7, GETDATE()); DECLARE @___ int = 1; INSERT INTO SalesLT.SalesOrderHeader (OrderDate, ___, ___, ShipMethod) VALUES...

schwaggs

In your second Insert you have the line `('Bicycle Horn', 'BH-PARP', 1.29, 3.75, IDENT_CURRENT('SalesLT.ProductCategory'), GETDATE());` Which should be `('Bicycle Horn', 'BB-PARP', 1.29, 3.75, IDENT_CURRENT('SalesLT.ProductCategory'), GETDATE());`

schwaggs