Explore SQL on Experts Exchange

Expert Solutions for Your Tech Problems

SQLSQL

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
Microsoft Developer

Developer ´& Designer of Business Solutions based on SQL Server, Excel and Access

Troubleshooting Solution

Adding different values from a table to find a specific sum value

251
There are times when I need to find a certain value out of a number of records. For example, assume …
Article

Dynamic Pivot Procedure for SQL Server

15
by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …
Video
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 …

1
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
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. …
Article

A SQL Tidbit: Conditional Aggregates

17
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't
Article

Beware of Between

12
'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 …

9
I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting …
Troubleshooting Solution

Expand SQL statement to include the datatype with name of the field

46

I am looking to expand this query below so that each field returned has its datatype next to it,

Troubleshooting Solution

Dynamic changing of dblink in Oracle sql

byRads R
137
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

163
Hi all,

I have hundreds of identical tables - one for every hour:
        I_YEAR INTEGER NOT …
Troubleshooting Solution

Names of places in DK

158
My project is to create a service that helps users to find names of places in Denmark.

I use a …
Troubleshooting Solution

How to use Powershell data from SQL

byAckles
151
Hello,
This is in regards to question asked here:
Troubleshooting Solution

Dlookup problem

154
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

141
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

133
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

131
I am trying to determine the best way to go about creating the code necessary to allow a user form …
Troubleshooting Solution

Count total number of sql table columns not empty

byJ Sung
28

An SQL table has many ID's (pk int). I guess that's a ROW?

Each ID has a column named RISK and BOXes

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more