Viewing 15 posts - 2,821 through 2,835 (of 4,820 total)
Another option for you:
Create a custom function to do both the split and the translation at the same time and add a quick query around it. Here's...
February 21, 2017 at 1:48 pm
February 21, 2017 at 12:03 pm
Just so folks are aware, pietlinden's solution will work, but may have incorrect results if that script fails to run on a given day. If that fact is detected and...
February 20, 2017 at 10:48 am
Not sure exactly what you are looking for here. Your words didn't explain in much detail what you are looking for, so I made a guess based on what I...
February 20, 2017 at 6:48 am
February 19, 2017 at 12:08 pm
Hi Steve, Thank you for your reply!
February 17, 2017 at 3:04 pm
February 17, 2017 at 2:49 pm
I have not, but I wonder if maybe they exist at your project level instead of the package level, so they might be located in one of the project's XML...
February 17, 2017 at 1:51 pm
That kind of depends. If you know in advance the largest possible number of locations in a region, it's easiest with what is referred to as a CROSSTAB query. Of...
February 17, 2017 at 1:45 pm
As for the choice of intermediate version, I'd go with 2008 R2 over 2005. The reason is because I was reading an MS site on upgrading to 2016, and that...
February 17, 2017 at 1:33 pm
February 17, 2017 at 1:15 pm
Would you be available for a remote session in a couple of hours or some...
February 17, 2017 at 12:56 pm
February 17, 2017 at 12:47 pm
Nice query, Peter. Only 2 scans and 2 logical reads. Here's a slightly modified version that can also tell you what field pairs were involved:
WITH ColumnValues AS...
February 17, 2017 at 12:39 pm
February 17, 2017 at 12:11 pm
Viewing 15 posts - 2,821 through 2,835 (of 4,820 total)