Mr or Mrs. 500
Comments posted to this topic are about the item What’s the Difference Between PERCENT_RANK and CUME_DIST?
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Some minor fix is required.
Originally, the AvgHighTempC is set to "not null", by default.
To make the "update table" work, the table constructor needs the "null" for the said column.
CREATE TABLE #MonthlyTempsStl(MNo Int,
AvgHighTempC DECIMAL(4,2) null )
I like your posting. Well put together and easy to follow. Well done!
Viewing 3 posts - 1 through 2 (of 2 total)