Adding SQL Variant Data

• Steve Jones - SSC Editor

  SSC Guru

  Points: 730281

  More actions

  November 11, 2022 at 12:00 am

  #4106964

  Comments posted to this topic are about the item Adding SQL Variant Data

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com

• Tom Uellner

  SSCrazy

  Points: 2864

  More actions

  November 11, 2022 at 1:41 pm

  #4111418

  What happened to the question?

• Dave62

  SSCertifiable

  Points: 7335

  More actions

  November 11, 2022 at 1:54 pm

  #4111422

  "Error: This question has no body."

  Good luck trying to answer this one

  I had to check the date to be sure it wasn't 4/1  🙂

• ratbak

  Ten Centuries

  Points: 1135

  More actions

  November 11, 2022 at 2:29 pm

  #4111651

  Might have been appropriate for Halloween.

• Jeff Moden

  SSC Guru

  Points: 1002102

  More actions

  November 12, 2022 at 1:44 am

  #4111875

  Tom Uellner wrote:

  What happened to the question?

  They stored it in an SQL_Variant with the wrong base type. 😀

  --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.

  Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.
  

  ---

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

• Robin Wilson

  SSCarpal Tunnel

  Points: 4763

  More actions

  November 26, 2022 at 12:49 am

  #4118179

  Has anyone found the body yet?