|
My answer to this question: http://www.codeproject.com/Questions/1131514/Get-debit-credit-and-balance-in-datagridview-Cshar[^] contains SQL2012+ code:
SELECT ID, ITEMS_REF_NO, CR, DR,
SUM(CR - DR) OVER(ORDER BY ID
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
AS BAL
FROM MyTable2
The same query in SSMS has additional highlighting for ROWS, UNBOUNDED PRECEDING, and the full CURRENT ROW
Be nice if the syntax highlighter added that as well.
Loooooow priority though - it doesn't affect anything in any significant way!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
The MSDN docs don't include UNBOUNDED PRECEDING, but ROW and ROWS are "Future reserved". It also looks like Microsoft hasn't updated (or published) a list of SQL 2014 or 2016 reserved words. All I can find is 2012.
I love standards. 
cheers
Chris Maunder
|
|
|
|
|
From what I'm seeing it seems that it's a very rare situation that an article/tip does not pass moderation even if it has formatting problems, is incomplete etc. Very often a message is left to the pending article along with several reports but they still get through.
Does the moderation mechanism serve it's purpose, meaning, is it needed anymore after all?
Of course there are always the spammy wannabe articles but what if suspicious articles (containing links somewhere else than MSDN or other 'respected' sites?) would still have a moderation queue...
|
|
|
|
|
Rather than throwing out the moderation queue because of a few "approve-happy" moderators, surely it would be better to tighten up the requirements for being a moderator, and/or get Sean to pay a visit to the rogue moderators in whatever nightmare-inducing costume he's wearing this season, possibly accompanied by the ClueBat? 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
This is exactly my point A properly working moderation would be a benefit for all but at the moment it requires some work.
|
|
|
|
|
From the Article FAQ:
The way the moderation works is you have to receive five "Approve" items to be published, or five "Report / Needs help" items to reach a different article status. If five members Approve your article it will become live and available for all to see. If five members either "Report" or mark your article as "Needs help" your article status will become "Closed" and you will receive an email notification indicating who closed the article, why, and what to do
It seems to me that they need to increase the number of approvals AND increase the author level needed to approve from silver to gold. However, I've seen articles with as many as 20 "reports", and yet it remains in "moderation".
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
I'd agree to an extent, but I'd put that down to bad moderating rather than a process that isn't fit.
It still weeds out a lot of plagiarism and spam, even if some of the dross articles do get through that aren't ready yet.
Education of new moderators would probably help more than getting rid of the process.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
I still argue for making approvers visible for a certain group of people, let's say Protectors, Mentors and / or very (but really very) high ranked authors... so that when such articles get approved, that reduced group of people could speak with the happy-shiny moderators.
And why not... a possibility to create a "black list", of course this only available for the staff, and take the privilege of approving to people who doesn't take care about quality and give the approvals away indiscriminately
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
The most interesting part is that it spells "Colourised" correctly.
|
|
|
|
|
Canadians can spell, unlike their nearest neighbours! 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
OriginalGriff wrote: neighbours
FTFY 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: neighbours
FTFY!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
The thing about our neighbors to the north is...
Robin Williams: Canada is like a loft apartment over a really great party.
if (Object.DividedByZero == true) { Universe.Implode(); }
Meus ratio ex fortis machina. Simplicitatis de formae ac munus. -Foothill, 2016
|
|
|
|
|
Happens in articles too. Maybe they left some sort of debugger active in this build.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|
|
Perhaps the colouriser is just proud of its achievement?
|
|
|
|
|
Quick! Look over there!
<tappity, tappity, TAPPITYTAPPITYTAPPITY. tap>
No idea what you're talking about. 
cheers
Chris Maunder
|
|
|
|
|
Where? Where?
Great Scott! A Lesser-spotted Code Weebler! They're endangered, you know, I haven't seen one of them round here in oooh, years, hopefully it's part of a breeding pair...oh. The cat got it.
Nothing to see here... :InnocentWhistleSmiley:
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
And I thought that was a new feature... 
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
|
Should be fixed now.
cheers
Chris Maunder
|
|
|
|
|
Yes. Thanks a lot Chris 
___@sHubHa
|
|
|
|
|
|
Fixed: will deploy soon
cheers
Chris Maunder
|
|
|
|
|
On article http://www.codeproject.com/Articles/238114/Realtime-Webcam-Sudoku-Solver
At the bottom there is section "Video". You will see dummy "video-placeholder youtube" tag. Youtube video used to work there for years. Dear admin/editor, can you please reactivate that youtube box? Thank you!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
