Viewing 15 posts - 1 through 15 (of 110 total)
I would find having "-- (Values)" between the insert and select statements very annoying.
How would you have changed that, preferably? IIRC the final select statement after each Insert statement...
August 17, 2022 at 1:07 pm
The table structures are identical across the estate, so I had wondered if they could - or should - be consolidated somehow.
We copied from about a dozen users who all...
August 15, 2022 at 4:10 pm
Thanks for the heads-up, done and Codeblock function noted for future reference!
August 15, 2022 at 3:48 pm
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
Viewing 15 posts - 1 through 15 (of 110 total)