I want a sql to give me difference between 2 dates
I have a table and that contains 2 dates column like Live_date and De_install_date. Suppose I have a
…I have a table and that contains 2 dates column like Live_date and De_install_date. Suppose I have a
…I have the following table in MySQL:
and I would like to create 2x triggers: one after insert and one
…I have the following code in Oracle which I need to convert to Snowflake:
WITH
PARMS AS (
SELECT
…
Hi Team,
Need help on the control file to handle the data for columns spanning multiple lines .
Iam
…I written the below query to get an output from a view and a table, but I am getting null values
…So I am writing a sql query,( don't knock my script writing I am a novice) and I cannot get this
…Apologies, previously posted 6 month ago on StackOverflow with no answer so I'm posting here.
…Hello:
Very new to SQL
I'm trying to write a query in Access that pulls only Unique values from a
…I am creating a SSIS package to generate a pipe delimited csv file from the output of a stored
…Hello Experts,
Is there a way to transpose from rows to columns in snowflake? Possibly using the
…I have the following SQL
(SELECT T4.ItmsGrpNam, SUM (T1.LineTotal)*-1 as 'Total Purchase',
SUM
…Could really use some expertHelp Combining these two SQL selects statements using UNION with the
…I'm trying to create a script that will change a column from a number (where each value represents
…SQL Server 2019. I have a table that is only written to by a single stored procedure.
I need to
…Hi EE,
For the App Insights KQL Query: The query captures how many days in the future a particular
…Hello,
I try to export with query big sql server tables on csv file with bcp out but it generated
…I need to create a table that has three fields:
1 EmployeCode
2. EmplyeDept
3. Date1
For some reason
…Greetings,
I have a SQL table that looks like this:
DATE EVENT
1900-11-29 1
1902-04-05
…Hello, All.
ASP Classic (Web Farm) | SQL Server 2019 (AOAG)
Modified_time is the table name.
Every
hi,
We are now going to rebuild index for a very important PROD and we'd like to:
Plan for a