SUM()

Question

Post reply

SUM()

Pulivarthi Sasidhar

SSCertifiable

Points: 6706
More actions
May 19, 2016 at 10:47 pm

#326593

Comments posted to this topic are about the item SUM()

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 1

Stewart "Arturius" Campbell,Thanks for your comments..

There are some typo in Explanation , plz understand yourself :-P.

Sean Lange SSC Guru Points: 286602 More actions · Answer 2

Great question to end the week.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

A great question to illustrate the concept of the "presence of rows" instead of the content of the row.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

paul s-306273 SSChampion Points: 10730 More actions · Answer 4

paul s-306273

SSChampion

Points: 10730

May 20, 2016 at 7:36 am

#1880484

Nice question!

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 5

I don't recall ever writing code that passes a literal value to SUM() before, so when I saw the literal, my brain translated it to a column reference. I was ready to select 6.5.

Cleverly written question. Nice job.

call.copse SSCoach Points: 18142 More actions · Answer 6

Kaye Cahs (5/20/2016)
I don't recall ever writing code that passes a literal value to SUM() before, so when I saw the literal, my brain translated it to a column reference. I was ready to select 6.5.
Cleverly written question. Nice job.

Me too, as I often write ordinal column refs in scratch code. Terrible habit I know, especially with fairly helpful auto-complete in SMSS these days!

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

May 23, 2016 at 6:46 am

#1880720

Thanks for the reminder on how that works.

SUM()

Cookies on SQLServerCentral