Andras gave you an example; we thought you could extrapolate.

note the assumption that with the data, there is always space and then the two digit state code.

here is a...

that would be normal....if i started an insert or update that was tweaking a million rows, and then tried to cancell it, it certainly might take a while to rollback...

i think you are missing a reference; try adding

Imports System.Collections

to the top of your class. IEnumeration is a member of System.Collections.

Tara (6/10/2009)

---

I am just confused with this 2 processess.

Does sql server roll back the transaction when i cancel an insert query from the query window, does it act as the...

the issue is the way exclusive locks work.

a lock prevents the SELECT,UPDATE/INSERT/DELETE of the table.

it does not prevent the selecting of the current ident value, or reviewing of any other...

why are you selecting @CurrentId from an identity value manually? INSERT into the table and get the Scope_Identity() its the right way to do it. it looks like you are...

andy.gear (6/10/2009)

---

So I have two tables that have two fields that are the same. How do I find pairs in one table that are not in another table? ...

this might help a little bit:

the Us Census Bureau put together the most common male first names, female first names, and most common last names:

http://www.census.gov/genealogy/names/names_files.html

90% of the names in...

you won't have any problem with the SELECT @variable, 'Any constant',col1,col2 from SomeTable Format; it's very common to need to do that.

usually, i create two roles in this situation.

one, just as you describe, that gives a user db_datareader and db_datawriter for example.

then i create a second role, and it';s sole purpose...

also SQL Recon from Special Ops Security[/url] is free and does a great job as well as doing some quickie analysis like blank passwords and a best guess at which...

maybe something is missing in your code snippet, but you declare a variables like @activityID and @UpdateLogin, never assign them a value, but then use then to insert into...

i understand why you are breaking everything into step by step...it's easy to understand logically.

however, perfomance wise, you can do everything together in one swoop...get the emails, remove duplicates, and...

also, i notice you are inserting into two tables : "MasterList" and "maintable";

i would think you would be inserting into just one temp table, right? and the exists should bee...

bit of a logic hole there.

a GO statement cannot exist in a stored procedure. when you run that statement it creates a stored proc that only does one thing...deletes from...