Hi all,

OK I've updated the stats

The where clause has two likes in it,

If I change the first like from %x% to %y% for example always makes the the one...

ok so basically all my data is being join and return as 1 xml row?

what exactly is the PATH('') doing?

Hi all,

Thanks for the feedback.

I'll try and answer all the questions here.

abarber - I have made the changes and bug fixes you suggested, however I'm not sure how to...

Hi Noel,

Thanks for the reply,

What does the dpages mean, is that the space that the index takes up?

Also when I changed the query to use a straight id = x...

Hi There,

Sorry I just saw that you edited your post.

Are you still looking for an explination?

Thanks for all the feedback so far guys, I'm also suprised Jeff isn't all over this he he he

HI Lynn,

Ok what you saying is ringing a bell,

If I use the IF and someone else is doing an update then there is a good change it will pass/fail the...

Hi There,

As far as I understand:

& Performs a bitwise logical AND operation between two integer values.

0x08000000 is a VARBINARY value for an integer in this case 134217728

SELECT 4 & 0x08000000,

CAST...

one more point is that you shouldn't be using with (nolock) or SET ISOLATION LEVEL for performance.

You should only be using these if you need to alter or force locks

HI There,

Ok to get to the VolId I don't think you need to join all the way to the Vol table as you aren't returning or restricting any data from...

Yeah it shouldn't be a problem to hard code that Column, cause looks like that Column and the Code Column will be the only two that you kow for certian.

I...

HI,

I would also suggest reading this for future posts 🙂

http://www.sqlservercentral.com/articles/Best+Practices/61537/

HI there,

Similar problem in your order BY clause you are referencing a column called picked_up which doesn't exists in your pivot query.

You'll need to return that column in your pivot...

Hi,

On your join you are referencing a table called 'picked_up'

Make sure that it exists.

The error you are getting is because it can't find that object.

thanks

Chris

mmm ok here is what I have.

It involves a new column and an update statement.

[font="Courier New"]

DECLARE @Table TABLE (

        id bigint IDENTITY PRIMARY KEY CLUSTERED,

        lang VARCHAR(100),

        code CHAR(1),

       GRP INT

)

DECLARE @Output TABLE(id...