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 T…
Tag: dynamic
Can we fire a database query in config/constants.php file to make constants dynamic? (Php Codeignitor)
I have tried to place this at the bottom of the config/config.php but it is throwing this error: An uncaught Exception was encountered Type: Error Message: Class ‘CI_Controller’ not found Filename: E:xampp74htdocsjrvssystemcoreCodeIgniter.php Line Number: 369 Please suggest me some solution for th…
Syntax Error when trying to use Dynamic Pivot Query
I’ve been playing around with the PIVOT function for a while. I have a table that looks like this Every ClientID is repeated once for each month. Every month new rows are added to the table with a new period associated to the row. It’s an incrementing table. What I need to do is to PIVOT the table…
SQL procedure group by parameter value
I want to use group by functionality with dynamic value. Ex: When I code like this I get the error == > Each GROUP BY expression must contain at least one column that is not an outer reference. Any workaround for this? Answer You need to be very careful with this type of code as it is prone to SQL
Pass Column Names into SQL statement in dynamic way – Python- SQL Server
Example of ‘fields’ value = name, surname, date I can put ‘fields’ in a list but I do not know how many (?) to put inside the query. Because, fields variable will include sometimes 5, sometimes 10 column names. I am trying to pass column names dynamically to the query. How can I solve …
Dynamic Pivot Table by Month
I’m trying to create a dynamic pivot table in SQL that will report based on month and year. I did a bunch of research and was able to come up with the below query: I am able to print the @column variable successfully, but the problems happen when I try to set it in the @dynamic variable. The error messa…
Transform Columns to Rows dynamically using T-SQL
I have the following table where I need to transform Columns to Rows tbl_Survey: I need to have the following result: To have this result I used the following code: But, my Quest_1, Quest_2, Quest_3 values could potentially be changed / or even added a new once… Are there ways to code them, so it can be…
pyscopg2: Is it possible to dynamically add %s in loop
I am trying to create a method in python insert records into a table passing in a list of column names, and an associated list of records. I was able to set it up where the column names populated dynamically via a for loop, but I can’t figure out how to do the same thing with values because the psycopg2…
How to pass table name and column name dynamic in SQL
I was trying to pass table name and column name dynamic, this is as part of SSIS process I am trying this stored procedure below. On executing this, I am NOT getting count as result, instead I am getting execution success. I need to get the count as output. Also my simple direct query is like this Answer I th…
Dynamically name a column based on a WHERE condition
Objective: I am running a query on a weekly basis and would like one of my column to return the ISO_WEEK number with the prefix ‘W’. For example: W1. More specifically, I would like to reproduce the …