You do know that Microsoft changed the insert syntax as from SQLServer 2008
dont you?now you can insert multiple records in one go like this:
INSERT into Tablename (field1, field2, field3, field4 ) Values
( value1, value2, value3, value4 ... ;
value1, value2, value3, value4 ;
value1,
> Not knowing much about your overall process, I'll try to stick to some
> generic ideas. Let's assume you don't need this stuff dumped into the
> database the very second it gets sent to you.
This is actually part of a client's admin system on their website. They
send out legal newsletters.
Just to play devil's advocate for moment... This thread reminds me of the
old adage about what happens when you hire a carpenter for just any old
job, they tend to hit things with hammers. As web software developer, our
first instinct is to go out and write code.
Having been down this same avenue
I would probably use a trigger to do the second insert.
On Thu, Oct 9, 2014 at 5:38 PM, Les Mizzell wrote:
> I'll give this a try. It's got to be way less processor intensive than
> running multiple queries for each insert.
> Still, looks the stored procedure will be the "less load on the serve
On 10/9/2014 5:20 PM, William Seiter wrote:
> Off the top of my head...
>
> To insert the last inserted unique id in a transaction...
>
>
> INSERT dbo.table(column) SELECT 1;
> SELECT @newID = SCOPE_IDENTITY();
> INSERT dbo.table_2 (column) SELECT @newID;
>
>
I'll give this a try. It's got to b
Off the top of my head...
To insert the last inserted unique id in a transaction...
INSERT dbo.table(column) SELECT 1;
SELECT @newID = SCOPE_IDENTITY();
INSERT dbo.table_2 (column) SELECT @newID;
--
William Seiter
-Original Message-
From: Les Mizzell
On 10/9/2014 5:16 PM, William Seiter wrote:
> What kind of database? MSSql? Mysql? Oracle? ...
>
>
SQL Server 10
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=h
What kind of database? MSSql? Mysql? Oracle? ...
--
William Seiter
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: Thursday, October 09, 2014 1:29 PM
To: cf-talk
Subject: Re: Avoiding a boat load of queries inserting multiple
On 10/9/2014 5:00 PM, Cameron Childress wrote:
>
>
> A few years ago I stopped using numerics and auto-increment and started
> using UUID for all PK/FK columns.
On new stuff, this is what I'm doing as well. Unfortunitely, this is a
pre-existing app and would take a good bit of rewrite to do that
On Thu, Oct 9, 2014 at 4:29 PM, Les Mizzell wrote:
> If you did it this way, how would you get the ID from the first insert
> for use in the 2nd ...
No I don't think that's going to work the way you want it to in that case.
A few years ago I stopped using numerics and auto-increment and started
On 10/9/2014 1:49 PM, Cameron Childress wrote:
> Most databases will let you issue multiple SQL statements in a single
> request/transaction. You just have to separate them with a semicolon.
If you did it this way, how would you get the ID from the first insert
for use in the 2nd ... (because I'
> Have you investigated using a Stored Procedure that does both inserts?
This seems the way to go.
Writing Transact-SQL is outside my area of expertise.
I'm looking at example code now.
Give me a bit and maybe I'll figure it out...
Thanks to everybody that replied.
or just get all the email addresses from excel and send them over to a
tored procedure as a list to process in one go.
On Thu, Oct 9, 2014 at 7:22 PM, Dean Lawrence wrote:
>
> Les,
>
> I think that it would probably be more efficient if you imported all the
> records into a temp table and then
Les,
I think that it would probably be more efficient if you imported all the
records into a temp table and then did an insert into the main email table
based upon a join query that only includes records from the temp table that
are not in the main email table. You could then do a similar insert
that would only apply if you are using professional edition, or each VM
exceeds their number of cpu cores/speed on enterprise license.
if you have enterprise and your 2 vm's are within the license restrictions,
then the person at Adobe who told you that obviously doesn;t understand
their own lice
That¹s not what Adobe is telling us. They want a license per virtual
machine, not per host.
On 10/2/14, 3:22 PM, "Russ Michaels" wrote:
>
>as they are virtual, if you have enterprise license then you are covered
>as
>long as you are within the CPU/core requirements.
>
>On Thu, Oct 2, 2014 at 8
Have you investigated using a Stored Procedure that does both inserts?
--
William Seiter
-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net]
Sent: Thursday, October 09, 2014 9:31 AM
To: cf-talk
Subject: Avoiding a boat load of queries in
On Thu, Oct 9, 2014 at 12:30 PM, Les Mizzell wrote:
> Is there a better way to set up my two insert queries above so it's not
> making two calls for every single address?
Most databases will let you issue multiple SQL statements in a single
request/transaction. You just have to separate them with
I've got an application that imports email list from Excel sheets.
Mostly working fine, but I've got one spot where I'd like to optimize
things if I could.
Once the data is imported I run two queries against each email address:
1. see if the email address is already in the group in question
2.
I came to the same conclusion. Thanks.
On Wed, Oct 8, 2014 at 9:46 PM, Al Musella, DPM
wrote:
>
> It doesn't make sense to do it from cf scheduler because if CF is
> locked up it won't execute. The windows scheduler always will!
>
>
> At 07:21 PM 10/1/2014, Russ Michaels wrote:
>
> >Just use
20 matches
Mail list logo