Skip to content

Tag: zoho

SQL dynamic output tables

right now I have 2 tables. The first one has all the sales done by sales persons throughout each week, this table updates every week and only displays the sales of the current week (erases the data and starts over next week), the second table is a record of all sales done ever. SALES FOR THIS WEEK OCTOBER(9 TO 15)(updates

FULL OUTER JOIN (or UNION) on 2 tables

I’m facing a SQL request issue. I’m not a SQL expert and I would like to understand my mistakes. My use case is to get all records of the first table + records of the second table that are not present in the first table. I’ve got 2 tables like this : First table “T-Finance par jalon ZOHO” (with 20

Pivoting a table of survey data in SQL without PIVOT

I have a table called Responses which contains survey responses using the following structure. This is data for two different survey responses. Each survey has 4 questions (QuestionIDs) but the last one (long text) is optional, so some responses only have 3 rows of data. The first question (QuestionID “1”) could also serve as a primary key for a survey