Thanks Chris

I'm going to bookmark this little lot as I'm fairly certain it will come up again (and again, and again).

Thanks Chris

Just to check my understanding of this, it looks like the splitter will help to give each code it's own line number to start with.

Then, the SELECT after the...

You can have any of:-

Q22

Q23

Q24

ahead of either

Q07

Q08

As far as I know, you won't get more than one from each set.

The codes above could have one extra digit at the end...

Hi Chris

Here's the script with around 450 records. Not all of them will have one (or more) or each set of codes.

create table #test (Code varchar(1000))

insert into #test (Code)

select...

Scott - I want to keep an eye on the overall job as the steps within it could change/be added to.

If I can sort out the loop then I can...

OK, I thought I'd got the loop sorted out but it only works on the actual server the job is running on.

I need it to run on the calling server.

This...

Hi all

I'm trying to use sp_help_job (as suggested by Gail) to get the current status of the job I need to track.

Basically, I want to wait for the job...

Thank you.

I assume this will need to be run on the remote server.

Thanks Gail.

I'm assuming (and please correct me if I'm wrong) that the status is held in a table somewhere?

I'm happy to code the loop to see if the called job...

Sounds fair. :hehe:

Just did, and I think it makes sense.

Why SARG????

Hi Luis

Thanks for the links, I'll have a look when I get chance (hopefully today).

As for the test patients, they're part of our raw data which is why I have...

Thanks Luis

Firstly, that's a lot shorter than my code and (I assume) will run a lot quicker.

Just a couple of questions, I've googled cross apply several times but I always...

Hi all

I like the idea of the cross-tab/pivot but I'm not sure how they would work?

Any idiot-proof info available?

As per an earlier request, here's the entire select statement:-

select

AD.VisitID

,AD.PtStatus --inpatient or...

You can use the EXEC statement inside the calling proc and pass it the name of the proc(s) you need to run first one at a time.

That should cover what...