Viewing 15 posts - 2,011 through 2,025 (of 26,488 total)
Okay, I have to leave but I am hoping that this code may help you figure out what you need to do, and if not, maybe someone else can pick...
January 9, 2018 at 5:33 pm
excellent question. I tried two different solutions one using standard left outer join (self...
January 9, 2018 at 4:44 pm
And what have you tried so far to solve your problem? Remember, we are just volunteers here and you are the one that will have to support any solution that...
January 9, 2018 at 4:31 pm
Probably a better way to accomplish this but with limited time at work here is one way of doing it:
SELECT
CASE WHEN DATENAME(WEEKDAY, CAST(DATEADD(HOUR,11,CreateDate) AS...
January 9, 2018 at 10:03 am
Could we get the DDL for the tables including the indexes currently defined?
January 9, 2018 at 9:42 am
And again, post the actual execution plans for the query with and without the CASE. We need more information than you have provided and these will provide that information. Be...
January 9, 2018 at 8:48 am
This is for entertainment only and that is why I posted it in "
January 8, 2018 at 5:08 pm
January 8, 2018 at 5:06 pm
Please provide details on what is meant by "not working." If you had car trouble would you go to a mechanic and just say "it's broken?"
January 8, 2018 at 4:26 pm
January 8, 2018 at 4:09 pm
QuietCoder - Monday, January 8, 2018 3:31 PMThank you Scott!
Too bad you never posted what you had tried.
January 8, 2018 at 3:39 pm
January 8, 2018 at 2:07 pm
Viewing 15 posts - 2,011 through 2,025 (of 26,488 total)