SQL Solutions

Troubleshooting Solution

SQL error

byJohnMac328

2024-04-183

I have been asked to help out with a SQL query that is throwing errors. First off I don't see why

…

Troubleshooting Solution

How to combine LIKE and IN in SQL?

byLia Nungaray

2024-04-095

I have a query that selects codes using 140 LIKE statements:

SELECT * FROM myTable

WHERE

myCode LIKE

…

Troubleshooting Solution

SQL and Python-beginner guidance

byexcel learner

2024-04-072

Dear Experts,

I want to learn SQL and Python.

I need help guidance on:

1. For SQL kindly suggest a book

…

Troubleshooting Solution

Help finding specific duplicates in SQL

bySteve Jennings

2024-04-047

I have a list of IP subnet to site mappings that's around 10k lines. Each Subnet-Site pair is

…

Troubleshooting Solution

Using MSXML2.ServerXMLHTTP with SQL Server status, statusText and responseHeader are all null

byPeter Dobbs

2024-03-281

Dearest Obi Wan,

We've been using MSXML2.ServerXMLHTTP for a long time with SQL Server.

Recently it

…

Research Solution

migrateSQL 2019/2022 on pre and oracle 12c/19c/20c to Azure SQL

bymarrowyung

2024-03-252

Hi,

Right now we have a plan to migration SQL 2019/2022 on pre to Azure SQL, please suggest the

…

Troubleshooting Solution

I want a sql to give me difference between 2 dates

byVishal Jaiswal

2024-03-133

I have a table and that contains 2 dates column like Live_date and De_install_date. Suppose I have a

…

Troubleshooting Solution

After Insert and Update Trigger on the same table in MySQL

byMolnár István

2024-03-021

I have the following table in MySQL:

and I would like to create 2x triggers: one after insert and one

…

Troubleshooting Solution

How to use SPLIT_TO_TABLE in Snowflake?

byLia Nungaray

2024-02-283

I have the following code in Oracle which I need to convert to Snowflake:

WITH

PARMS AS (

SELECT

…

Troubleshooting Solution

SQL Loader not able to identify the line terminator

bySwaminathan K

2024-02-203

Hi Team,

Need help on the control file to handle the data for columns spanning multiple lines .

Iam

…

Troubleshooting Solution

SQL Query returning null values

byjko n127

2024-02-151

I written the below query to get an output from a view and a table, but I am getting null values

…

Troubleshooting Solution

SQL query (Joins) Syntax

byTJ Cooperman

2024-02-144

So I am writing a sql query,( don't knock my script writing I am a novice) and I cannot get this

…

Troubleshooting Solution

FireDAC fails when applying filter to a FDMemTable causing its adapter's DatSTableName to change.

byCory Pierson

2024-02-076

Apologies, previously posted 6 month ago on StackOverflow with no answer so I'm posting here.

…

Troubleshooting Solution

Write a "Unique" Query in Access?

byRex

2024-02-073

Hello:

Very new to SQL

I'm trying to write a query in Access that pulls only Unique values from a

…

Troubleshooting Solution

Need a little help recording an event in this SSIS package

bydbaSQL

2024-01-243

I am creating a SSIS package to generate a pipe delimited csv file from the output of a stored

…

Troubleshooting Solution

How to transpose rows to columns in snowflake

byLia Nungaray

2024-01-243

Hello Experts,

Is there a way to transpose from rows to columns in snowflake? Possibly using the

…

Troubleshooting Solution

Using SQL SUM to consolidate UNION results

byarmgon

2024-01-172

I have the following SQL

(SELECT T4.ItmsGrpNam, SUM (T1.LineTotal)*-1 as 'Total Purchase',

SUM

…

Troubleshooting Solution

Combining two SQL selects statements using UNION

byarmgon

2024-01-174

Could really use some expertHelp Combining these two SQL selects statements using UNION with the

…

Troubleshooting Solution

SQL script to change number column to string by way of computed temporary column.

byBabak Sekandari

2024-01-173

I'm trying to create a script that will change a column from a number (where each value represents

…

Troubleshooting Solution

Best way to create a customized ID value for table insert.

bydbaSQL

2024-01-123

SQL Server 2019. I have a table that is only written to by a single stored procedure.

I need to

…

Explore SQL on Experts Exchange

SQL

SQL error

How to combine LIKE and IN in SQL?

SQL and Python-beginner guidance

Help finding specific duplicates in SQL

Using MSXML2.ServerXMLHTTP with SQL Server status, statusText and responseHeader are all null

migrateSQL 2019/2022 on pre and oracle 12c/19c/20c to Azure SQL

I want a sql to give me difference between 2 dates

After Insert and Update Trigger on the same table in MySQL

How to use SPLIT_TO_TABLE in Snowflake?

SQL Loader not able to identify the line terminator

SQL Query returning null values

SQL query (Joins) Syntax

FireDAC fails when applying filter to a FDMemTable causing its adapter's DatSTableName to change.

Write a "Unique" Query in Access?

Need a little help recording an event in this SSIS package

How to transpose rows to columns in snowflake

Using SQL SUM to consolidate UNION results

Combining two SQL selects statements using UNION

SQL script to change number column to string by way of computed temporary column.

Best way to create a customized ID value for table insert.

Do more with Experts Exchange.

Explore solutions and more

SQLBack to the top