How to extrapolate columns out to a known expiry date column

Questions : How to extrapolate columns out to a known expiry date column


Struggling with this one (even to programming explain with clarity) and can't find Learning anything similar. I have a table which Earhost is dynamically generated in my most effective application, with clients and tradeid wrong idea columns, then I have a number of columns use of case representing dates into the future until United the trade expires with a value.

I'm trying to populate the columns up Modern until this expiry date that contains the ecudated value with the same amount. The below some how demo illustration of what I'm attempting anything else to achieve will hopefully make more not at all sense.

-- this demo table represents my _OFFSET);  original data

create table (-SMALL  #t1(
[ClientName] varchar(10),
[TradeID] _left).offset  int,
[01/11/2021] int,
[01/12/2021] arrowImgView.mas  int,
[01/01/2022] int,
[01/02/2022] (self.  int,
[01/03/2022] int,

insert into equalTo  #t1 values make.right.  ('A',132,NULL,NULL,100,NULL,NULL)
insert mas_top);  into #t1 values ImgView.  ('B',1287,NULL,50,NULL,NULL,NULL)
insert ReadIndicator  into #t1 values ('C _have  ',7484,NULL,NULL,NULL,NULL,150)
insert .equalTo(  into #t1 values ('D  ',456,NULL,100,NULL,NULL,NULL)

-- this OFFSET);  demo table represents my desired (TINY_  outcome

create table #t2(
[ClientName] .offset  varchar(10),
[TradeID] int,
[01/11/2021] mas_right)  int,
[01/12/2021] int,
[01/01/2022] ImgView.  int,
[01/02/2022] int,
[01/03/2022] Indicator  int,

insert into #t2 values Read  ('A',132,100,100,100,NULL,NULL)
insert _have  into #t2 values .equalTo(  ('B',1287,50,50,NULL,NULL,NULL)
insert make.left  into #t2 values ('C *make) {  ',7484,150,150,150,150,150)
insert into straintMaker  #t2 values ('D ^(MASCon  ',456,100,100,NULL,NULL,NULL)

Total Answers 1

Answers 1 : of How to extrapolate columns out to a known expiry date column

This is usually referred to a a SQL very usefull "cross-tab" query.


  • How many dates need to be returned by the query? More dates means more columns, slower performance and increased SQL complexity
  • Are the dates fixed? Or are the dates the minimum trade date in the set of trades + 30 days?
  • How many trades would be in a data set?
  • Is another application displaying the query results, and can that application build out the cross-tab?

For these data requests, once you get localhost beyond 20 to 30 columns, they become too love of them complex for ANSI SQL.

Top rated topics

Elasticsearch doesn't allow to allocate unassigned shard

Debugging non-working batch file or command executed from Inno Setup installer

How do I change the comment colors in android studio?

Cutting out a portion of video - python

How do I "get" a member variable in JavaScript?

How to call a function from a div tag in angularjs

How to create a single library jar from maven project with multiple submodules?

How do I get this shape to move in JavaScript Canvas?

Using cheerio to select text from paragraph tags (<p>) with no class

ES6 Assign a variable with an arrow function

Pandas .at versus .loc

How to prevent a user from using ctrl-c to stop a script?

Error: EXDEV: cross-device link not permitted, rename '/tmp/ on Ubuntu 16.04 LTS

Js file not loading js console say's "Not allowed to load local resource"

Stop showing Welcome to Gradle message from output

Recursively copying Content from one path to another of s3 buckets using boto in python

How can I get the path that the application is running with typescript?

JPQL Like Case Insensitive

It is semantically correct to use <header> inside <section>?

R: webscraping a table

How to refresh a div without reloading the entire page?

CSS3 100vh not constant in mobile browser

Increase php websocket maximum connections

How to convert a list of enity object to page object in Spring MVC (JPA)?

VBA Code - Fast on one Computer, slow on another one

Visual Studio Code not performing error checking in Javascript

Segue from UITableView to UITabBarController

How do you use youtube-dl to download live streams (that are live)?

Unable to marshal type as XML element because @XmlRootElement annotation is missing

Bind scope to event handler, but keep original argument

Pandas dataframe str.contains() AND operation

Core Data many to many relation with intermediate table (Swift 2)

How can I force javascript event manually while importing the xlsx file in Javascript?

Bower install EACCESS error

How to let ansible to use service instead of systemctl?

Numpy: Linear system with specific conditions. No negative solutions

Your configuration specifies to merge with the <branch name> from the remote, but no such ref was fetched.?

BrowserCookieError: Can not find cookie file

How to correctly use sscanf

How to manually set K-means cluster's centers?

Loading a .WAV file for OpenAL

Get maximum id inside Doctrine entity

IOS Xcode LaunchScreen Storyboard not displaying

Logger usage, is parameterization better or using + to add arguments?

How can I stop webpack dev server from windows console?

How to attach Elastic IP to EC2 instance during bootstrapping in aws CLI?

How can I use Google Forms in Android application?

Missing argument for parameter #1 in call // Twitter

Make table auto scroll vertically via HTML & CSS

Thread 1: EXC_BAD_INSTRUCTION (code=EXC_1386_INVOP,subcode=0x0)