Viewing 15 posts - 901 through 915 (of 8,731 total)
If the column division is not nullable, the following code might be what you need. If it's nullable, you would want to add a third condition in the parenthesis.
October 16, 2017 at 11:19 am
October 16, 2017 at 10:56 am
October 16, 2017 at 10:00 am
I'm all set to start my birthday weekend in New Orleans. Any recommendations for things I shouldn't miss? Taking into account that I'm with my wife, mother-in-law and probably my...
October 13, 2017 at 1:57 pm
October 13, 2017 at 1:53 pm
Actually, I think that the solution is something as the one presented here:
http://www.sqlservercentral.com/articles/T-SQL/68378/
Be sure to follow the links for the optimal solutions.
October 13, 2017 at 1:49 pm
Hello,
Can you please help me understand...
October 13, 2017 at 9:08 am
October 12, 2017 at 1:29 pm
I see what the error is, but I'm not sure what you want to do. Both functions seem unrelated, so having the same structure is illogical.
Also, check the following...
October 12, 2017 at 8:41 am
October 12, 2017 at 8:11 am
All three of the queries I provided Perform an Index Seek on the non...
October 11, 2017 at 11:39 am
My advice is not to trust what others tell you. Just do a simple test and review the behavior using the execution plans.
First, let's create some sample data:
October 11, 2017 at 10:33 am
Viewing 15 posts - 901 through 915 (of 8,731 total)