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
1
vote
3 answers

SQL Server Compressing Adjacent Date Ranges

I have a table that holds a person id and a date range (a start date and a stop date). Each person may have multiple rows with multiple start and stop dates. create table #DateRanges (    tableID int not null,    personID int not null,   …
Brian Stork
  • 945
  • 2
  • 8
  • 14
1
vote
3 answers

Fill in the gaps between values in table - MySQL

I have a table (MySQL) UserID | CreationTS | Type | Value | Bonus Value 259275 | 2012-08-01 | Deposit | -------- | NULL 259275 | 2012-08-02 | BonusApplied | 175 | 175 259275 | 2012-08-03 | TradeOrder | -------- |…
Michael
  • 97
  • 4
1
vote
1 answer

SQL Server(T-sql) Update table from botom to top

im trying to update table temp(F4) result from bottom to top. Is it while-loop every row and update can be order by? Thanks!
user2286756
  • 211
  • 1
  • 2
  • 11
1
vote
1 answer

facebook developers - Ads Management - Lead Ads - Reading Leads - Bulk Read

i'm trying to retrieve data in real time using the leadgen event i'm using the Facebook ads SDK for php i succeeded in seting up an endpoint to ingest the realtime ping here is my error_log file ( [entry] => Array ( [0] => Array …
Ayoub MESBAHI
  • 19
  • 3
1
vote
1 answer

Facebook Ad Leads retrieval asp.net

Is there a way I can read Ad leads data from Lead_ID in asp.net? I see there are examples of PHP but there is no SDK for C#.Unforunately I have to use Asp.net and cannot use any other technologies Any suggestions are highly appreciated
Srinivas
  • 21
  • 5
1
vote
4 answers

R lag/lead irregular time series data

I have irregular time series data frame with time (seconds) and value columns. I want to add another column, value_2 where values are lead by delay seconds. So value_2 at time t equals to value at time t + delay or right after that. ts=data.frame( …
ak.
  • 3,329
  • 3
  • 38
  • 50
1
vote
0 answers

leadmachine rest api with curl in php

Find, Add and update the data using lead machine API with Curl and php. And you need to use your own ApiKey and MachineId.you can also use the jQuery and XML for this task you need to use your own api key and MachineId/ function…
anil jangra
  • 9
  • 4
1
vote
0 answers

What expect from Twitter leads submit_url?

I'm exposing a web service to receive leads from twitter /cards/lead_gen, the main problem it's I don't know what to expect (submit_url -> "HTTPS endpoint that will accept the leads"). I read the documentation but I couldn't find anything.
fperetti
  • 11
  • 2
1
vote
0 answers

Correlated subquery returning value - 1

I have a calendar table which allows me to count business days. The most basic query I run goes like this: SELECT SUM(calD.busDay) [Sum Of Days] FROM [dbo].[CalendarDays] calD WHERE calD.calDay BETWEEN '1/1/2016' AND '1/3/2016' Since New Year's…
n8.
  • 1,732
  • 3
  • 16
  • 38
1
vote
0 answers

How to get a specific preceding event Postgres

All I have the following types of rows of data in my DB User 1 takes software update 1 User 1 performs some action on product User 1 performs some action on product User 1 performs some action on product User 1 takes software update 2 User 1…
simon110883
  • 11
  • 1
1
vote
1 answer

detect sequence in hive column with lead function

I'm trying to detect a sequence in a column of my hive table. I have 3 columns (id, label, index). Each id has a sequence of labels and index is the ordering of the labels, like id label index a x 1 a y 2 a x 3 a y 4 b x 1 b …
boxl
  • 11
  • 1
1
vote
1 answer

Use my own form before submitting data to Marketo

I am using ASP.NET and would like to use my own form, but still send the data into a Marketo form to create a new lead. I have got the field names and values that I would like to submit formatted in JSON as shown in the Marketo documentation for…
Mutton92
  • 91
  • 10
1
vote
1 answer

PHP: Is there any SOAP service available in Salesforce to Convert Leads into opportunity and Account?

I have to convert Leads to accounts and opportunity via SOAP calls. I am able to create, update(Edit) and Detail Lead fields but not able to convert them. I am using PHP Scripting.
Qazi
  • 5,015
  • 8
  • 42
  • 62
1
vote
1 answer

ORACLE SQL Query records where timeinterval with previous record is less then eg 1 minute

From input table query all records where time-difference is less or equal then 1 minute. Required Output >>>>>sqlfiddle <<<<<
user1875323
  • 137
  • 1
  • 2
  • 9
1
vote
2 answers

Set date to last day of previous month in Oracle if it's not the last row

Whole setup on SQL Fiddle: http://sqlfiddle.com/#!4/1fd0e/5 I have some data containing persons id, level and the levels date range like shown below: PID LVL START_DATE END_DATE 1 1 01.01.14 19.03.14 1 2…
Jakob
  • 778
  • 3
  • 9
  • 25
1 2 3
…
20 21