this is a further question along the same lines..

due to time phasing of upgrades, there will be a time gap in migrating all servers to SS2008 (on Windows Server 2008).

So,...

ok..Gail, really, thanks..

but, the restriction that all xml output should go to a single file is really not that important because even if I create many files, I could write...

in SSMS, I have the results going to a text file.

I bracket my query with the set showplan_xml on, and off

When I hit the F5, it asks me to...

yes, Sir... I smile with you...And thank you for giving us your general quantification. Your categories go to the crux of the problem. I, and I'm sure, the rest...

I have now tried the UNION that unionizes each row values and references a single table in the INSERT as suggested by one of you. This was a little improvement....

I have some new information on this issue.

I went ahead and purchased Itzik Ben-Gan new book on T-SQL Querying (this is not a plug for his book but it...

thank you very much gentlemen...very good information

Ken/Sharma,  Thank you very much for your help.

And Sharma, your explanation on how to interpret the information was great!!!.

Phenomenal was your insight that too many rows are qualified by...

Jagan,

Nothing conclusive can be said from the information you've provided. However, I think the issue may be that you're out of CPU. Do this to isolate. Check in task...

We all know why views are great. In fact, I built a reporting system based on views upon views. The chains got four or five levels deep.

I knew it...

I think your query is wrong. I think what you want is this:

SELECT     SiteHits.BotName,

COUNT(SiteHits.BotName) AS N,

COUNT(MGD_SiteHits.BotName) AS TTL

FROM         SiteHits CROSS JOIN

                      MGD_SiteHits MGD_SiteHits

GROUP BY SiteHits.BotName

 

And I get the correct result...

I added the closing parenthesis to the CAST function....

I made it work by casting the text column to varchar.

I presume that you are dealing with url that are no longer than...

I made it work by casting the text column to varchar.

I presume that you are dealing with url that are no longer than 8000 bytes and so casting the text to...

The request is to aggregate based on the country column, and each row in the Order table will be counted as one.  We can do this readily using the GROUP...

Dennis,

try this:

IF EXISTS (SELECT TABLE_NAME

    FROM   INFORMATION_SCHEMA.VIEWS

    WHERE  TABLE_NAME = N'Spain_Orders')

    DROP VIEW Spain_Orders

GO

CREATE VIEW Spain_Orders

AS

 SELECT

 [Order ID],

 [Customer],

 [Employee],

 [Order Date],

 [Required Date],

 [Shipped Date],

 [Ship Via],

 [Freight],

 [Ship Name],

 [Ship Address],

 [Ship City],

 [Ship Region],

 [Ship...