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 Question

Writing complex SQL queries.

16

I have queries that take forever to execute(or just times out).


Is there a good resource for how to

Advice Question

sql live projects

2

sql live projects

Troubleshooting Question

Get the pointer of a CLOB/BLOB

3

Hi Experts,      


In a DB record is a CLOB defined.

When I run an SQL I see *POINTER (I understand

Troubleshooting Question

SQL Query - Return item value based on newest date

byLee
4

I am working on a query that a challenge for me. A customer can have muplite price sheets assgiend

Troubleshooting Question

Simple SQL Query left join Question- I think

8

I'm terrible at SQL queries.... I'm having trouble figuring out the SQL query on this.


3 Tables

Case

Troubleshooting Question

SQL Query for time

3

I need to write and SQL query that looks at a string and converts that string to hours of the day.

Troubleshooting Question

Pulling distinct records while using an Unpivot statement in Oracle SQL.

10

I've been asked to only pull the distinct values from an existing query.

Here is the query:

When I run

Troubleshooting Question

Expand SQL statement to include data about authorized users

11

This statement is intended to show information about each table schema that is connected to an

Troubleshooting Question

Need to create a report or SCCM CMPivot query with SCCM/MECM to find out what Windows Servers have the IIS role installed

byMark
7

Hi, 


Can you please assist, I've been asked to run a report on SCCM/MECM to find out what Windows

Troubleshooting Question

Count first or last occurrence

6

I want to count how many new employees there are in the months.

No dates are available in the data,

Advice Question

Run update query in Teradata to get data types showing

4

Hi. I am working with a Teradata query hoping that using a temp table. Am help me save a few steps:


I

Research Question

lower down the Oracle tablespace size

3

hi,


usually when we can see from monitoring tools like ManageEngine applications manager, the

Troubleshooting Question

Nested IF/CASE statement in SQL

8

Can someone help me with the following CASE statement so it will calculate correctly?  The first

Troubleshooting Question

Pull multiple rows into columns via SQL

3

I would like to join to a table and pull back as many rows of phone numbers that are available and

Troubleshooting Question

Writing a Flux query for Signal_wait percentage

9

I am trying to convert this SQL Server query to Flux

SQL Server query:


Current Query



Query Error


Troubleshooting Question

Can I reuse a SUSDB in remote SQL with a newer version of WSUS than originally used?

2

Can I connect a new WSUS/SUP frontend to a remote SUSBD in SQL that was previously associated with

Troubleshooting Question

Looking for top 10 and bottom 10 by group (and across 23 fields) in Microsoft Access

1

Looking to list top 10 and bottom 10 for 12 groups.  I have a table that has portfolios, peer groups

Troubleshooting Question

DoublePressed event to store and pass variable to new window

byZac123

Hi, hoping there's someone here with some XoJo experience. I'm a noobie to it and i'm just finding

Research Question

SQL Nexus and sqldiag

2

hi,


I am trying to learn how to run the sqldiag,exe together with SQL Nexus, and I tried to run the

Troubleshooting Question

Need help with SQL Server query question.

4

Hello,


Need help with SQL Server query question.


I have an employee table with following fields.



Sample

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more