Viewing 15 posts - 50,236 through 50,250 (of 59,078 total)
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. ...
May 27, 2008 at 10:33 pm
CrazyMan (5/27/2008)
yes jeff, its the Ph column
I was wrong about the databases at work... although they return all of the information for a given customer a full year back in...
May 27, 2008 at 10:27 pm
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...
May 27, 2008 at 9:30 pm
It could be something as simple as a really lousy conference phone.
May 27, 2008 at 9:21 pm
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...
May 27, 2008 at 9:18 pm
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...
May 27, 2008 at 9:14 pm
achaudhr (5/12/2008)
One example of the query I am using on the view is:
select BibNumber from [vw_TypesOnlinePeriodicalsJoin]
where TiQueryValue...
May 27, 2008 at 7:59 pm
Thanks for the feedback... 🙂
May 27, 2008 at 7:43 pm
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...
May 27, 2008 at 7:03 pm
No indexes on TableB?
What does your query look like?
May 27, 2008 at 6:46 pm
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...
May 27, 2008 at 6:44 pm
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,...
May 27, 2008 at 6:10 pm
Thanks for the "plug", Matt! 🙂
The article Matt speaks of is at the following URL...
May 27, 2008 at 5:45 pm
Anirban Paul (5/21/2008)
May 27, 2008 at 5:36 pm
Viewing 15 posts - 50,236 through 50,250 (of 59,078 total)