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
Máté Farkas
SQL Server Consultant

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

Troubleshooting Solution

Export from SQL to EXCEL with long string

bymcrmg
60
hi,

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


I need to have an Excel with same number of …
Article

SQL Server Database Health Checks

byRaja Jegan R
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.
Video
Query data with no SQL code (7) 4m

Query data with no SQL code (7)

byMáté Farkas
1
Section 07: Create a subquery

Course: This course is created for business people or…
Video
Query data with no SQL code (8) 3m

Query data with no SQL code (8)

byMáté Farkas
1
Section 08: Include a subquery into another query

Course: This course is created …
Video
Query data with no SQL code (9) 6m

Query data with no SQL code (9)

byMáté Farkas
1
Section 09: Join subquery to existing tables in a query

Course: This course is …
Post

This is a cool tool to help visualize explain plans in …

byDoug Walton
This is a cool tool to help visualize explain plans in postgres: https://explain.depesz.com/
Post

Sequential or Random Rows in Microsoft Access  Study my …

byGustav Brock
1
Sequential or Random Rows in Microsoft Access
Study my new articles on this topic…
Article

Dynamic Pivot Procedure for SQL Server

byMark Wills
15
by Mark Wills

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

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

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

Need help migrating from Access to SQL Server

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

Estimate Execution time of DBCC CHECKDB

byRaja Jegan R
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 to see which columns got changed from previous entry.

bybfuchs
44
Hi Experts,

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

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

bypcalabria
22
I need to upsize from Access to SQL as my App has become too complex for Access..
so I'm trying to …
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

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

Need to surpress meesages when  IGNORE_DUP_KEY = ON

bypcalabria
24
I thought I had a solution to this yesterday but it turns out that indexing with  IGNORE_DUP_KEY = ON …
Troubleshooting Solution

Need help using SQL average

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

Export from SQL to EXCEL

bymcrmg
20
hi,

I am trying to see if I could export data from SQL directly to EXCEL. This is the code I use


I am …
Research Solution

query slow with different parameter input

bymarrowyung
48
hi,

we have a query sometime slow sometime fast ( finish 2 x sec)



any idea on why is it? I can't …
Troubleshooting Solution

Get a list of ScheduleID's from a text file containing SQL statements.

bybfuchs
36
Hi Experts,

I've a text log file containing many SQL statements (inserts, updates and deletes) as …
Troubleshooting Solution

Table is invisible in SQL server and in Access database

byurjudo
29
Hello Experts,
I'm try to create a table names USysRibbons in either the actual Access database and …

Do more with Experts Exchange.


Get Answers

Take a Class

Collaborate

Monitor your Site

Explore solutions and more