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

I want a sql to give me difference between 2 dates

3

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

1

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?

3

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

3

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

1

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

4

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.

6

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
3

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
3

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

3

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
2

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
4

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.

3

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
3

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

I need to

Troubleshooting Solution

KQL AppInsights - Get Max Count of Percentages

byZack
3

Hi EE,


For the App Insights KQL Query: The query captures how many days in the future a particular

Troubleshooting Solution

bcp out with query to csv file generate more lines

bybibi92
1

Hello,


I try to export with query big sql server tables on csv file with bcp out but it generated

Advice Solution

MS Access date as the name of a field in table

byTaras
2

 I need to create a table that has three fields:

1 EmployeCode

2. EmplyeDept

3. Date1

For some reason

Troubleshooting Solution

Customized SQL query that removes part of string and counts string occurrence.

2

Greetings,

I have a SQL table that looks like this:

DATE                EVENT

1900-11-29   1

1902-04-05 

Advice Solution

SQL Server - Modified Records Table with 80 Columns will grow rapidly.

6

Hello, All.

ASP Classic (Web Farm) | SQL Server 2019 (AOAG)

Modified_time is the table name.
Every

Research Solution

rebuild index on PROD batches by batches.

1

hi,


We are now going to rebuild index for a very important PROD and we'd like to:


  1. Plan for a

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more