It's much harder than it looks. I'm not trying to delete anything, I just need to get the email address the met my criteria. Look at my loop,...

I'm looking for just the email in the result. Sorry, here's the create + insert statements.

CREATE TABLE dbo.dup_emails (

username varchar(100),

email varchar(100),

product_id int,

product_status bit)

-- a) only one active

INSERT dbo.dup_emails

VALUES ('mike123',...

DECLARE @currentEmail varchar(100), @currentUser varchar(50),

@totalUser int, @totalActive int, @count int, @error int

SET @currentEmail = ''

SET @currentUser = ''

SET @totalUser = 0

SET @totalActive = 0

SET @count = 0

SET @error = 0

BEGIN...

oh also, the output from the "generate HTML table" sproc includes a header that looks messy when I copy and paste the result into outlook as html. (a wrapped long...

I haven't tried "NO LOCK" yet, I let the query run on last night before I leave and it ran successful albeit taking 3 hours to complete.

During daytime, it always...

Thanks!

I created the format file, and also I used the "bcp format file automatic generation script" found here on SQLServerCentral.com, however, I got error from both:

SQLState = S1000, NativeError =...

OK, my brain has been temporarily revived with some sleep last night

So, I created another connection object to the reporting server, (log in...

This process is going to run on a production server that is being replicated, and the DBA doesn't like to have extra tables created that don't need replication. So,...

Excellent! I went with the if statements + sprocs and performance is good.

Thanks all!

hmm.. I can't edit the topic / subject?  Wanted to change it to "Forcing Clustered index seek?"... Oh well, actually, I bet I can search in sqlservercentral & find something about...

haha... and I thought it was something w/ SQL Server & variables in WHERE clauses...  well, it is, sort of.

Both tbl_a and tbl_b are quite big, and when I just...

Good question.

Our DBA was recently laid off, so it could have been a permission problem. (the DBA group boss has taken over the duties and locked down some permissions I...

quote:

---

One note. Whenever you do an EXISTS or NOT EXISTS change your subquery to "SELECT 1" instead of referencing cells. ...

quote:

---

DTSTaskExecResult is related to scripting.

For SQL code use RAISERROR with RETURN to force a failure message to the message pump.

---

i thought so too... but is there any recommended "freebies" to use? Actually, do most of you use Query Analyzer or some external editor? My company is still...