The Offensive Line

  • Comments posted to this topic are about the item The Offensive Line

  • It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    I suppose the offensive line is the 3rd row, because of the 3rd element is just one char:
    "LT" "LG" "C" "RG" "RT" "TE"
    "xT" "xG" "C""RG" "RT" "TE"

  • Carlo Romagnano - Wednesday, August 30, 2017 2:08 AM

    Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    I suppose the offensive line is the 3rd row, because of the 3rd element is just one char:
    "LT" "LG" "C" "RG" "RT" "TE"
    "xT" "xG" "C""RG" "RT" "TE"

    Ah, the x was some kind of placeholder. Now it makes sense πŸ™‚

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • something like Rugby, with it's forward (offensive) and back (defensive) positions
    nice question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    β€œlibera tute vulgaris ex”

  • Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    I didn't understand that either. I was kind of guessing as I had no idea what the requirements of the query were. I guess I have to turn in my citizenship now....I have never been much of a fan of US football.

    _______________________________________________________________

    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 - Wednesday, August 30, 2017 7:31 AM

    I didn't understand that either. I was kind of guessing as I had no idea what the requirements of the query were. I guess I have to turn in my citizenship now....I have never been much of a fan of US football.

    Go ahead and ship that passport to CO, where real fans (and citizens) live.

  • Koen Verbeeck - Wednesday, August 30, 2017 2:35 AM

    Carlo Romagnano - Wednesday, August 30, 2017 2:08 AM

    I suppose the offensive line is the 3rd row, because of the 3rd element is just one char:
    "LT" "LG" "C" "RG" "RT" "TE"
    "xT" "xG" "C""RG" "RT" "TE"

    Ah, the x was some kind of placeholder. Now it makes sense πŸ™‚

    Yes, xNix, or *Nix, is a placeholder. Sorry, should have spelled those out more. I'll edit the question

  • Steve Jones - SSC Editor - Wednesday, August 30, 2017 8:38 AM

    Sean Lange - Wednesday, August 30, 2017 7:31 AM

    I didn't understand that either. I was kind of guessing as I had no idea what the requirements of the query were. I guess I have to turn in my citizenship now....I have never been much of a fan of US football.

    Go ahead and ship that passport to CO, where real fans (and citizens) live.

    LOL. One of my wife's best friends is a huge Broncos fan(atic). I have to admit I liked the Chiefs a lot more when I didn't live anywhere near KC. It is just too over the top here.

    _______________________________________________________________

    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 - Wednesday, August 30, 2017 7:31 AM

    Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    I didn't understand that either. I was kind of guessing as I had no idea what the requirements of the query were. I guess I have to turn in my citizenship now....I have never been much of a fan of US football.

    Can we exchange citizenships? I no longer care about soccer πŸ˜€

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • I was thinking that not calling the tight end position out in the query meant you wanted to exclude that last position (6).

    Also my ex was a huge Broncos fan since she was originally from Denver and I'm a Chiefs fan so that was interesting. Things got ugly at the stadium a couple times because she would show up in a Broncos jersey in a sea of Chiefs fans...

  • Luis Cazares - Wednesday, August 30, 2017 10:10 AM

    Sean Lange - Wednesday, August 30, 2017 7:31 AM

    Koen Verbeeck - Wednesday, August 30, 2017 1:14 AM

    It may be my lack of understanding of American Football positions, but I really didn't understand what was meant with " the offensive line (the xT, xG, C)". Especially because xT and xG are nowhere to be found in the data. Luckily it was clear which was the correct answer, since there was only one that actually selects a line.

    I didn't understand that either. I was kind of guessing as I had no idea what the requirements of the query were. I guess I have to turn in my citizenship now....I have never been much of a fan of US football.

    Can we exchange citizenships? I no longer care about soccer πŸ˜€

    Sure but don't expect me to become a Liga MX fan.

    _______________________________________________________________

    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/

  • Go, Pack! Go!

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply