Oh yeah... almost forgot. Each daily database has it's own summary table. All of the days for each month are collect my a view for each month. ...

I was wrong about the databases at work... although they return all of the information for a given customer a full year back in...

Sure... Barry is on the right track. Try that.

I guess I don't need to tell you that the column information stored in the NTEXT column should really be normalized...

It could be something as simple as a really lousy conference phone.

I gotta ask... why is the data stored this way? It's mostly "death by SQL" and now you want to compound the problem by converting it to the equivelent...

Think about it... the skinny table is an "EAV" (Entity, Attribute, Value)... a cross tab Select is all that is needed as the source of the update. Would be...

You're right... not enough sleep...

achaudhr (5/12/2008)

---

Let me know what else should I put here to make you understand better

One example of the query I am using on the view is:

select BibNumber from [vw_TypesOnlinePeriodicalsJoin]

where TiQueryValue...

Thanks for the feedback... 🙂

There are exceptions, especially amongst friends. But some of these folks' arrogance is just beyond me... like I said, it must just be a difference in language because some...

No indexes on TableB?

What does your query look like?

Deleting lacs of duplicates is going to take a long time if you have indexes and triggers and maybe even indexed views...

How big is the table including the duplicates (in...

First, create a Tally table... see the following URL for what it is and how it replaces some loops... take time to read it 'cause it's worth it 😉

http://www.sqlservercentral.com/articles/TSQL/62867/

Next,...

Thanks for the "plug", Matt! 🙂

The article Matt speaks of is at the following URL...

http://www.sqlservercentral.com/articles/T-SQL/63003/

Anirban Paul (5/21/2008)

---

I agree with Steve, not all cos are like that. My Co gave me a paid holiday trip (expenses taken care by Cos) for 4 days seeing my...