Great question. This is what QOD is all about.

The confusing part to me is you say records from one will not be in the other table. If that is so, you have no way to join the...

If I read this correctly (I probably didn't), it sounds like a union of the two.

timscronin (6/29/2010)

---

I have 2 tables with a one to many relationship. I have table 1 reorders with an rxno and table 2 hrxs which has many records related to...

It depends. You could be trading some performance for this approach. The query will not be able to take advantage of caching certain elements, such as query plan...

You are most welcome.

Thank you for the feedback.

aberndt (6/29/2010)

---

I am trying to write a Crystal report where I am pulling records from yesterday. The report will be run daily, hopefully automatically, so there is no need...

Eugene Elutin (6/29/2010)

---

rahulsony111 (6/29/2010)

---

Hi,

I have a table with columns proj_id char(5), tenant_id char(6), lease_id char(8), Sales_yr numeric(4)

i want to distinct only proj_id, tenant_Id, Lease_id but not sales_yr how can...

In what part of the world do you live?

Generally speaking, certification is sometimes, but in my observation, not that often a requirement. It never hurts though.

All that sounds normal to me.

You would need to generate the script from metadata. It's pretty easy though, depending on what you're trying to script.

Are you replicating 140,000 tables, or is that split among SPs, views etc?

You can stage it in several publications so that it is less of a strain to initialize. ...

Scott is correct, but I spotted a typo. It should be :

delete from SHIPPING_STG

from SHIPPING_STG ss

inner join (

select acct, item, max(sdate) as maxDate, min(sdate)...

Were the indexes removed or are you referring to "missing indexes" reflected in query plans or sys.dm_db_missing_index_details ?

I have never found schemas usefull or necessary. They always seemed like a solution in search of a problem to me. I also never like the term "schema"...