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

"Originating Lead" field is empty after lead is qualified

The problem is that when I try to qualify a lead in Microsoft Dynamics CRM 2013 Online the "Originating Lead" field for newly created Opportunity is left empty. This is strange because all the mappings are there and it should be transfered. Does…
Yura Mysak
  • 3
  • 4
0
votes
2 answers

do we have unsubscribe mail feature in openerp?

Do we have unsubscribe mail feature in openerp and if yes how to set it. I want to know when user receives mail from openerp can does it have that feature anywhere? How does mass mail works exactly in case of leads and opportunities? Any video…
Pooja
  • 575
  • 10
  • 28
0
votes
1 answer

Salesforce Apex - Existing Contact used to create new lead

I would like to create after update APEX for salesforce that can take a contact and recreate it as a Lead when a field on the contact is checked true. Any help would be appreciated. Yeah so I think i need to make a list of the contacts that need to…
Rich
  • 35
  • 1
  • 5
  • 12
0
votes
1 answer

Postgres : lag and lead with special conditions

Forgive what may be a silly question, but I'm not much of a database guru. Here is my table : id_data | val_no3 | id_prev | id_next --------+---------+---------+---------- 1 | | | 2 2 | 7 | | 3 | …
Leasye
  • 261
  • 1
  • 8
  • 19
0
votes
1 answer

Software developement and team lead

can you suggest some good reading for software development lead, I searched around and found some but they are rather old , do you have any good suggestion like an hands-on / reference book? I have found…
tbo
  • 9,398
  • 8
  • 40
  • 51
0
votes
2 answers

Updating Old Data in CRM

I made a field named "Lead Type" in Lead Form.I also created a new field named "Account Type" in Account form. I create a new mapping between these two fields ie. when the value of "Lead Type" field is filled in the lead form and when we qualify…
Arsh
  • 115
  • 12
0
votes
1 answer

How to add multiple leads to particular campaign in crm 2011

i tried to add multiple leads to campaign using marketing list and it works fine. But i need to add directly from lead s Homepage by selecting multiple leads, is it possible. Thanks in advance.
Vishnu
  • 1,029
  • 4
  • 14
  • 24
0
votes
1 answer

Need to copy customize fields from crm.lead to customer or partner

I have inherited an object from crm.lead and added some fields into it. its working fine but what I want that when I clicked on Create button to change lead to partner , those fields must be automatically copied from lead to customer. Remember I…
noamanfaisal
  • 91
  • 2
  • 11
-1
votes
1 answer

Snowflake partitioning

I have records like below: login_id login_type login_name login_timestamp page_id 1 event null 2023-01-13 00:22:02.560 1 1 event null 2023-01-13 00:22:02.634 1 1 page login 2023-01-13 00:22:02.882 1 1 event login 2023-01-13…
VarYaz
  • 119
  • 2
  • 12
-1
votes
3 answers

How to use lead() efficiently and return next different value?

I have a table that records user transactions like this (simplified version) in BigQuery user transaction_date label cost a 2021-10-31 10:30:00 y1 10 b 2021-10-31 10:30:00 y2 10 c 2021-10-31 10:30:00 y1 10 a 2021-11-31…
henrycmcjo
  • 93
  • 5
-1
votes
1 answer

SQL Match Offsetting Events

Trying to match some events in SQL. A user will place a work order into a wait status. This has a datetime stamp. Once resolved, they will release the wait. This has a datetime stamp. I can use Lead Window Function if B comes after A, but they are…
Winston Snyder
  • 67
  • 2
  • 7
-1
votes
1 answer

counting consecutive dates R

How to check in a column whether dates are one off from each other
Jane Miller
  • 153
  • 9
-1
votes
1 answer

mysql not having LEAD and LAG Functions

I'm not able to execute LEAD and LAG Functionality in MYSQL. Do I need to install anything in MySQL Workbench to work it properly?
sairamdgr8
  • 47
  • 1
  • 10
-1
votes
1 answer

Output of two tables in SQL

I'm learning SQL and I came across the below-mentioned scenario. Table 1 id Name City 1 Ryan Chennai 2 Tom Banglore 3 Sam Pune 4 Kat Mumbai Table 2 id month salary 1 prev 1000 1 cur 4000 1 next 3000 2 prev 1000 2 cur 3000 2 …
Ezio_s
  • 9
  • 2
-1
votes
1 answer

How to get next row value based on previous row excluding week ends in SQL Server?

I have a table as follows: (Expected result without weekend exclude logic) Start Date End Date(Expected Date) No of…
meena narayanasamy
  • 1
  • 1
1 2 3
…
20
21