Try this

select t1.TrnxID,sum(case when Posi is not null and strPosi <> Posi then 1 else 0 end)

from

@tPosiHdr t1 left outer join @tPosiDtl t2

on t1.TrnxID=t2.TrnxID

group by t1.TrnxID

careful on day numbers < 10 though

1Jan2009

will be

1012009 no the expected 01012009

Yes you will , sorry i just assumed you needed them pushed into the user table

Try this...

Should be ok.

with cteNewUsers

as

(

SELECT tblTemporaryUsers.FirstName, tblTemporaryUsers.Surname,

tblTemporaryUsers.Email, tblTemporaryUsers.Password, tblTemporaryUsers.Password AS Pass,

tblTemporaryUsers.CompanyID ,

...

You've posted in a 7/2000 forum , is that correct ?

How does the query plan look ?

Is it using indexes ?

You will need to use the row_number() function.

BOL has several good examples

sounds like you need this hotfix

http://support.microsoft.com/kb/937745

Use a trace with the 'stored procedure statement starting' event filter turned on against your specific SPID.

You should be able the exact SQL statement causing it.

GilaMonster (11/4/2009)

---

Providing there's an appropriate index, Column IN (Value1, Value2) will be evaluated as an index seek with 2 seek predicates. It won't cause a scan. NOT IN will cause...

1. The problem with this is that sqlServer will scan every row testing the logic, it wont shortcuit.

2. This should replace your cursor, though i cant test it...

with DistinctCategoryList

(

select...

did you read this article ?

http://www.sommarskog.se/dyn-search-2005.html

You wont get any better response than the information there.

This condition , and the others like it, are jumping out at me

@EPOSManual in ('Manual','All')

What are the possible options of @EPosManual ?

This type of coding will cause massive scans.

There doesent...

Dave Ballantyne (11/3/2009)

---

Sorry that should be WITHOUT the spaces

jay.jose (11/3/2009)

---

I didnt notice that

so in you sql use

select

...