Which type of Numbers?

Question

Post reply

Which type of Numbers?

Shiva N

Hall of Fame

Points: 3125
More actions
September 15, 2014 at 9:41 pm

#397348

Comments posted to this topic are about the item Which type of Numbers?
Thanks,
Shiva N
Database Consultant

Viewing 15 posts - 1 through 15 (of 46 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259187 More actions · Answer 1

Is that ... a recursive query to generate numbers? :sick:

😀

Technically, the numbers are rational numbers as well.

Anyway, nice question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22786 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22786

September 16, 2014 at 1:04 am

#1745674

WOW64, I learned something new!

😀

robertjtjones SSC-Addicted Points: 484 More actions · Answer 3

Had to look up what the different types of number were for some of them 🙂

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

And this relates to SQL Server how? I am not here for maths lessons.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 5

Amstrong numbers. OK, Will try to remember it. 🙂

Minor code improvement. SUBSTRING() : If start_expression is greater than the number of characters in the value expression, a zero-length expression is returned. So ISNULL() is useless here.

Koen Verbeeck SSC Guru Points: 259187 More actions · Answer 6

Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.

It's an exercise in reading T-SQL 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sean Pearce SSCoach Points: 15999 More actions · Answer 7

Koen Verbeeck (9/16/2014)
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.
It's an exercise in reading T-SQL 🙂

So reading the SQL will give you the convoluted university level naming convention for the number sequence?

Rather just let us choose from a list of number sequences.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

serg-52 (9/16/2014)
Amstrong numbers. OK, Will try to remember it. 🙂
Minor code improvement. SUBSTRING() : If start_expression is greater than the number of characters in the value expression, a zero-length expression is returned. So ISNULL() is useless here.

+ 1, good note 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.

+ 1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Koen Verbeeck (9/16/2014)
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.
It's an exercise in reading T-SQL 🙂

Still not convinced it`s important to us SQL users.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

RLilj33 SSCrazy Points: 2203 More actions · Answer 11

Hany Helmy (9/16/2014)
Koen Verbeeck (9/16/2014)
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.
It's an exercise in reading T-SQL 🙂
Still not convinced it`s important to us SQL users.

Agreed that there is very limited practical application from a math perspective, but we are here to learn. After all, if all of these questions were gimmes and there was no challenge, the QoTD would be pedantic and meaningless. 😉

This particular question has validity because it offers some creativity. Look at some of the SQL commands and their combinations used to create this solution:

- Common Table Expressions

- Unions

- less common functions such as POWER

- OPTION with MAXRECURSION

BOL is very good at explaining how a single topic works. BOL is not very good at guiding you in how to use those in complicated situations.

For seasoned veterans (where I assume you are), you may not get much out of it. For many, they will learn something new. For me, I have used cte's extensively, but haven't had a need for the MAXRECURSION option so I took this opportunity to read up on it.

SqlMel SSCrazy Points: 2901 More actions · Answer 12

Hany Helmy (9/16/2014)
Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.
+ 1

+ select floor(log(square(POWER(substring (cast (1000 as varchar(10)),1,1),5000))*3))

---------------
Mel. 😎

sestell1 SSChampion Points: 10230 More actions · Answer 13

I thought it was a neat question.

It wasn't that difficult looking up the types of numbers in the answers and I learned something new and interesting.

Sean Lange SSC Guru Points: 286609 More actions · Answer 14

Sean Pearce (9/16/2014)
And this relates to SQL Server how? I am not here for maths lessons.

It isn't even really math. From the wiki page.

These are odd facts, very suitable for puzzle columns and likely to amuse amateurs, but there is nothing in them which appeals to the mathematician.

I too found it strange to have to research what the name of this was. Still I thought was an interesting question.

_______________________________________________________________

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/