Skip to content

Instantly share code, notes, and snippets.

@Kittoes0124
Created January 7, 2018 20:10
Show Gist options
  • Save Kittoes0124/6827d08e457c1c8b790422af2212982d to your computer and use it in GitHub Desktop.
Save Kittoes0124/6827d08e457c1c8b790422af2212982d to your computer and use it in GitHub Desktop.
select X = X.n
, [Circle] = [Circle].n
, [DxCircle] = X.n / NullIf(2. * Abs(X.n), 0)
, [Rectangle] = [Rectangle].n
, [Dx Rectangle] = 1. / Sqrt(4 * X.n + 1)
, [Square] = [Square].n
, [Dx Square] = 1. / NullIf(2. * Sqrt(X.n), 0)
, [Triangle] = [Triangle].n
, [Dx Triangle] = 2. / Sqrt(8 * X.n + 1)
, [Square Triangle] = [Square Triangle].n
, [Dx Square Triangle] = (1 / NullIf(2 * Sqrt(X.n), 0) + 1) * 0.5
, [√2] = ([Triangle].n - 1) / NullIf([Square].n - 1, 0)
from dbo.RangeInt(0, 1000000) X
cross apply (values((1 + Sqrt(X.n * X.n)) * 0.5)) [Circle] (n)
cross apply (values((1 + Sqrt(1 + 4 * X.n)) * 0.5)) [Rectangle] (n)
cross apply (values((1 + Sqrt(X.n)))) [Square] (n)
cross apply (values((1 + Sqrt(1 + 8 * X.n)) * 0.5)) [Triangle] (n)
cross apply (values((X.n + Sqrt(X.n)) * 0.5)) [Square Triangle] (n)
--where Ceiling([Square].n) = Floor([Square].n)
--and Ceiling([Triangle].n) = Floor([Triangle].n);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment