help in logic

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 3, 2012 at 2:04 am

  #1427581

  Jeff Moden (1/2/2012)

  ---

  ...Just because a query doesn't work doesn't mean it's unreliable... it just very reliably doesn't work the way you wrote it. 😀

  Jeff, you're simply GREAT!

  I should print your quote on a 3 mt. banner and hang it on the wall here! 😀

  I'm sure that you had the chance to investigate in depth how self referencing variables work when you wrote the "quirky update" articles.

  However, don't take offence, but I think I'll keep using the XML method. I think it's the easiest to remember and implement.

  Thanks for the good lesson learned and for the time to put the test together.

  -- Gianluca Sartori

• Jeff Moden

  SSC Guru

  Points: 1004638

  More actions

  January 3, 2012 at 4:37 am

  #1427629

  No offense taken. The XML method will take pretty much anything that you can throw at it. You just have to remember about entitization of characters. Hmmmm... does that make it "unreliable" or just mean that you wrote it incorrectly. 😀

  Thanks for the feedback, Gianluca. I'll post some code that demonstrates the "unreliability" of the self-referencing variable method of concatenation tonight after work.

  Heh... best laid plans of mice and men... I never did get back to this. My apologies.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)