October 15, 2018 at 7:26 am
Pretty sure this is a prime reason why people are still using the ANSI-89 JOIN syntax: Is this query correct? Why haven't textbooks with this syntax, other than to say "This is how you would have written the query 30 years ago", been burned yet?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2018 at 7:35 am
Thom A - Monday, October 15, 2018 7:26 AMPretty sure this is a prime reason why people are still using the ANSI-89 JOIN syntax: Is this query correct? Why haven't textbooks with this syntax, other than to say "This is how you would have written the query 30 years ago", been burned yet?
Because it still works for correlated sub-queries and is required there. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 15, 2018 at 7:41 am
Jeff Moden - Monday, October 15, 2018 7:35 AMThom A - Monday, October 15, 2018 7:26 AMPretty sure this is a prime reason why people are still using the ANSI-89 JOIN syntax: Is this query correct? Why haven't textbooks with this syntax, other than to say "This is how you would have written the query 30 years ago", been burned yet?Because it still works for correlated sub-queries and is required there. 😉
It's also a lot shorter to write than inner join or cross join if you have something like a generated tally table and you just want a load of cartesian joins.
October 15, 2018 at 7:49 am
Jeff Moden - Monday, October 15, 2018 7:35 AMThom A - Monday, October 15, 2018 7:26 AMPretty sure this is a prime reason why people are still using the ANSI-89 JOIN syntax: Is this query correct? Why haven't textbooks with this syntax, other than to say "This is how you would have written the query 30 years ago", been burned yet?Because it still works for correlated sub-queries and is required there. 😉
Are you really lumping correlated sub-queries and JOINs in the same bucket here Jeff? :hehe:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2018 at 10:53 am
So this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?
Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
October 15, 2018 at 11:00 am
Brandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2018 at 11:07 am
Thom A - Monday, October 15, 2018 11:00 AMBrandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
I'm not sure we're talking about the same person, are we? (I can't unsee that name).
I'd love to see the MSDN and StackExchange links if we are and you have them.
October 15, 2018 at 11:30 am
Hi,
Just curious about this - cut and past from a sqlservercentral https://www.sqlservercentral.com/Forums/1998921/Initcap-the-characters-in-SQL-server post onto social.msdn
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5cb9c231-dad7-4195-9f83-29ec709d5f70/how-to-initcap-the-characters-in-sql-server-in-sql-query-without-creating-any-function?forum=sqldatabaseengine#71813bb7-be29-443b-9c57-5cfe2d3590d8
Would normally consider this to be bad ethics but maybe its just me.
October 15, 2018 at 11:40 am
frederico_fonseca - Monday, October 15, 2018 11:30 AMHi,Just curious about this - cut and past from a sqlservercentral https://www.sqlservercentral.com/Forums/1998921/Initcap-the-characters-in-SQL-server post onto social.msdn
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5cb9c231-dad7-4195-9f83-29ec709d5f70/how-to-initcap-the-characters-in-sql-server-in-sql-query-without-creating-any-function?forum=sqldatabaseengine#71813bb7-be29-443b-9c57-5cfe2d3590d8
Would normally consider this to be bad ethics but maybe its just me.
I just can't let some poor innocent DBA think this guy is an expert at this stuff and contact him thinking he'll get another expert network connection in the SQL world.
October 15, 2018 at 12:04 pm
Brandie Tarvin - Monday, October 15, 2018 11:07 AMThom A - Monday, October 15, 2018 11:00 AMBrandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
I'm not sure we're talking about the same person, are we? (I can't unsee that name).
I'd love to see the MSDN and StackExchange links if we are and you have them.
Oh, no, we're not. I though you meant BugMan.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 15, 2018 at 12:12 pm
Thom A - Monday, October 15, 2018 12:04 PMBrandie Tarvin - Monday, October 15, 2018 11:07 AMThom A - Monday, October 15, 2018 11:00 AMBrandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
I'm not sure we're talking about the same person, are we? (I can't unsee that name).
I'd love to see the MSDN and StackExchange links if we are and you have them.
Oh, no, we're not. I though you meant BugMan.
And finally, he replies to at least one of the threads. Jeff, I think your theory is dead.
October 15, 2018 at 12:13 pm
Brandie Tarvin - Monday, October 15, 2018 12:12 PMThom A - Monday, October 15, 2018 12:04 PMBrandie Tarvin - Monday, October 15, 2018 11:07 AMThom A - Monday, October 15, 2018 11:00 AMBrandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
I'm not sure we're talking about the same person, are we? (I can't unsee that name).
I'd love to see the MSDN and StackExchange links if we are and you have them.
Oh, no, we're not. I though you meant BugMan.
And finally, he replies to at least one of the threads. Jeff, I think your theory is dead.
He actually applied to 2 of the threads. Apparently Jeff was spot on https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
October 15, 2018 at 12:49 pm
Brandie Tarvin - Monday, October 15, 2018 11:40 AMfrederico_fonseca - Monday, October 15, 2018 11:30 AMHi,Just curious about this - cut and past from a sqlservercentral https://www.sqlservercentral.com/Forums/1998921/Initcap-the-characters-in-SQL-server post onto social.msdn
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5cb9c231-dad7-4195-9f83-29ec709d5f70/how-to-initcap-the-characters-in-sql-server-in-sql-query-without-creating-any-function?forum=sqldatabaseengine#71813bb7-be29-443b-9c57-5cfe2d3590d8
Would normally consider this to be bad ethics but maybe its just me.I just can't let some poor innocent DBA think this guy is an expert at this stuff and contact him thinking he'll get another expert network connection in the SQL world.
And now that thread has been deleted 😀
October 15, 2018 at 12:50 pm
frederico_fonseca - Monday, October 15, 2018 12:49 PMBrandie Tarvin - Monday, October 15, 2018 11:40 AMfrederico_fonseca - Monday, October 15, 2018 11:30 AMHi,Just curious about this - cut and past from a sqlservercentral https://www.sqlservercentral.com/Forums/1998921/Initcap-the-characters-in-SQL-server post onto social.msdn
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/5cb9c231-dad7-4195-9f83-29ec709d5f70/how-to-initcap-the-characters-in-sql-server-in-sql-query-without-creating-any-function?forum=sqldatabaseengine#71813bb7-be29-443b-9c57-5cfe2d3590d8
Would normally consider this to be bad ethics but maybe its just me.I just can't let some poor innocent DBA think this guy is an expert at this stuff and contact him thinking he'll get another expert network connection in the SQL world.
And now that thread has been deleted 😀
I bet he's really feeling the love
October 15, 2018 at 5:10 pm
DesNorton - Monday, October 15, 2018 12:13 PMBrandie Tarvin - Monday, October 15, 2018 12:12 PMThom A - Monday, October 15, 2018 12:04 PMBrandie Tarvin - Monday, October 15, 2018 11:07 AMThom A - Monday, October 15, 2018 11:00 AMBrandie Tarvin - Monday, October 15, 2018 10:53 AMSo this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're giving him?Sorry, Jeff, but I don't think he's as clever as you think he is, or as he says he is.
Well, as far as I've seen, he got banned here from reports, all his threads on the StackExchange nextwork got locked (promptly) and his MSDN topic locked yesterday. Not sure where he can reply now without making a new thread.
I'm not sure we're talking about the same person, are we? (I can't unsee that name).
I'd love to see the MSDN and StackExchange links if we are and you have them.
Oh, no, we're not. I though you meant BugMan.
And finally, he replies to at least one of the threads. Jeff, I think your theory is dead.
He actually applied to 2 of the threads. Apparently Jeff was spot on https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
😀
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 62,641 through 62,655 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply