Viewing 15 posts - 331 through 345 (of 842 total)
September 18, 2018 at 2:40 pm
September 17, 2018 at 10:33 am
Jason A. Long - Friday, September 14, 2018 2:12 PMIn addition to the ROW_NUMBER method offered up by below86, ...
I said to...
September 17, 2018 at 8:19 am
September 14, 2018 at 8:46 am
Ed Wagner - Wednesday, September 12, 2018 12:24 PMAlways Wins
Alabama football 😀
September 13, 2018 at 12:13 pm
No problem, sometimes helps to have another set of eyes.
See if this would be any faster:SELECT t0.IdSeller, t0.ProductsCount, t0.AvgPrice,
MAX(Date) AS Maxdate
FROM SellerProductsSnapshots t0
INNER...
September 11, 2018 at 1:20 pm
This may get the same thing, without data I can't test:SELECT t0.IdSeller, t0.ProductsCount, t0.AvgPrice,
MAX(Date) AS Maxdate
FROM SellerProductsSnapshots t0
WHERE IdSeller IN (SELECT Id FROM #SellersTable)
September 11, 2018 at 12:30 pm
As others have said running the SQL as written returns nothing, so option one is wrong. This part makes it wrong "and the Options column with 3 XML nodes."
Why...
September 11, 2018 at 8:25 am
September 5, 2018 at 1:30 pm
September 5, 2018 at 8:18 am
They're too noisy, have...
August 27, 2018 at 9:38 am
August 24, 2018 at 2:01 pm
They don't have to be the same name. Just same number of columns and same order and data type.
August 24, 2018 at 1:56 pm
Viewing 15 posts - 331 through 345 (of 842 total)