I have to automate a process that assigns sales leads to sales people.
For example:
Every day we buy a list of sales leads, it ranges in size from 50 -
100 records.
We have a team of sales people that also can range from 5 - 8 people.
I need to take the new records and divide them evenly among the sales
people.
If i get 50 records, and have 5 sales people, then each sales person
gets 10 leads.
--
So, im guessing that I may need to have a nested loop inside this. I
have tried it several different ways, but cant seem to get it quite
right.
DECLARE @TotalRecordCount int, @TotalSalesPeopleCount int,
@AmountForEach int, @LooperSalesPeoplerecords int,
@LooperNewSalesLeadsRecords int, @SalesPersonID int
SELECT @TotalSalesPeopleCount = COUNT(UserId)
FROM SalesPeople
WHERE Active = 1
--
SELECT @TotalRecordCount = COUNT(*)
FROM NewSalesLeads
--
SELECT @AmountForEach = (@TotalRecordCount/@TotalSalesPeopleCount)
--
SELECT @LooperSalesPeoplerecords = 1
SELECT @LooperNewSalesLeadsRecords = 1
--
WHILE @LooperSalesPeoplerecords <= @TotalSalesPeopleCount
BEGIN
WHILE @LooperNewSalesLeadsRecords <= @TotalRecordCount
BEGIN
SELECT @SalesPersonID = (SELECT UserID
FROM SalesPeople
WHERE UniqueId = @LooperSalesPeoplerecords)
SELECT @LooperSalesPeoplerecords =
(@LooperSalesPeoplerecords + 1)
UPDATE SalesLeads
SET SalesPerson_ID = @SalesPersonID
WHERE UNIQUEID = @LooperSalesPeoplerecords
SELECT @LooperSalesPeoplerecords =
(@LooperSalesPeoplerecords + 1)
END
END
----
Table structures
CREATE TABLE [dbo].[SalesPeople] (
[SalesPerson_ID] [int] NOT NULL ,
[FirstName] [varchar](20)NOT NULL
) ON [PRIMARY]
--
INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (26, 'Bill')
INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (28, 'Bob')
INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (37,
'Chris')
------------------------------------------------
CREATE TABLE [dbo].[SalesLeads] (
[SalesLeadID] [int]NOT NULL ,
[SalesPerson_ID] [int]NOT NULL
) ON [PRIMARY]
--
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1001,0)
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1002,0)
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1003,0)
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1004,0)
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1005,0)
INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1006,0)
------------------------------------------------
So in this case, all 3 salespeople should receive 2 salesleads each.
I dummied this down quite a bit. It actually ends up being more like
15 sales people, and about 400,000 sales leads. But it should work on
any level.
Thanks for any help you might shed on this. 6 3904
Hi
Something like this may help. It assumes the sales IDs are sequential, and
does not worry if there are a an exact division.
UPDATE L
SET SalesPerson_ID = M.SalesPerson_ID
FROM SalesLeads L JOIN
( SELECT P.[FirstName], P.[SalesPerson_ID] ,
( SELECT COUNT(*) FROM [dbo].[SalesPeople] S WHERE S.[SalesPerson_ID] <
P.[SalesPerson_ID] ) AS Rank
FROM [dbo].[SalesPeople] P ) M
ON L.SalesLeadID % ( SELECT COUNT(*) FROM [dbo].[SalesPeople] ) = M.Rank
John
"Dave" <fu*****@yahoo.com> wrote in message
news:f5**************************@posting.google.c om... I have to automate a process that assigns sales leads to sales people.
For example: Every day we buy a list of sales leads, it ranges in size from 50 - 100 records. We have a team of sales people that also can range from 5 - 8 people.
I need to take the new records and divide them evenly among the sales people.
If i get 50 records, and have 5 sales people, then each sales person gets 10 leads. -- So, im guessing that I may need to have a nested loop inside this. I have tried it several different ways, but cant seem to get it quite right.
DECLARE @TotalRecordCount int, @TotalSalesPeopleCount int, @AmountForEach int, @LooperSalesPeoplerecords int, @LooperNewSalesLeadsRecords int, @SalesPersonID int
SELECT @TotalSalesPeopleCount = COUNT(UserId) FROM SalesPeople WHERE Active = 1 -- SELECT @TotalRecordCount = COUNT(*) FROM NewSalesLeads -- SELECT @AmountForEach = (@TotalRecordCount/@TotalSalesPeopleCount) -- SELECT @LooperSalesPeoplerecords = 1 SELECT @LooperNewSalesLeadsRecords = 1 -- WHILE @LooperSalesPeoplerecords <= @TotalSalesPeopleCount BEGIN WHILE @LooperNewSalesLeadsRecords <= @TotalRecordCount BEGIN SELECT @SalesPersonID = (SELECT UserID FROM SalesPeople WHERE UniqueId = @LooperSalesPeoplerecords)
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1)
UPDATE SalesLeads SET SalesPerson_ID = @SalesPersonID WHERE UNIQUEID = @LooperSalesPeoplerecords
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1) END END
---- Table structures
CREATE TABLE [dbo].[SalesPeople] ( [SalesPerson_ID] [int] NOT NULL , [FirstName] [varchar](20)NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (26, 'Bill') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (28, 'Bob') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (37, 'Chris') ------------------------------------------------ CREATE TABLE [dbo].[SalesLeads] ( [SalesLeadID] [int]NOT NULL , [SalesPerson_ID] [int]NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1001,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1002,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1003,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1004,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1005,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1006,0) ------------------------------------------------
So in this case, all 3 salespeople should receive 2 salesleads each.
I dummied this down quite a bit. It actually ends up being more like 15 sales people, and about 400,000 sales leads. But it should work on any level.
Thanks for any help you might shed on this.
John,
Yeah, we arent that concerned about having an exactly even
distribution so uneven divisors are not a problem.
And, unfortunately the sales people arent in sequential order. WE have
hundreds of sales people that are assigned to various campaigns at any
given time. So this particular campaign may change on a daily basis.
Meaning that the salespersonid is always non sequential for this
campaign.
Thanks anyway.
"John Bell" <jb************@hotmail.com> wrote in message news:<_m*********************@news-text.cableinet.net>... Hi
Something like this may help. It assumes the sales IDs are sequential, and does not worry if there are a an exact division.
UPDATE L SET SalesPerson_ID = M.SalesPerson_ID FROM SalesLeads L JOIN ( SELECT P.[FirstName], P.[SalesPerson_ID] , ( SELECT COUNT(*) FROM [dbo].[SalesPeople] S WHERE S.[SalesPerson_ID] < P.[SalesPerson_ID] ) AS Rank FROM [dbo].[SalesPeople] P ) M ON L.SalesLeadID % ( SELECT COUNT(*) FROM [dbo].[SalesPeople] ) = M.Rank
John
"Dave" <fu*****@yahoo.com> wrote in message news:f5**************************@posting.google.c om... I have to automate a process that assigns sales leads to sales people.
For example: Every day we buy a list of sales leads, it ranges in size from 50 - 100 records. We have a team of sales people that also can range from 5 - 8 people.
I need to take the new records and divide them evenly among the sales people.
If i get 50 records, and have 5 sales people, then each sales person gets 10 leads. -- So, im guessing that I may need to have a nested loop inside this. I have tried it several different ways, but cant seem to get it quite right.
DECLARE @TotalRecordCount int, @TotalSalesPeopleCount int, @AmountForEach int, @LooperSalesPeoplerecords int, @LooperNewSalesLeadsRecords int, @SalesPersonID int
SELECT @TotalSalesPeopleCount = COUNT(UserId) FROM SalesPeople WHERE Active = 1 -- SELECT @TotalRecordCount = COUNT(*) FROM NewSalesLeads -- SELECT @AmountForEach = (@TotalRecordCount/@TotalSalesPeopleCount) -- SELECT @LooperSalesPeoplerecords = 1 SELECT @LooperNewSalesLeadsRecords = 1 -- WHILE @LooperSalesPeoplerecords <= @TotalSalesPeopleCount BEGIN WHILE @LooperNewSalesLeadsRecords <= @TotalRecordCount BEGIN SELECT @SalesPersonID = (SELECT UserID FROM SalesPeople WHERE UniqueId = @LooperSalesPeoplerecords)
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1)
UPDATE SalesLeads SET SalesPerson_ID = @SalesPersonID WHERE UNIQUEID = @LooperSalesPeoplerecords
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1) END END
---- Table structures
CREATE TABLE [dbo].[SalesPeople] ( [SalesPerson_ID] [int] NOT NULL , [FirstName] [varchar](20)NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (26, 'Bill') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (28, 'Bob') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (37, 'Chris') ------------------------------------------------ CREATE TABLE [dbo].[SalesLeads] ( [SalesLeadID] [int]NOT NULL , [SalesPerson_ID] [int]NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1001,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1002,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1003,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1004,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1005,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1006,0) ------------------------------------------------
So in this case, all 3 salespeople should receive 2 salesleads each.
I dummied this down quite a bit. It actually ends up being more like 15 sales people, and about 400,000 sales leads. But it should work on any level.
Thanks for any help you might shed on this.
Hi
The solution does not rely on salesperson id being sequential as it ranks
them separately. If the salesleads id are reasonably sequential then you
should be ok.
John
"Dave" <fu*****@yahoo.com> wrote in message
news:f5**************************@posting.google.c om... John,
Yeah, we arent that concerned about having an exactly even distribution so uneven divisors are not a problem.
And, unfortunately the sales people arent in sequential order. WE have hundreds of sales people that are assigned to various campaigns at any given time. So this particular campaign may change on a daily basis. Meaning that the salespersonid is always non sequential for this campaign.
Thanks anyway.
"John Bell" <jb************@hotmail.com> wrote in message
news:<_m*********************@news-text.cableinet.net>... Hi
Something like this may help. It assumes the sales IDs are sequential,
and does not worry if there are a an exact division.
UPDATE L SET SalesPerson_ID = M.SalesPerson_ID FROM SalesLeads L JOIN ( SELECT P.[FirstName], P.[SalesPerson_ID] , ( SELECT COUNT(*) FROM [dbo].[SalesPeople] S WHERE S.[SalesPerson_ID] < P.[SalesPerson_ID] ) AS Rank FROM [dbo].[SalesPeople] P ) M ON L.SalesLeadID % ( SELECT COUNT(*) FROM [dbo].[SalesPeople] ) = M.Rank
John
"Dave" <fu*****@yahoo.com> wrote in message news:f5**************************@posting.google.c om... I have to automate a process that assigns sales leads to sales people.
For example: Every day we buy a list of sales leads, it ranges in size from 50 - 100 records. We have a team of sales people that also can range from 5 - 8 people.
I need to take the new records and divide them evenly among the sales people.
If i get 50 records, and have 5 sales people, then each sales person gets 10 leads. -- So, im guessing that I may need to have a nested loop inside this. I have tried it several different ways, but cant seem to get it quite right.
DECLARE @TotalRecordCount int, @TotalSalesPeopleCount int, @AmountForEach int, @LooperSalesPeoplerecords int, @LooperNewSalesLeadsRecords int, @SalesPersonID int
SELECT @TotalSalesPeopleCount = COUNT(UserId) FROM SalesPeople WHERE Active = 1 -- SELECT @TotalRecordCount = COUNT(*) FROM NewSalesLeads -- SELECT @AmountForEach = (@TotalRecordCount/@TotalSalesPeopleCount) -- SELECT @LooperSalesPeoplerecords = 1 SELECT @LooperNewSalesLeadsRecords = 1 -- WHILE @LooperSalesPeoplerecords <= @TotalSalesPeopleCount BEGIN WHILE @LooperNewSalesLeadsRecords <= @TotalRecordCount BEGIN SELECT @SalesPersonID = (SELECT UserID FROM SalesPeople WHERE UniqueId = @LooperSalesPeoplerecords)
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1)
UPDATE SalesLeads SET SalesPerson_ID = @SalesPersonID WHERE UNIQUEID = @LooperSalesPeoplerecords
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1) END END
---- Table structures
CREATE TABLE [dbo].[SalesPeople] ( [SalesPerson_ID] [int] NOT NULL , [FirstName] [varchar](20)NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (26, 'Bill') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (28, 'Bob') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (37, 'Chris') ------------------------------------------------ CREATE TABLE [dbo].[SalesLeads] ( [SalesLeadID] [int]NOT NULL , [SalesPerson_ID] [int]NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1001,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1002,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1003,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1004,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1005,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1006,0) ------------------------------------------------
So in this case, all 3 salespeople should receive 2 salesleads each.
I dummied this down quite a bit. It actually ends up being more like 15 sales people, and about 400,000 sales leads. But it should work on any level.
Thanks for any help you might shed on this.
I think meant to have something like this, with the keys shown and
some extra columns addded:
CREATE TABLE SalesPeople
(salesperson_id INTEGER NOT NULL PRIMARY KEY,
firstname VARCHAR(20)NOT NULL,
seq_nbr INTEGER NOT NULL,
.. );
Run this guy when then table is changed.
UPDATE SalesPeople
SET seq_nbr
= (SELECT COUNT(*)
FROM SalesPeople AS P1
WHERE P1.saleperson_id <= SalesPeople.salesperson_id)
Now a table for the leads as leads and not what you had:
CREATE TABLE SalesLeads
(saleslead_id INTEGER NOT NULL PRIMARY KEY,
grp_nbr INTEGER,
..);
First group the leads based on the number of sales people:
UPDATE SalesLeads
SET grp_nbr
= (SELECT COUNT(*)
FROM SalesLeads AS L1
WHERE L1.saleslead_id <= SalesLeads.saleslead_id)
% (SELECT COUNT(*) FROM SalesPeople);
Now look at a VIEW to get each sales person the group of leads they
are to work.
CREATE VIEW LeadAssignments (saleslead_id, salesperson_id)
AS SELECT L1.saleslead_id, P1.salesperson_id
FROM Salesleads AS L1, SalesPeople AS P1
WHERE L1.grp_nbr = P1.seq_nbr;
I think I understand what you are saying here. However, This thing has
to be comletely automated and just do the update everynight.
I do appreciate the suggestions.
I have to think that this is used fairly often, and cant be this
difficult to find some folks that have written something similar.
Thanks,
Dave jc*******@earthlink.net (--CELKO--) wrote in message news:<18**************************@posting.google. com>... I think meant to have something like this, with the keys shown and some extra columns addded:
CREATE TABLE SalesPeople (salesperson_id INTEGER NOT NULL PRIMARY KEY, firstname VARCHAR(20)NOT NULL, seq_nbr INTEGER NOT NULL, .. );
Run this guy when then table is changed.
UPDATE SalesPeople SET seq_nbr = (SELECT COUNT(*) FROM SalesPeople AS P1 WHERE P1.saleperson_id <= SalesPeople.salesperson_id)
Now a table for the leads as leads and not what you had:
CREATE TABLE SalesLeads (saleslead_id INTEGER NOT NULL PRIMARY KEY, grp_nbr INTEGER, ..);
First group the leads based on the number of sales people:
UPDATE SalesLeads SET grp_nbr = (SELECT COUNT(*) FROM SalesLeads AS L1 WHERE L1.saleslead_id <= SalesLeads.saleslead_id) % (SELECT COUNT(*) FROM SalesPeople);
Now look at a VIEW to get each sales person the group of leads they are to work.
CREATE VIEW LeadAssignments (saleslead_id, salesperson_id) AS SELECT L1.saleslead_id, P1.salesperson_id FROM Salesleads AS L1, SalesPeople AS P1 WHERE L1.grp_nbr = P1.seq_nbr;
How about something like this:
----------------------------------------------------------------------
Create Table #Leads
(
LeadID Int Identity Not Null,
SalesID Int,
UniqueId Int -- Bad name
)
Create Table #SalesPeople
(
SalesID Int Identity (0, 1) Not Null,
UserID Char(30) -- type?
)
DECLARE @SalesPeopleCount int
-- Put sales people in the temp table.
Insert Into #SalesPeople (UserID)
Select UserID From SalesPeople Where Active = 1
-- How many were there?
Set @SalesPeopleCount = @@RowCount
-- Put leads in the temp table.
Insert Into #Leads (UniqueId)
Select UniqueId From NewSalesLeads
-- Match sales people to leads
Update #Leads Set SalesID = LeadID % @SalesPeopleCount
-- Save the matches.
UPDATE SalesLeads
SET SalesPerson_ID = UserID
From
SalesLeads
Join #Leads On SalesLeads.UniqueId = #Leads.UniqueId
Join #SalesPeople On #Leads.SalesID = #SalesPeople.SalesID
----------------------------------------------------------------------
Temporary IDs will always be sequential. The only problem with
this is that lower sales IDs will consistently get more leads.
You could fix that by adding something variable to LeadID before
performing the mod.
If you're going to use ID columns, you need to treat them as keys.
Joe Celko was using something like this as a bad example a few
weeks ago, trying to convince me that ID columns are a bad idea.
Used halfway like this, I would agree.
Bill
Dave wrote: I have to automate a process that assigns sales leads to sales people.
For example: Every day we buy a list of sales leads, it ranges in size from 50 - 100 records. We have a team of sales people that also can range from 5 - 8 people.
I need to take the new records and divide them evenly among the sales people.
If i get 50 records, and have 5 sales people, then each sales person gets 10 leads. -- So, im guessing that I may need to have a nested loop inside this. I have tried it several different ways, but cant seem to get it quite right.
DECLARE @TotalRecordCount int, @TotalSalesPeopleCount int, @AmountForEach int, @LooperSalesPeoplerecords int, @LooperNewSalesLeadsRecords int, @SalesPersonID int
SELECT @TotalSalesPeopleCount = COUNT(UserId) FROM SalesPeople WHERE Active = 1 -- SELECT @TotalRecordCount = COUNT(*) FROM NewSalesLeads -- SELECT @AmountForEach = (@TotalRecordCount/@TotalSalesPeopleCount) -- SELECT @LooperSalesPeoplerecords = 1 SELECT @LooperNewSalesLeadsRecords = 1 -- WHILE @LooperSalesPeoplerecords <= @TotalSalesPeopleCount BEGIN WHILE @LooperNewSalesLeadsRecords <= @TotalRecordCount BEGIN SELECT @SalesPersonID = (SELECT UserID FROM SalesPeople WHERE UniqueId = @LooperSalesPeoplerecords)
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1)
UPDATE SalesLeads SET SalesPerson_ID = @SalesPersonID WHERE UNIQUEID = @LooperSalesPeoplerecords
SELECT @LooperSalesPeoplerecords = (@LooperSalesPeoplerecords + 1) END END
---- Table structures
CREATE TABLE [dbo].[SalesPeople] ( [SalesPerson_ID] [int] NOT NULL , [FirstName] [varchar](20)NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (26, 'Bill') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (28, 'Bob') INSERT INTO SalesPeople (SalesPerson_ID,FirstName) VALUES (37, 'Chris') ------------------------------------------------ CREATE TABLE [dbo].[SalesLeads] ( [SalesLeadID] [int]NOT NULL , [SalesPerson_ID] [int]NOT NULL ) ON [PRIMARY] -- INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1001,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1002,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1003,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1004,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1005,0) INSERT INTO SalesLeads (SalesLeadID,SalesPerson_ID) VALUES (1006,0) ------------------------------------------------
So in this case, all 3 salespeople should receive 2 salesleads each.
I dummied this down quite a bit. It actually ends up being more like 15 sales people, and about 400,000 sales leads. But it should work on any level.
Thanks for any help you might shed on this. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Christian Gollwitzer |
last post by:
Hi,
I'm trying to loop over the elements in a hashmap of the
STL-implementation by SGI. The point is, that because the key/value pair
is stored as std::pair in the COntainer, the code becomes...
|
by: Beau |
last post by:
Hi all, thanks in advance.
Ok, heres the story.
What is happening......
--------------------------------
I've got an ASP page that loops.
It loops in order to get data in different,...
|
by: Cappy |
last post by:
I am writing an XML menu structure.
I have the following XML file
<MenuItems>
<Item>
<Name>Homepa5ge</Name>
<URL>/index.aspx</URL>
<Alt>Return to homepage</Alt>...
|
by: Stimp |
last post by:
This is a question I'm carrying over from a previous one I made today
since I've simplified where the problem is...
I have a datatable, tblFeatures, which has around 30 columns (one for
each...
|
by: Dacuna |
last post by:
Is it possible to use a recursive function to loop through a recordset faster?
I have a table that I need to edit its contents after doing some calculation. The table has one field has an RawData...
| |
by: randy1200 |
last post by:
My hope is that somebody has a thought on this, or can point to toward an
article that's useful. I have the following:
DataSet ds = new DataSet();
ds.ReadXml("MyData.xml");
Each MainTable...
|
by: Dave128 |
last post by:
Let me first start off by saying I am a beginner at Java. I need help on an assignment to produce a loop which I believe for this particular assignment would be the for loop. The output needs to look...
|
by: boker |
last post by:
i try to do nested looping like this
for (i=0;i<=640;i++)
{
for(j=0;j<=640;j++)
{
if(getpixel(j,i)!=0) {
printf("this a color pixel);
}
}
|
by: NetworkElf |
last post by:
Hi all,
Does anyone have some code that shows an example of how to loop through a
range of IP addresses? I'm using text boxes to get a start and end value for
the range. I was thinking about...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |