Viewing 15 posts - 3,826 through 3,840 (of 8,731 total)
Here's the original post. http://www.sqlservercentral.com/Forums/Topic1735322-391-1.aspx
I've already posted a new possible solution.
November 13, 2015 at 1:04 pm
Sean Lange (11/13/2015)
Ed Wagner (11/13/2015)
Sean Lange (11/13/2015)
November 13, 2015 at 1:00 pm
Just to make it easier to get to the correct article for DelimitedSplit8K
November 13, 2015 at 12:49 pm
RVO (11/13/2015)
So you insist CROSS JOIN is a bottleneck.. I guess.I actually did a test.
I removed JOIN ON (1=1).
But the execution time did not change at all...
No, I'm just saying...
November 13, 2015 at 12:12 pm
It seems that you had some fun working on this query and you'll have more ahead. 😀
I'd specify the cross join explicitly, just to let clear that I know what...
November 13, 2015 at 11:35 am
This might do the trick. I can't understand why would anyone want this order.
WITH rCTE AS(
SELECT [KeyProductControlDisplay],
[KeyProductControlDisplayParent],
...
November 13, 2015 at 9:57 am
An index scan is not a bad thing. You might have many nulls which would make the scan a better approach, maybe the column is not part of the index...
November 13, 2015 at 9:41 am
hoseam (11/13/2015)
I have a column that has values [1,2,3....10,11,13,14 ...]
I want to return just two characters, e.g [01, 02, 03....10,11,12...]
I concatenated a string before to
'0'||CAST(m.d_depend as varchar(2)) as 'depend'
...
November 13, 2015 at 9:28 am
Using IS NULL results in a SARGable predicate. Using ISNULL() results in a non-SARGable predicate. Maybe that's the confusion.
To be fair, a predicate checking for IS NULL might result in...
November 13, 2015 at 9:24 am
BL0B_EATER (11/13/2015)
BrainDonor (11/13/2015)
Now that I've faced the editor for this,...
November 13, 2015 at 8:38 am
Alan.B (11/12/2015)
Luis Cazares (11/12/2015)
Do you know what the stuff function does?https://msdn.microsoft.com/en-us/library/ms188043.aspx
SELECT STUFF ( 'This is a lack of knowledge' , 11 , 7 , 'great' )
Though STUFF is an insignificant...
November 12, 2015 at 1:54 pm
You might be a victim of triangular joins. http://www.sqlservercentral.com/articles/T-SQL/61539/
Can you post the information needed as explained in this article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 12, 2015 at 1:41 pm
That's why it's important to test correctly.
You're right about adding the minutes instead of subtracting them. The NULL value might be there because you're still using the <= comparison.
I updated...
November 12, 2015 at 12:56 pm
Eirikur Eiriksson (11/12/2015)
MUST Resist...temptation...bad...joke!!😎
I'm not sure about the bad joke, but I couldn't resist posting. :pinch:
November 12, 2015 at 11:55 am
Do you know what the stuff function does?
https://msdn.microsoft.com/en-us/library/ms188043.aspx
SELECT STUFF ( 'This is a lack of knowledge' , 11 , 7 , 'great' )
November 12, 2015 at 11:53 am
Viewing 15 posts - 3,826 through 3,840 (of 8,731 total)