Viewing 15 posts - 1 through 15 (of 107 total)
The alias indeed, but after the penultimate closing bracket 🙂
Cheers fellas
January 18, 2022 at 9:48 pm
.
January 14, 2022 at 10:15 pm
.
January 14, 2022 at 6:51 pm
.
January 14, 2022 at 6:46 pm
.
January 14, 2022 at 5:44 pm
That is certainly an impressive script 🙂
Now I'm guessing that the Set SQL has to be syntactically correct, when I altered the column names during pre-prod, I noticed a few...
January 14, 2022 at 1:09 pm
I have to say didn't I think of that, a bot that fills in the form at the front end - and it's a tempting idea but would likely raise...
January 11, 2022 at 10:21 am
No problem with that, I've been duly diligent in asking the question here, and similarly I thank you for you input, good sir!!
January 10, 2022 at 10:22 pm
Hi,
Is it an in house written app or 3rd party?
Can you ask the developers how the app encrypts the data?
3rd party
No
Does it use always encrypted by any...
January 10, 2022 at 9:03 pm
I marked Mike's as the script that satisfied my requirement but to be fair Scott's came closest - I can't however changed the marked answer.
Thank you gentlemen 🙂
January 5, 2022 at 6:09 pm
Neither set of code is coming up with a meaningful result set, not sure where the disconnect here is, but I'll try again:
If a row contains:
koagvakjnonsenseajg4648.dbo.RandomTableForSSChahfhaijfhfhf5664646
I want to return the...
January 5, 2022 at 4:54 pm
Firstly, I wish everyone were as explicative as you 🙂
I think the common view at this point is we've had enough of being chiselled by this vendor for consultancy on...
December 15, 2021 at 9:34 am
"Unfortunately the ORM will often construct a bloated sub-optimal SQL query - specially if just using the ORM default setttings."
This is what I suspect to be a contributing factor to...
September 30, 2021 at 11:03 am
The result is quite correct, cheers Phil !
Sum IIF....very nifty 🙂
October 13, 2019 at 8:50 pm
Viewing 15 posts - 1 through 15 (of 107 total)