Viewing 7 posts - 1 through 7 (of 7 total)
Thanks all, got it to work!! Much appreciated!!
February 27, 2021 at 4:56 pm
This is great.. I am making progress and learning. LOL.
Can I do this, within the same statement?
IIF(var1Title != '', CONCAT(var1Title, ' - '+var1Topic, ' - '+var1Name), '') AS Item1, IIF(var1Title...
February 26, 2021 at 6:28 pm
jcelko212 32090 - Thanks, appreciate this. As mentioned, I am relatively new to SQL. I'll continue to read up...
The Dixie Flatline - the result that I am hope for based...
February 26, 2021 at 1:24 pm
Reading a little more about this - could you advise on the syntax for CONCAT, when using IIF?
I am struggling getting this to work, using IIFs... see below....
SELECT
IIf([var1Title] != '',...
February 26, 2021 at 1:46 am
Sorry... I was multitasking. LOL.
Reading this now.... is the recommendation a performance issue or a security issue?
Just curious. 🙂
February 26, 2021 at 1:25 am
Oh... ok. I'll read the article.
Can I simply add the SET CONCAT_NULL_YIELDS_NULL to the top of my view?
February 26, 2021 at 12:13 am
That's terrific, thanks.
That saved me a lot of time! LOL
Much appreciated!
February 25, 2021 at 11:33 pm
Viewing 7 posts - 1 through 7 (of 7 total)