Stack Overflow
Stack Overflow

Questions tagged [lead]

Accesses data from a subsequent row in the same result set without the use of a self-join in SQL Server 2017. LEAD provides access to a row at a given physical offset that follows the current row. Use this analytic function in a SELECT statement to compare values in the current row with values in a following row.

For further reading https://learn.microsoft.com/en-us/sql/t-sql/functions/lead-transact-sql

309 questions
0
votes
1 answer

Find next row value using lead

I am trying to calculate a validtodate using the lead function. My data can change when a new file is uploaded. This file includes every location which is active in a…
Freek Hoeijmans
  • 1
  • 1
0
votes
1 answer

Save next row value as a new columns Snowflake

I have a table A like LDTS LENGTH 2022-03-03 15:41:05.685 50 2022-03-03 15:42:08.203 NULL 2022-06-08 21:57:07.909 45 2022-06-28 21:58:43.558 70 I want to display the changes in length side by side in two columns, rather than…
user18466310
  • 51
  • 7
0
votes
1 answer

Autodetect Lead Type in HTML

Our team plans to send out emails to clients. What type of code are we to insert in the HTML wherein it will detects what type of Salesforce lead type when they click the email link that is redirected to a landing page..
Aileen Siwa
  • 1
0
votes
0 answers

SQL- Using lead with group by to get closest value for a group

I would like to use the Lead function to get the closest value for a group Below is some sample data from flx_alps_boundaries Subject…
Suzan Allen
  • 1
  • 1
0
votes
2 answers

SQL - Get and update value from next record by Foreach on select result

I do not have much experience in SQL so my question is probably simple: On the result of a SELECT query, I need to UPDATE all records so that each record gets a value that is in the next record, as shown in the screenshot. I would love to have an…
Yashir
  • 3
  • 2
0
votes
1 answer

Impala compare consecutive rows and insert identical row if there are no values

I have a table that gives me data every month and I need that range of time. I noticed that sometimes I don't have data for 3/4 month but I need to duplicate the last row available with the missing…
wmbff
  • 45
  • 4
0
votes
1 answer

SQL Query to create date difference from current date

subscription_id purchase_date current_date plan_end_date date_diff 1111 01-04-2022 11-04-2022 14-04-2022 3 2222 02-04-2022 11-04-2022 09-04-2022 -2 3333 06-04-2022 11-04-2022 11-04-2022 0 I am looking for the above answer but not…
PiKs
  • 11
  • 3
0
votes
0 answers

R: How to keep lags and leeds from cutting the last years out of my data/graphs

I worked on the script with a fellow student, but I am quite inexperienced with R myself. I want to show the development of democratisation episodes from 1960 to 2021 in a bar chart, but the last three years (2018 to 2021) are never shown in the…
T. Faust
  • 1
0
votes
1 answer

Sum amounts based on account value

I want to sum AMT for account = 270400 and account like ‘51%’ only when AMT is positive on account = 270400. However, if there is an account = 513901, I want sum AMT for account = 270400 and account like ‘51%’ whether AMT is positive or negative on…
mikebeeman
  • 1
  • 1
0
votes
1 answer

SQL: LAG with variable parameter

I want to use the lag function and make it depend on a variable, but it gives me an error because it must be of type integer. I tried lag( pivote, pivote ) but I get the following error: AnalysisException: The offset parameter of LEAD/LAG must be a…
Angel Guadarrama
  • 3
  • 3
0
votes
1 answer

vTiger API Rest - create new lead

I downloaded the vTiger classes from here: https://blog.crm-now.de/2018/02/26/new-api-description-and-new-example-code-for-crm-rest-operations/?lang=en But when I try to create a new lead it gives me this in response: "create failed: lastname does…
enzo
  • 419
  • 3
  • 7
  • 16
0
votes
1 answer

LAG and LEAD based on parameter

I have table - Invoices, with such structure: Id InvoiceNo Date 1 10 11-12-21 2 20 12-12-21 3 30 13-12-21 4 40 NULL 5 50 14-12-21 6 60 NULL 7 70 NULL 8 80 15-12-21 What I need to do - I need to find InvoiceNo's, the date…
AtlasPromotion
  • 101
  • 6
0
votes
1 answer

Sqlite checking for cateory without loop

let's say that I have table like this: id ; cat ; val_2 ; val_3 1 ; 1 ; 40 ; 80 2 ; 1 ; 60 ; 90 3 ; 2 ; 10 ; 120 4 ; 2 ; 30 ; 100 5 ; 3 ; 20 ; 40 5 ; 3 ; 40 ; 70 5 ; 3 ; 50 ; 60 Now, I…
Splatt
  • 57
  • 5
0
votes
1 answer

Using DELETE FROM with LEAD function

Using SQL Server 2014, I have a table that keeps track of cash register sales. If the register operator scans an item in error, it will create two records - one SALE record, and one VOID record. TRX_ID LINE_ID STS …
Depth of Field
  • 307
  • 2
  • 16
0
votes
0 answers

How to read a dump file in python and then list its files?

I have two python files. One is memory file system and another is memory shell. I can access file system through python shell. However, there is another file, which is a dump file. I want to know how to read and display the contents of dump file in…
Tatakaye
  • 1
  • 1
1 2 3
…
20 21