Recent content by Tuux
-
T
Help with "At most one record can be returned using this subquery"
THANK YOU! I had two rows in Prices with the same SKU+DATE, the error explained the problem. Problem solved -
T
Help with "At most one record can be returned using this subquery"
Hi Thanks in advance for helping. I'm using the following query to grab the most recent price from TR-Prices, this query (Generate-Latest-Prices) is still working TR Prices contains three columns, SKU DATE PRICE (SELECT TOP 1 Price FROM [TR-Prices] AS T1 WHERE T1.SKU = [TR-Prices].SKU AND...