Viewing 15 posts - 331 through 345 (of 844 total)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 24, 2018 at 8:22 am
You could try this:
CONVERT(CHAR(11), DateIn, 107) AS DateIn
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 21, 2018 at 7:50 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 18, 2018 at 2:40 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 17, 2018 at 10:33 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 17, 2018 at 8:24 am
Jason A. Long - Friday, September 14, 2018 2:12 PMIn addition to the ROW_NUMBER method offered up by below86, ...
I said to...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 17, 2018 at 8:19 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 14, 2018 at 8:46 am
Ed Wagner - Wednesday, September 12, 2018 12:24 PMAlways Wins
Alabama football 😀
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
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)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 11, 2018 at 8:25 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 5, 2018 at 1:30 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
September 5, 2018 at 8:18 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 28, 2018 at 7:36 am
They're too noisy, have...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
August 27, 2018 at 9:38 am
Viewing 15 posts - 331 through 345 (of 844 total)