trapnell (10/9/2015)
Fascinating! You do that just for fun?There are several things in your code I've never seen before. For example, I don't understand why
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
works. I'm going to work through that code until I do understand.
Thanks,
Tom
That is using a table valued constructor. You defined a list of values, give it an alias and define the column name(s). You can read more about this kind of thing here. https://msdn.microsoft.com/en-us/library/dd776382.aspx
For an example like Luis is using scroll down to the examples section and look at example C. 🙂
--EDIT--
LOL Luis has the fastest fingers on the keyboard ever. Seems you beat me to the punch yet again old friend. 😛
_______________________________________________________________
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/