yip i used cross apply yesterday... works good, though hurts performance

i want to process each row....

or how can i retrieve the Context attribute value where its equal to Acquire ??

anyone??

it might possibly be because im extracting node values from XML contained in a column from one of the tables... any ways around this....

actually one of our java developers are trying to execute the proc, on our uk based server

is there a better way that can improve performance cause im calling that function through a stored procedure. the table concerned has lots of xml in it...

thanks

thanks

anyone?

thanks guys, will create a db role first. then apply permission to it specifically.

thanks

indexes are gona improve query performance, but without the PK's or FK's i would be joining like crazy to get results, thats IF i get the proper results.... let me...

MovementCollection:

1.MovementIdentifierContext- 'movement type'

2.MovementIdentifier - '000000012' --->not unique

3.MovementIdentifierComposite - '1+2' -->not unique

4.BinaryData - 'image'

5.XML - 'Full XML'

MovementRelationship

1.MovementIdentifierContext - 'movement type'

2.MovementIdentifier - '00000012' --->not unique

3.MovementIdentifierComposite - '1+2' --->not unique

4.Relationship - 'nature...