it looks like you have 12 fields you want to grab from 3 columns, is that right? so this is really ONE record with 12 fields?

importing from excel , by...

i think it might have to do with the table variable;

 SELECT userid, fname, lname, toemail FROM users, @clientstable CT WHERE users.userid = CT.userid

i would look at the execution plan, but...

minor, maybe do to a copy/paste/edit, but i think one variable is not declared, and another is never initailized:

CREATE PROCEDURE [dbo].[proc_broadcastemailsget]

AS

DECLARE @clientstable TABLE (userid INT PRIMARY...

i guess what i was suggesting is that when you are looping thru the datagrid, I would have put the userid's that had checkboxes checked in their associated data row,...

there's several ways...I would suggest a group by:

SELECT ENO, Fname, Lname, MIN(Dept) as Dept, MIN(Start) as Start, MIN(End) as [End], MIN(Chngdate) as Chngdate FROM sometable

group by ENO, Fname, Lname

since you said DTS, I'm guessing you are using 2000, right.

there's two issues I know of:

the ole driver can have a default limit of 255 chars; see this thread on...

here's my suggestions, and they might be calling  for a design change:

create a table something like what is below; i  would probably suggest putting their actual emails AND the newsletter...

man i don't seem to read everything early in the morning:

here is how to INSERT the new items from the staging table:

INSERT INTO PriceDumpData(Company,Departure,Country,Destination,DepartureDate,ReturnDate,UpdateDate,DepTime,RetTime,Hotel,Link,Roomtype,Classification,Duration,Price,Currency,Link2)

SELECT

PriceDumpStage.Company,

PriceDumpStage.Departure,

PriceDumpStage.Country,

PriceDumpStage.Destination,

PriceDumpStage.DepartureDate,

PriceDumpStage.ReturnDate,

PriceDumpStage.UpdateDate,

PriceDumpStage.DepTime,

PriceDumpStage.RetTime,

PriceDumpStage.Hotel,

PriceDumpStage.Link,

PriceDumpStage.Roomtype,

PriceDumpStage.Classification,

PriceDumpStage.Duration,

PriceDumpStage.Price,

PriceDumpStage.Currency,

PriceDumpStage.Link2

FROM

PriceDumpData

FULL OUTER JOIN...

here is the same logic, but with the actual columns you identified: assuming you import  the text file into the staging table PriceDumpStage , this will work:

SELECT

PriceDumpData.*,

PriceDumpStage.*

FROM

PriceDumpData

FULL OUTER...

it's not hard at all, as long as there is something that uniquely identifies each product. My example below only uses two columns, you would need to use all Company,Departure,Country,Destination,DepartureDate,Hotel,Roomtype,Duration

you...

you could also enhance the web application by adding another call to an audit stored proc...so what i'm saying is for every call in the web app that is doing...

also the date add function accepts negative numbers, so if you need something like "15 days back from today":

SELECT DATEADD(day, -14, getdate()) AS TwoWeeksAgo

results:

TwoWeeksAgo                                           

------------------------------------------------------

2007-02-06 17:03:39.997

(1 row(s) affected)

can you modify the code and the stored procedures to pass/use a new parameter?  If you can't modify the web service, you'll really be hampered in auditing.

I'm assuming the web...

you can send the query to SQL with the following options:

SET NOEXEC ON

SET PARSEONLY ON

SELECT * FROM SOMETABLE

SET NOEXEC  OFF

SET PARSEONLY OFF

you could then simply return the errors returned from...

what is the source of the file...i had an issue before where the source was UNIX based text files, so the terminator is not \n, but another...\r (just Cr) ?...