Viewing 15 posts - 1 through 15 (of 749 total)
Have you made any improvements to what Frederico provided that you'd be willing to share? Also have you been able to make it so you don't have to use teh...
December 13, 2023 at 4:19 pm
Chris - I know this is like 2-3 years later but I tried your code and it doesn't work for me either. It will show me the tables that the...
December 13, 2023 at 4:16 pm
So is this just another way of doing something like the below? Where the below requires and alias (CC)? And by dropping the alias and the parenthesis you can just...
December 11, 2023 at 6:02 pm
Jeff
Do you know if others would also use the term "Skip Join" so if I googled on SKIP JOIN I'd get info about this or does this not have a...
December 7, 2023 at 8:58 pm
This suprised me to and it does work. It's not something I wrote. It's from the vendor who proivides our primary accounting software. My boss asked me to take a...
December 7, 2023 at 12:10 am
Unfortunately our cloud provider still has us on SQL 2016.
Thanks
November 28, 2023 at 5:31 pm
Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks like...
November 27, 2023 at 6:25 pm
Gotcha. Hopefully someone like Jeff will have some clever way to improve on this as this is a regular fix I'm looking at having to do daily until our vendor...
November 22, 2023 at 9:57 pm
That is what the first code segment is, the current solution. The second if for the tables structure, the DDL
November 22, 2023 at 8:49 pm
Yeah this is kind of what I figured would be the case. The handful of SP's/UDF's I've come across that do something like this are effectively replacing known HTML codes/characters...
November 9, 2023 at 8:18 pm
Unfortunately that's not an option in this case. I am limited to writing valid T-SQL statements so if there's a way in T-SQL to do this great otherwise no.
Thanks
November 6, 2023 at 9:46 pm
OK thanks
November 6, 2023 at 8:08 pm
I thought Elvis was dead.
October 24, 2023 at 8:07 pm
This is why I mentioned Jeff.
October 20, 2023 at 10:00 pm
Glad to see Jeff is here, I know he'll have some interesting insight onnthis question.
CTE or View, which to use and when as well as why?
I personally use both a...
October 20, 2023 at 4:05 pm
Viewing 15 posts - 1 through 15 (of 749 total)