Hi

I've had a look at the function you suggested and am running the following.

SELECT CRN, Item = QUOTENAME(PS_TestForOnline.all_codes_in_one_field,'"')

FROM PS_TestForOnline

CROSS APPLY dbo.DelimitedSplit8k(PS_TestForOnline.all_codes_in_one_field,'/') split

it...

Many thanks for pointing me in the right direction.

Thanks, oversight on my behalf.

Cheers

Hi Ron,

Your query workd fine but gives me data from Monday 00:00 to Monday 00:00.

Although it is only an extra minute I will pick up unwanted records.

i only need...

Many Thanks Ron

That seems to have done the job.

Regards Paul

Many Thanks fo all your advice. I have my query working a treat now.

Thanks Again

Thanks for your reply.

I'm after all characters after the second ':'

There may be 1 or 2 characters max. There will onl y ever be 2 ':' in the field

So where...

Many Thanks for that. Works a treat.

I have the following script which works.

Although when running against the live data in the warehouse it take a long, long time. I am running it against a table...

Old Hand has it, just the job.

Thanks a million. :-):-):-)

I can see why you would maybe use a reftable of codes shoudldthe job require it, but as the codes will...

Hi

I've tried the union route which should now return an extra row of data from my sample table but I've never tried doing a union on queries before and...

The codes selection will remain pretty static, i may need to add in a date parameter though.

My main prioirty is to be able to get the 4 parameter groups...

Thanks a lot for that. great help. Starting to get my head round all this with the help of this site.:-)

Just 1 more quick question .....

How would i go...

CHEERS CRAIG

THAT WORKED A TREAT. THANKS A LOT

🙂

i've had a look on line and from what i can gather this is going to have to be a self join as one row is looking at another and...