It would be useful to have this implemented...

         8.4  <in predicate>

         Function

         Specify a quantified comparison.

         Format

         <in predicate> ::=

              <row value constructor>

                [ NOT ] IN <in predicate value>

        ...

I think you can simplify the query a bit too using xpath in the WITH clause...

set nocount on

DECLARE @xml VARCHAR(2000)

DECLARE @ParameterFilter TABLE(localname varchar(1000), value varchar(1000))

DECLARE @idoc int

SET @xml='<FilterString><Sender /><OurReference /><Reference>PT21  ...

optimists read no further

after a few phonecalls ... please give complete core dumps of everything your'e...

Interesting  - i didn't know that isnull worked differently from coalesce either, so thanks for that .

I'm just used to using coalesce,...

wierd - dont' think I'd expect that, but haven't got access to sql server today to play with 

does COALESCE(Val, 0) behave the same?

and do...

sorry - didn't read that very well did I

in a stored proc...

declare @t_seq table(Company char(1), OrderNum int, Sku int, seq_num int identity)

insert into @t_seq

select ...

select * from @t_seq

Jon

The change tracking updates can be delayed if the server is busy since the update waits until cpu processing is below a certain level.  So if the server is very busy,...

Tried this on a small table here and it seems to works fine - do you have any other info/ details about your data or server set up?

Is your query parallellarisalized  ?  If so, are you on SP3 or prior / the latest SP ?

Found this MS KB -

http://support.microsoft.com/default.aspx?scid=KB;en-us;Q814509

Sounds similar...

If those are the only values in tblStudentOld, how about

update  tblStudent

set RollStatus = 316 - o.Boarder

from tblStudent s

join tblStudentOld o

on o.StudentID = s.StudentID

A few variant possibilities - obviously this code, like my brain, comes with no warranty

set nocount on

create table #salesPerson (SPId int, SalesPerson varchar(10))

create...

Carl - could you give a few more details about what you mean by ranking.

CONTAINSTABLE is used with full text searching - the ranking in that gives you the relative...

Graham

Which version of SQL Server are you using?  I've just tried something similar to your proc on a SQL2K instance and it seemed to work ok - only difference is...

If you make them go wrong ( a useful skill to have no matter what anyone says )

select GETDATE(0)

select {fn Now(0)}

they both give...