Are the posted questions getting worse?
-
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
Who is going to grade this one? The answers to this are in essay format which is not the typical QOTD multiple guess format. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Sean Lange (4/14/2016)
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
Who is going to grade this one? The answers to this are in essay format which is not the typical QOTD multiple guess format. 😀
Hey - At least everything's spelled correctly. 😛
-
Chris M and a good chat
😎
-
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
Yes he did. Then the OP moved on to his loop to split strings. I referred him to Jeff's article and I'm curious on where it'll go.
Thanks for that referral. I noticed the string splitting and wanted to google to find a link for him, but then dinner was ready and it smelled too good to wait. I was happy to see you had chimed in when I returned.
I later realized that his original question was on string splitting too. He used an admittedly very creative XML workaround to split the string. I had missed that at first because I was too focused on the reported problem. My bad.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ -
Eirikur Eiriksson (4/14/2016)
Chris M and a good chat😎
Don't listen to him he's drunk as usual 🙂
[font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]For better assistance in answering your questions, please read this[/url].
Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
-
Ed Wagner (4/14/2016)
Sean Lange (4/14/2016)
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
Who is going to grade this one? The answers to this are in essay format which is not the typical QOTD multiple guess format. 😀
Hey - At least everything's spelled correctly. 😛
Good point!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
Easy, it's missing a semicolon
-
Luis Cazares (4/14/2016)
Phil Parkin (4/14/2016)
Steve Jones - SSC Editor (4/14/2016)
Well, apparently I don't write good questions to teach these people things.Maybe some of you should write some questions to help people learn how to write DML?
:-P:-D:w00t::hehe:
Seriously, looking for articles and questions, if you are so inclined.
Something like: What is the problem with the following query?
select * from(delete
(update (insert into
where
select 1/0 where 4 = 5)
)
)
Easy, it's missing a semicolon
Oh that's right. It should be
;select
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Ed Wagner (4/14/2016)
Luis Cazares (4/14/2016)
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
Yes he did. Then the OP moved on to his loop to split strings. I referred him to Jeff's article and I'm curious on where it'll go.
IMO, people that can't understand INSERT INTO...SELECT shouldn't be coding
splittersin T-SQL.Agreed. Learn the basics of the language before using it. Then, after you've learned it, learn something new every day.
I just saw his LinkedIn profile (the url is on his signature) and now I'm confused. It doesn't seem to be the same person. Do we have a DID epidemy in the site? Is it contagious?
-
Hugo Kornelis (4/14/2016)
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
Yes he did. Then the OP moved on to his loop to split strings. I referred him to Jeff's article and I'm curious on where it'll go.
Thanks for that referral. I noticed the string splitting and wanted to google to find a link for him, but then dinner was ready and it smelled too good to wait. I was happy to see you had chimed in when I returned.
I later realized that his original question was on string splitting too. He used an admittedly very creative XML workaround to split the string. I had missed that at first because I was too focused on the reported problem. My bad.
No problem. You got him to read the syntax for an INSERT statement that everyone was telling him. He needed to get beyond that before the splitting anyway.
BTW, I'd pick eating dinner over posting every time. 😛
-
Luis Cazares (4/14/2016)
Ed Wagner (4/14/2016)
Luis Cazares (4/14/2016)
Ed Wagner (4/14/2016)
SQLRNNR (4/14/2016)
Luis Cazares (4/14/2016)
Is this guy for real?How is it possible that he can't work out a basic DML statement and still have a job?
Hopefully Hugo has him sorted.
Yes he did. Then the OP moved on to his loop to split strings. I referred him to Jeff's article and I'm curious on where it'll go.
IMO, people that can't understand INSERT INTO...SELECT shouldn't be coding
splittersin T-SQL.Agreed. Learn the basics of the language before using it. Then, after you've learned it, learn something new every day.
I just saw his LinkedIn profile (the url is on his signature) and now I'm confused. It doesn't seem to be the same person. Do we have a DID epidemy in the site? Is it contagious?
Gosh no kidding. The inability to write a simple insert statement does not seem to correspond with the listing of work experience on his linked in profile. Either it isn't the same person, they made up most of their profile or he has suffered a serious head trauma and a has a massive case amnesia.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
Curious to see the disconnect -- yep, there doesn't seem to be any way someone with that resume would have that much problem writing an INSERT/SELECT.
-
Well, that won't be the first impostor we have run across.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Sean Lange (4/14/2016)
Oh that's right. It should be;select
BURN IT WITH FIRE!!!!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
Grant Fritchey (4/14/2016)
Sean Lange (4/14/2016)
Oh that's right. It should be;select
BURN IT WITH FIRE!!!!
Of course you do realize that all the same people that still start a cte with a semicolon will start doing this with select statements once it it required to terminate every statement. I am somewhat surprised I have not yet seen this recommendation by the pundits that insist on statement beginninators. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 53,521 through 53,535 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply