Using Comments to Quickly Test CTEs
A quick tip for using a combination of block and line comments to test CTEs
2014-11-10
7,350 reads
Carl P. Anderson
Concatenating Rows
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
2011-03-04 (first published: 2009-10-14)
149,088 reads
Blogs
Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)
By Will Assaf
On July 27, Christine and I will present our joint presentation on Ethics in...
Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
Forums
convert hours into decimal
i have a formula that calculates the difference between two dates and tells me...
Get charges percentage per entity\channel
I trying to figure out what percentage of the total charge for a ME...
How to find islands and get max and min range values
I am trying to create groups for each Name and save the max and...
Ask SSC