Viewing 15 posts - 1,561 through 1,575 (of 4,087 total)
The real issue is that one of your tables isn't normalized. If you normalize your table, you don't...
October 26, 2017 at 9:44 am
You don't want to do it this way. You want to split the string in b and then join on that split, otherwise you'll get matches like 'York' and 'New...
October 25, 2017 at 1:48 pm
October 25, 2017 at 12:40 pm
October 25, 2017 at 10:11 am
October 25, 2017 at 9:03 am
When I read the suggested solution, I knew there had to be a better approach, because it's scanning each of the tables three times: once for the beginning dates, once...
October 25, 2017 at 8:59 am
October 24, 2017 at 1:40 pm
October 24, 2017 at 11:51 am
October 23, 2017 at 3:15 pm
October 23, 2017 at 9:32 am
T-SQL is horrible at string manipulation. Your best option is to use SQLCLR.
You also need to better define your options, Specifically what do you want to happen when...
October 23, 2017 at 9:11 am
October 20, 2017 at 9:53 am
October 19, 2017 at 2:54 pm
Viewing 15 posts - 1,561 through 1,575 (of 4,087 total)