Forum Replies Created

Viewing 7 posts - 1 through 8 (of 8 total)

  • Reply To: Implementing Date Calculations in SQL

    Rather than having to refresh your dates every day, wouldn't it have been simpler to implement a view with dynamic dates?

    Each refresh of the report is only ever pulling 2...

  • Reply To: XQuery - Use column value to display correct node

    That is wonderfully simple, thanks Mark.

    Seeing as we're on a roll, lets try for the complete set:

    I can get the full Question node returned using this:

    Question.query('.') AS...

    • This reply was modified 5 years, 7 months ago by Norty303.
  • Reply To: XQuery - Use column value to display correct node

    Hmm, it appears that our XML Doc format is not consistent.

    Sometimes the <question> sits at different levels.

    So we see variations like this:

    assessment/template/question

    assessment/template/group/question

    assessment/template/heading/group/question

    and so forth.

     

    Is there a syntax for selecting a...

  • Reply To: XQuery - Use column value to display correct node

    Thank you Mark, that was the nudge I needed!

    I'd looked at sql:column briefly and thought it looked somewhat set based.

    Am I right in thinking you could do a similar thing...

  • Reply To: The Worst Comments

    My formative years of programming I used an ASCII facepalm art as the header block.

    I felt it gave a good indication of what anyone might expect if they proceeded further. ...

  • RE: The Data Scribe

    Eric M Russell - Wednesday, November 21, 2018 6:46 AM

    Having worked in healthcare IT, I can say that such a job at...

  • RE: The Data Scribe

    This is basically the role of my team.
    In a non IT business, why try and force IT skills (some quite complicated) on an unwilling workforce.
    At best you're going...

Viewing 7 posts - 1 through 8 (of 8 total)