Im looking for a query to produce multiples of a number

Question

  SELECT TOP 10 ROW_NUMBER() OVER (ORDER BY [object_id]) 
  FROM sys.all_columns

Running that code im able to get a incrementing count shown below.

im looking for a way to get multiples of a number, for example, 28

So... `SELECT TOP 10 28*ROW_NUMBER()`? – mellamokb Mar 09 '16 at 17:03 — mellamokb, Mar 09 '16 at 17:03
@juan 53 * 28 should be my last number – Mar 09 '16 at 17:06 — , Mar 09 '16 at 17:06

score 1 · Answer 1 · edited May 23 '17 at 11:59

1

You need a way to generate a list of numbers

https://stackoverflow.com/a/33146869/3470178

SELECT 24 * I as multi
FROM (
        SELECT (ones.n + 10*tens.n) as i
        FROM (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),
             (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) tens(n)
        WHERE ones.n + 10*tens.n < 100 -- Your Limit
      ) T
ORDER BY multi

edited May 23 '17 at 11:59

Community

1
1

answered Mar 09 '16 at 17:07

Juan Carlos Oropeza

47,252
12
78
118

score 0 · Accepted Answer · answered Mar 09 '16 at 17:05

0

If we are using the same idea :

SELECT TOP 10 yourNumber * ROW_NUMBER() OVER (ORDER BY [object_id]) 
FROM sys.all_columns

It will give your number * 1, then your number * 2, ...

answered Mar 09 '16 at 17:05

Izuka

2,572
5
29
34

huh, didnt think of that one. ty – Mar 09 '16 at 17:07
Yes, this sound good. I tought the problem was generate the numbers. – Juan Carlos Oropeza Mar 09 '16 at 17:09
@lizzy81 If Juan's answer or mine helped you to solve your problem, do not forget to select one has good answer before moving on. – Izuka Mar 09 '16 at 19:11
i was going to mark yours, but i had to wait 7 minutes. thanks for the reminder :) – Mar 09 '16 at 19:23
Thank you. That way it also clarifies that the problem is solved. – Izuka Mar 09 '16 at 19:31

Im looking for a query to produce multiples of a number

2 Answers2