Viewing 15 posts - 4,456 through 4,470 (of 13,876 total)
To expand on the above responses, you should see the following amended version of your query return results very quickly, as it will use the CI:
Select...
May 17, 2018 at 11:29 am
You have expressed a requirement, but not asked a question. What would you like help with, exactly?
Please provide consumable DDL, sample data and desired results so that people...
May 16, 2018 at 11:04 am
May 15, 2018 at 1:18 pm
Something like this?select o.OrderNumber from Orders o
where not exists (select 1 from Roles r where r.OrderNumber = o.OrderNumber and o.RoleType = 22)
May 15, 2018 at 1:02 pm
dgl - Tuesday, May 15, 2018 7:55 AMThis is what I was trying to describe as my second option.
Your second option clearly...
May 15, 2018 at 8:36 am
May 15, 2018 at 7:28 am
Output:
Names ...
May 14, 2018 at 8:55 am
Simple, effective and well written. Good stuff.
May 14, 2018 at 4:39 am
This is a requirement. What is your question?
May 13, 2018 at 8:12 am
May 10, 2018 at 12:39 pm
May 10, 2018 at 12:29 pm
Apologies if you've already answered this question, but is the package deployed to SSISDB?
If so, can you check the 'All Executions' report for the package to see whether that...
May 10, 2018 at 9:43 am
Have you tried casting to VARCHAR() and then doing the comparison?
May 9, 2018 at 3:13 pm
Viewing 15 posts - 4,456 through 4,470 (of 13,876 total)