You may want to try this, and you may also want to be sure that you have an index on each of the table on the column email.

insert into Total(

...

Also, I think bitbucket resides somewhere on the east coast of the USA, not in the UK.

Everyone is looking at the values, yes, they are "different", but both...

Okay, how do you do that one? I'd like to add it to my "toolbox" right along with lmgtfy.

I actually answered true, and here is why, if you run this:

select getdate(), getutcdate()

you may get a result like this:

2009-11-17 06:16:57.527 2009-11-17 13:16:57.527

They appear different, but are actually the same....

Looks to me like you did a good job of explaiining group access. Let's see what the OP says...

You could also do this:

select left(convert(varchar, getdate(), 108),5)

Never mind this. Again, brain dead for a bit, misread the original query.

Why do you think that is rediculous? It just means that the data has many redundant bit patterns that allow it to be highly compressed.

Because there aren't any system "tables". You will find those under system views now. Starting with SQL Server 2005 you can no longer update system tables directly.

GilaMonster (11/16/2009)

---

I find that condescending and insulting. I've used it once only, after someone repeatedly demonstrated that they were not going to search themselves,...

CirquedeSQLeil (11/16/2009)

---

Lynn Pettis (11/16/2009)

---

Digs posted a project spec here on ssc that he posted on GetAFreelancer.com, so for S & G's (plus I am trying to earn some extra cash...

Without seeing the code not much we can do to help. It is possible that you are experiencing parameter sniffing.

Please read the first two articles I reference in my...

Not sure what you are talking about at this point. Please show what you mean by three codes. If you mean you have 2 codes and you need...

mamet_bundar (11/15/2009)

---

Hi, I'm a newbie on SQL programming

I want to asking about how to display data which have different code in same table

CODE NUMBER QTY

C10 1111911101 10

C10 112789930K 20

M10 1111911101...

No, variables are not affected by transactions. This is also true of table variables.