title: Add column to SQL result with unique rows
body: <p>I have an query where I get a comma seperated string as result, such as;</p>
  <p>n,n,n,n</p>
  <p>where n can be 0 or 1, and will always be the length of four digits.</p>
  <p>I use CROSS APPLY STRING_SPLIT to get the result as rows. I would like to add a column to this result, and on each row have an unique string, which would be one word.</p>
  <p>Like:</p>
  <pre><code>Value|String
  1    | description1
  0    | description2
  1    | description3
  1    | description4
  </code></pre>
  <p>I have googled a lot, but can't seem to find how to do this. I hope it is as easy as something like:</p>
  <pre><code>SELECT myResultAsRows.Value, {'a','b','c','d'} AS String
  FROM table
  CROSS APPLY STRING_SPLIT ...
  WHERE ...
  </code></pre>
  <p>I know this seems strange, but on another forum (specific for the tool) they suggested hard-coding it...
  I also know it might depend on the server used, but in general, is something like this doable?</p>
  <p>As of right now, the query is this:</p>
  <pre><code>SELECT tagValueRow.Value
  FROM t_objectproperties tag
  CROSS APPLY STRING_SPLIT(tag.Value,',') tagValueRow
  WHERE tag.Object_ID = #OBJECTID# AND tag.Property = 'myTagName'
  </code></pre>
  <p>which results in</p>
  <pre><code>Value
  1
  0
  1
  1
  </code></pre>
  <p>for the specified #OBJECTID#.</p>
  <p>Thank you!</p>
  <p>edit: made the question more detailed, with example closer to reality.</p>