Just simply because after 10 years+ of solid TSQL work, i'd never needed to do that.

You learn something new everyday 🙂

What dont you get ?

I was just pointing out that the query plan does look strange .

More often than not this is caused but out of date stats, and that...

What Does

declare @ID1 as uniqueIdentifier

Set @ID1 = '3f082c39-c69f-472d-9e56-0f23f82e2326'

SELECT *

from JobCategoryRecord JCR

Where JCR.ID = @ID1

do in terms of a query plan?

JobCategoryRecord is a view on tb_JobCategory...

That will be for the Query version , not the stored procedure , correct ?

Google is your friend...

http://searchwindowsserver.techtarget.com/sDefinition/0,,sid68_gci969765,00.html

Please post query plans as per this article

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

It will take the guess work out of it.

On a more positive note, a question that made me think, "CAN you do that" ?

http://www.sqlservercentral.com/Forums/Topic773249-145-1.aspx

Not much different

select a =1 into #tabx

union

select a=2

Just as an aside to that , on the few occasions that ive used 'where current of' ive found it to be pretty poorly performing.

Ok , ill back track a bit :Whistling:

I was using count(*) in my testing not count(columnname) , which as you point out does not count nulls.

But it still needs to...

Its afternoon in London...

Because the inner join will fail ,ie join to no rows therefore, no rows will be returned to count to...

This may not be exactly right as i dont know your data but try

with cteInvoices(Reference,InvoiceDate,InvoiceYear,InvoiceMonth,ServiceOrderCategory,

...

You cant as the return columns are processed after the join and filter conditions

You can do...

SELECT COUNT(dbo.tblBackup.BackupID) AS Total, dbo.tblClient.ClientName

FROM dbo.tblClient INNER JOIN

dbo.tblBackup ON dbo.tblClient.ClientID = dbo.tblBackup.ClientID

WHERE (dbo.tblBackup.BackupDate BETWEEN '2009-08-17...

Then this should do

with cteSites(SiteID, Priority , Value ,RowN )

as

(

select SiteID ,Priority , Value ,row_number() over ( partition by siteId...