Explore Query on Experts Exchange

Expert Solutions for Your Tech Problems

QueryQuery Syntax

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
  • 57K Content
  • 7.6K Contributors

Expert Spotlight
SQL Server Consultant

Database Expert with 15+ years experience (SQL, Access, Power BI).

Troubleshooting Solution

Problem with Trigger insert

I am trying to get this trigger to insert the correct data. I seem to be losing the scope_identity …

Dynamic Pivot Procedure for SQL Server

by Mark Wills

PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type …

SQL Server Database Health Checks

An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.

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/

Sequential or Random Rows in Microsoft Access  Study my …

Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Troubleshooting Solution

Export from SQL to EXCEL with long string


This is the code I use to export SQL output to Excel

I need to have an Excel with same number of …
Troubleshooting Solution

SQL Server Query for detecting, eliminating outliers from data set.

I am having trouble making a SQL Server query for eliminating outliers in a data set (using median …
Troubleshooting Solution

Need help creating SQL for MS Access Query

I need help improving the performance of a query in MS Access which takes about two minutes to run.…
Troubleshooting Solution

Need help migrating from Access to SQL Server

I have a number of date fields in my Access database.  In some cases I store just the date, in other …
Estimate Execution time of DBCC CHECKDB

Estimate Execution time of DBCC CHECKDB

A clarification of some common doubts about DBCC CHECKDB for Database Administrators. Includes estimated times to repair database corruption's in production databases.
Troubleshooting Solution

Need help converting a MS Access query to MS SQL - Definitely need an expert for this one.

I need to upsize from Access to SQL as my App has become too complex for Access..
so I'm trying to …
Troubleshooting Solution

Need to see which columns got changed from previous entry.

Hi Experts,

I have a table with following columns
ScheduleID long
CaregiverID int
PatientID int
VisitDate …
Troubleshooting Solution

Need to surpress meesages when  IGNORE_DUP_KEY = ON

I thought I had a solution to this yesterday but it turns out that indexing with  IGNORE_DUP_KEY = ON

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
Troubleshooting Solution

I have a sql function which I would like to see if I can produce the same results in an oracle query without using a function

I have this function in sql where it can determine the format of a string and would like to be able …
Troubleshooting Solution

Need help using SQL average

When using AVG, I am getting incorrect average results. According to the raw data, I supposed to …
Troubleshooting Solution

MS Access SQL Question :How do I group certain records by certain rules and generate a reference for that group in SQL.

The data table: Bookings (example data):
PO WH No Door Booking Date From Booking Date To Booking Time

Do more with Experts Exchange.

Get Answers

Take a Class


Monitor your Site

Explore solutions and more