Viewing 15 posts - 1 through 15 (of 144 total)
Nice Jacob. thanks for the response.
September 29, 2020 at 4:24 pm
That did it - seems very obvious now and I feel a bit foolish!
Many thanks for taking the time to respond.
September 29, 2020 at 4:13 pm
Joe, chill out man - no one died, it's just a bit of code... It's not even a real table or data - I only created it to highlight my...
September 21, 2017 at 1:54 pm
Drew, that's a great solution. Many thanks.
September 20, 2017 at 2:34 pm
Perfect Phil. Many, many thanks for your help.
September 20, 2017 at 12:19 pm
Phil, you are a legend!
One further small request for help... If I wanted to make it so that if the last occurence was not missed, the record was...
September 20, 2017 at 12:01 pm
That's a good idea. Thanks
December 7, 2016 at 12:28 pm
That's great guys - thanks for all your help on this.
Many many thanks. 😀
December 22, 2015 at 2:06 pm
That works well Chris,
The only bit which doesn't work is the padding of the number to two digits with zero. I replaced your RIGHT('00' + rn, 2)
With
REPLICATE('0', 2 - LEN(rn))...
December 22, 2015 at 4:15 am
ChrisM@Work (12/22/2015)
December 22, 2015 at 3:54 am
John Mitchell-245523 (12/22/2015)
December 22, 2015 at 3:41 am
Brilliant Sean - Many thanks for this. 😀
November 20, 2015 at 7:59 am
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...
November 19, 2015 at 4:18 pm
Thanks for the reply. Have figured it out - was a mistake in my code!
November 19, 2015 at 2:44 pm
Hi SQLSlacker,
That's pretty similar to what I've come up with (and is working)...
;WITH
cteJobQualificationTypeIDs
AS
(
SELECT A.[QualificationTypeID]
FROM [OM_Master_Job_Sub_Type_Competency] A
WHERE A.[JobCompetencyID] IN (SELECT [splitstring] FROM udf_parse_string_into_integer_table(@JobCompetencyIDs)) -- JobSubTypeIDs --
),
cteEmployeeQualifications
AS
(
SELECT A.[LinkedToPersonID]
FROM GC_Person_Qualification A...
October 28, 2014 at 3:04 pm
Viewing 15 posts - 1 through 15 (of 144 total)