Hello Community,
Can someone please help recode the following T-SQL such that I get the same result but without using Tally Table:
SELECT RowNo AS PeriodNumber
,Cost
,Cost / 5 AS StraightLineDepreciation
,Cost - ((Cost / 5) * RowNo) AS RemainingValue
FROM Data.Stock
CROSS APPLY
(
SELECT 1 AS RowNo
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5
) Tally
WHERE StockCode = 'A2C3B95E-3005-4840-8CE3-A7BC5F9CFB5F'
Thanks