That's a good idea Sean, I hadn't though of that. I will investigate it.

What is the best way to find the ID of date record I need if I only...

Thanks for the reply. Have figured it out - was a mistake in my code!

Hi SQLSlacker,

That's pretty similar to what I've come up with (and is working)...

;WITH

cteJobQualificationTypeIDs

AS

(

SELECTA.[QualificationTypeID]

FROM[OM_Master_Job_Sub_Type_Competency] A

WHEREA.[JobCompetencyID] IN (SELECT [splitstring] FROM udf_parse_string_into_integer_table(@JobCompetencyIDs)) -- JobSubTypeIDs --

),

cteEmployeeQualifications

AS

(

SELECTA.[LinkedToPersonID]

FROM GC_Person_Qualification A...

Yes you are correct about table b, I've adjusted that now 🙂

Regards Exist, how would I use it to solve this issue?

Many thanks

Charlotte

Thanks for the response...

I think I'll just return the 3 datasets and process them in a loop from the front-end...

wolfkillj (9/23/2013)

---

Charlottecb (9/20/2013)

---

Hi Wolfkillj,

Many thanks to you also for taking the time to respond to my question. Unfortunately it doesn't seem to give me the correct result - all 3...

Hi dwain.c,

Yep that works for me - I'll scale up my data to see how it performs against the other solutions.

Many thanks for responding.:-D

Hi Wolfkillj,

Many thanks to you also for taking the time to respond to my question. Unfortunately it doesn't seem to give me the correct result - all 3 customers have...

Thanks Ed, that's given me what I needed. Many thanks.

😀

Hi ChrisM,

Many thanks for taking the time to do this - I'll try out your version to see how much quicker it performs.:-D

Just ran EXEC sp_updatestats and the problem has gone away! 😀

Hi, I originally had between clauses on the SP but I removed them as I thought that might be the issue but it's the same regardless?

Any other ideas?

Thanks.

Chris, You're a star! That worked perfectly and has helped me out of a jam. Many thanks for all your help - much appreciated.:-D

Hi Chris,

Firstly, thanks again for taking the time to help me...

The final script you wrote doesn't quite give me what I need - If I add an order for a...

Thanks ChrisM, that's great - it fixed my issue. Many thanks for your help.

Final question, any idea how to modify this to group by the week instead of the individual...