0

Please login or register to vote for this query.

(click on this box to dismiss)

Run query and go to the "GRAPH" tab

Q&A for electronics and electrical engineering professionals, students, and enthusiasts

--calculate circle points

declare @Radius float = 100.0
declare @spirals float = 5.0
declare @numberOfPositions float = 360.0
declare @radiansPerPosition float = (360.0 / @numberOfPositions) * pi() / 180.0 --'radians = degrees × pi / 180°
declare @xStop float, @yStop float
create table #x (x float, y float)
declare @z float, @spiral int=0

while @spiral <= 5 
  begin
    set @spiral=@spiral+1
    set @z=0
    while @z <= @numberOfPositions - 1
      begin --calculate points
        set @xStop = Cos(@radiansPerPosition * @z) * @Radius
        set @yStop = Sin(@radiansPerPosition * @z) * @Radius
        insert into #x(x,y) values (@xStop,@yStop)  --write to table (double the height)
        set @z=@z+1
        set @radius = @radius - (10/@numberOfPositions)
      end
  end
	
print @z
select x,' ',y from #x 
union all select 266.0,'   ',100.0 --the keep circle away from edge
union all select -266.0,'     ',-100.0

view current version

edited aug 3 18

created aug 3 18 ashleedawg