.

This should work.

SELECT DATEPART(mm, K.[Date]) AS [Month], K.[KPI_Code], K.[Field_Code], K.[Field_Desc], K.[KPI_Value], K.[SubValue_1], CASE WHEN ISNULL(M.[MasterValue], 0) = 0 THEN NULL ELSE K.[SubValue_1] * 100.0 /M.[MasterValue] END AS [ReturnPercent]

FROM [OPS_KPI_Volume_Test]...

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=197077

Nevermind, wrong thread .

If wants to use a table function as if it were a parametered view :

Select col1, col2 from dbo.fnvwBigFastQuery(DateRange), not the other way around.

He can't blame you for hardware problems.

He can blame you for not backing it up and himself for not making sure you backed it up though

Please not that one again .

On 4M rows, scans must be out of the question and stay that way...

Can you post the execution plan of the query you think works the best? Maybe we...

Ya and you seem to like those approaches more often than not...

just my 2 cents.

How did the file get damaged anyways?

Don't use a loop and do it set based...

Can we see the rest of the proc's code, the table definition, some sample data and the expected output?

Agreed .

Who would dare to suggest such a thing ???

I don't mind... as long as you keep agreeing with my solutions

You're the only one who's continuously sending answers with pathindex and they more often than not beat the crap out of what anyone else can come up with. Maybe...