Adding different values from a table to find a specific sum value
There are times when I need to find a certain value out of a number of records. For example, assume …
![SQL]()
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data....
Read more- 61K Content
- 7.8K Contributors
Expert Spotlight
COG Lead Engineer
I'm Shaun Vermaak. I love tech and how it improves life and business. Did you find what you were looking for?
Troubleshooting Solution
Article
Dynamic Pivot Procedure for SQL Server
by Mark Wills
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
Repair Corrupt SQL Database with Stellar Phoenix SQL Database Repair Software
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues…
Post
This is a cool tool to help visualize explain plans in …
This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Post
So excited for SQL Server 2017. …
So excited for SQL Server 2017.
…
…
Post
Sequential or Random Rows in Microsoft Access Study my …
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Study my new articles on this topic…
Article
A SQL Tidbit: Conditional Aggregates
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't…
Post
It's interesting to see where the SQL co-creator sees …
It's interesting to see where the SQL co-creator sees similarities between SQL and NoSQL. …
Troubleshooting Solution
Get total of hours between date fields and midnight.
Hi Experts,
I am trying to get the count of hours between a given date/time field and 12 midnight.
The
…
Article
Beware of Between
'Between' is such a common word we rarely think about it but in SQL it has a very specific …
Post
I haven't worked with SQL Server since 2001. Now I'm trying …
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Troubleshooting Solution
Dynamic changing of dblink in Oracle sql
How to concatenate dblink which will change dynamically in a Oracle SQL Statement at the end of the …
Troubleshooting Solution
DB2 SQL - find uptime values in a table
Hi all,
I have hundreds of identical tables - one for every hour:
I_YEAR INTEGER NOT …
I have hundreds of identical tables - one for every hour:
I_YEAR INTEGER NOT …
Troubleshooting Solution
Names of places in DK
My project is to create a service that helps users to find names of places in Denmark.
I use a …
I use a …
Troubleshooting Solution
How to use Powershell data from SQL
Hello,
This is in regards to question asked here:
…
This is in regards to question asked here:
…
Troubleshooting Solution
Dlookup problem
Based on the following print screen provided i am trying to do a Dlookup on that query (the tables …
Troubleshooting Solution
Create a SQL Database
Hi all, I am sorry for this but I have been out of town visiting a deathly ill family member and am …
Troubleshooting Solution
fiscal year end calculations
I need to perform some calculations based on our clients fiscal year ends. Not all of our clients …
Troubleshooting Solution
How to create a dynamic query builder
I am trying to determine the best way to go about creating the code necessary to allow a user form …
Article
Fun with MS SQL spt_values for delimited strings and virtual calendars
By Mark Wills
Not so long ago, there was a fairly tricky question on Experts Exchange to do with …
Not so long ago, there was a fairly tricky question on Experts Exchange to do with …
Explore solutions and more
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.