You're checking the first six characters are digits, so why not:

WHERE LEFT(RCD.Variable4, 4) BETWEEN '5011' AND '7999'

which can potentially make use of an index?

The two queries in your first post are functionally identical and show an indirect relationship between bill_info and accounts_transaction. Whilst the joins between the two tables are known, the cardinality...

dlam 18073 (11/21/2010)

---

thx ppls to give me help!

I did a test on two different sp (test with 3400 rows),

one is my sp, processing time 46 sec

another one from tommyh, processing...

ngreene (12/3/2010)

---

Always try to use LEFT JOIN (or RIGHT) instead of NOT IN or NOT EXIST. LEFT JOIN is going to have faster performance.

insert into tblClientList (clientNumber)

SELECT a.clientNumber

from tblOrder...

CirquedeSQLeil (11/26/2010)

---

da-zero (11/26/2010)

---

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build them...

An entity-attribute-value system?

Your original post asked how best to store a value which could be either an integer or a character value in one or more columns of a table....

michel.zdw (11/26/2010)

---

hi

i need to store a value that can be integer or string (depends on a key value)

is it better to use 2 columns or to use 1 column (varchar)...

Iulian -207023 (11/23/2010)

---

Hello,

I have a big table 50MB containing just 1000 records ( a few small fields each record).

On indexes I have one primary key and one clustered index, which...

stan-617410 (11/21/2010)

---

Lutz,

Thank you for your questions.

There are two tables - Tenant and Buildings.

The ID in Tenant = ID_U in Buildings.

If a tentant returns they will have...

<<We get the file full of INSERT UPDATE and DELETE>>

Is this a transit file? If not, what is it? Can you post a few lines?

In this particular case, the answer is straightforward:

Before

EXEC(@SQL)

Put PRINT @sql

and see what it returns 😉

Cheryl McLaughlin-385812 (11/23/2010)

---

Both to ChrisM and Drew. I appreciate the feedback.

To Drew:

However, the correct name is not pulling up. The original code modified using everyone's input:

SELECT glbank.check_num

, glbank.ref_num

, glbank.check_amt

, glbank.check_date

,...

Didn't this work?

Cheryl - try both options (conditional join or two left joins) and compare performance, preferably on a live or scaled-up test db. Usually the two (and only two, it usually...

@MonsterRocks - Sorry mate, got tied up, but Wayne jumped in with solution.

@Wayne - cheers mate, sorted.