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- 60K Content
- 7.7K Contributors
Expert Spotlight
Database Administrator / Software Engineer
Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.
Leading Experts In
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…
Troubleshooting Solution
Know which batch is in stock on a selected date
Hi,
I have a problem with this query that I just realized, with the test data everything seemed fine,
…
Troubleshooting Solution
Display the name of the user according to his chosen time
Hello,
I'm asking for your help with filling out a table.
I am unable to display the name of the user
Troubleshooting Solution
Search specific field name
Is it possible to search a specific field name in multiple tables using query or from menu options
…
Troubleshooting Solution
T-SQL script to generate a calculation based on some numbers
Hello Experts,
I have a table with column containing these values. I need to create a SQL Script for
…
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
Optimize the SQL
Optimzing this SQL which is taking huge time,
My acl table is having 30679616 rows and ACCT
…
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…
Article
SSMS MSSql Change the column length of a table with a primary key and retain the IDs
I was surprised on searching desperately not to find a clear answer for what would appear outwardly to be a fairly simple operation in a Microsoft SQL database server.
Alter the column width of a text field from 48 to 60 and retain the primary key.
So here's one for anyone facing similar issue.
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 …
Article
Beware of Between
'Between' is such a common word we rarely think about it but in SQL it has a very specific …
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 …
Research Solution
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 …
Article
Some Useful Tips to Configure SQL Server Log Shipping
With the introduction of AlwaysOn Availability Group (AAG) in SQL Server 2012, log shipping seems to be less widely used than before. AlwaysOn Availability Group provides real-time log shipping as transactions are committed/applied to the primary database server.
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.