Todd/Elliot,

Thank you both for your answers and also for the hint of expressions, unfortunately I'm working with a third party app which is passing user selections directly tasks properties via...

Doh!

That got it, so often the simplest things which are overlooked.

Thanks very much!

Iain

William,

Thanks for the reply and advice, as far as I can tell after a bit of Googling the way to watch a variable is to put a break point in...

Forgot to incude this, its the query I'm using to bring back the data from the linked server:

select

*

from uk01dfin001

Hi Bart,

Thanks for looking at this.  As suggested I ran a "select into" to a # table, the datatype assigned to the columns in the resulting table is numeric 26,3. ...

You could start with a distinct list of RL_LOCKED_RECORD_GUID from _RECORD_LOCKS and then outer join this list back to the USERS_LOGIN table.

You'd need to do a bit of...

Hi Goodguy,

Sorry if the reply was a bit overcooked, as it turns out I don't think I did understand your question previously, just to confirm then that you are after:

Room...Rollover...Arrival...Departure

103...............abc.......def

from...

Hi,

I find it a little difficult to understand your example though I understand your question.

If you want data returned in a 'shape' that isn't contained in your database...

Sweet, wouldn't have though of that (again always overlooking the simple things).

For anyone reading this with the same problem the solution using the above suggestion is:

delete from @a...

Hi,

In your where clause use two variables, eg @start_time and @end_time, so your where clause will look something like

"where all records completed between @start_time and @end_time"

Then...

Always the simple things! 

Thank you very much.  Out of interest is there another way to achieve this with 2000 (I'm not asking for a full example, just a hint)?

Cheers,

Iain