Viewing 15 posts - 4,501 through 4,515 (of 13,871 total)
OK, without TOKEN, this gets complicated, fast. Try this:
For SchemaId:
LEFT( replace(REPLACE( [PCMRetrievalCode] , "PO","" ),"PA","") , FINDSTRING( replace(REPLACE( [PCMRetrievalCode] , "PO","" ),"PA",""), "CON",1)-1 )
And for ContainerId
April 20, 2018 at 1:49 pm
April 20, 2018 at 12:52 pm
Hi Phil,
Thanks for your suggestion. I think I seem to understand it, but a...
April 20, 2018 at 9:16 am
April 20, 2018 at 7:39 am
April 20, 2018 at 7:23 am
Yes, there'll always be 'PO' or 'PA' and a 'CON' in the...
April 20, 2018 at 6:36 am
I'm hoping to get your guidance on this. I have a column, consisting of variable...
April 20, 2018 at 5:29 am
April 20, 2018 at 5:13 am
April 18, 2018 at 12:31 pm
I know about TFS (although I'm fair from an expert).
I'm not clear on how...
April 18, 2018 at 12:27 pm
DateDiff is behaving in the way it was designed – please read up on datepart boundaries in the online documentation for the function (link).
April 18, 2018 at 9:19 am
I have had this SSIS package that has an Advanced Email and...
April 18, 2018 at 8:22 am
April 17, 2018 at 1:07 pm
Viewing 15 posts - 4,501 through 4,515 (of 13,871 total)