See the CrossTab link in my signature and change your query accordingly.

Then read the DynamicCrossTab article (also refernced in my signature) to make it dynamic.

Give it a try and see...

That's one of the reasons I prefer using the "old-fashioned" cross tab method over PIVOT.

One of the other reasons is to make it dynamic more easily.

Change COUNT(Product) to COUNT(Week) .

I'm just guessing that it is caused by the IN clause.

Why don't you use DELETE FROM <tablename> WHERE Id =10 instead?

If there is more than one value, use a subquery...

Based on the very limited information provided so far: reduce the number of rows in the table or in your select statement (the former by archiving data and the latter...

I would use the "quirky update" method, assuming you're using SS2K and not SS2K5 or higher (in this case ROW_NUMBER() would be my preferred method).

The quirky update method is described...

There are several options I can think of:

1) Analyze the index job if it can be optimized (e.g. only roerganize/rebuild indexes that need to be touched basd on fragmentation level)

2)...

That's weird...

Usually the usage of a format file takes care of conversion errors. If not, a staging table could be used to load the data. However, the final table should...

You might want to be a little more specific what you're really looking for...

If you don't want to provide a start and end date, what will be the logic to...

If you're "unhappy" with the system messages, create your own message and deal with the system generated messages by using a TRY/CATCH block.

I'd be curious to know the business case...

Well, that's not really true...

I, personally, decided not to reply since you're asking for a fix to your loop solution knowing there are alternatives available.

So, instead of...

Hi,

here's the solution using the view instead of the Tally solution (I only changed @SQL2):

SELECT @SQL2 = COALESCE(@SQL2,'')

+ ' SUM(CASE WHEN WeekEndDate = ' + QUOTENAME(d.WeekEndDate,'''')

+ ' THEN TotalPageviews ELSE...

I would use UNPIVOT (EDIT: or UNION ALL if the system is before SS2K5) to normalize the data and a MAX() aggregation grouped by ClientID.

For a coded version I'd like...

Please post table def and some sample data in a ready to use format so I have something to test against. (see the first link in my signature for details...

You need to change your subquery to use View_DSA instead of the tally table to use only the weeks that show up in the table. You probably need to...