What is the relationship (link) between your two tables?

Gianluca Sartori (10/3/2011)

---

Please note that the "hour"...

select convert(varchar,getdate(), 120) + ' ' + CASE WHEN DATEPART(hour,GETDATE()) > 12 THEN 'PM' ELSE 'AM' END

this may help

SELECT MP.pname AS Phone_Name,

MP.pnumber ...

Jeff Moden (10/2/2011)

---

I.... Since I haven't actually used the HierarchyID datatype (and, therefore, haven't used any of it methods up 'till now), I built myself a nice "little" million...

Not really clear on your question....???

can you please provide script that will create and insert data that represents the problem you have..(see link in my sig if not clear)

long time since I migrated Access to SQL...so not really sure what SSMA actually does in the "conversion"

for data types : http://msdn.microsoft.com/en-us/library/ms187752.aspx

This may help

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26709

Ninja's_RGR'us (9/27/2011)

---

Of course the SELECT will be tones faster.

HOWEVER. Keep in mind that for any insert, update, delete in ANY of the tables of the indexed view, you will...

Jeff Moden (9/25/2011)

---

J Livingston SQL (9/25/2011)

---

Heh... no fair. I asked you for your results first. 😛

I've not run your code yet. I was waiting to see if you...

Jeff....code below.

if not clear, pls post back

use tempdb

GO

--===== Conditionally drop the tables

IF Object_id('vw_PreAg', 'V') IS NOT NULL

...

Do you have the code that built the 20M*30*100 data for both tables so we can test at the level you did?

Did you do a comparison of the original code...

First off....I agree with Jeff's test results having run on both 2005 std and 2008R2 dev.

personally, I really dont like hardcoding pivot columns, and more often than not, will be...

good article here

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

just wondering if this post has any relevance to this one by same OP...???

http://www.sqlservercentral.com/Forums/FindPost1176651.aspx