mk.

14h
answered Typescript generics and finding out the type of a variable
Apr
14
awarded Nice Answer
Mar
16
comment Reusing values from SELECT in second result set
re your above comment: count() takes 12 seconds; returning all rows in the normal way is 33 seconds (2mil rows returned). Copying that result into a temp table before returning adds an additional ~5 seconds. I'm hoping to avoid most of those 5 seconds by copying only 1 column, of only those rows with the flag set.
Mar
16
comment Reusing values from SELECT in second result set
So this would denormalize orig, where each row would appear multiple times per join to more? I'll have a look at this, but orig has ntext etc. which might not like being duplicated. Thanks!
Mar
16
comment Reusing values from SELECT in second result set
@Shnugo The first result set is returned to the client. I don't want that to change. If I have a table variable (with the value 123), I can then join to it in a second query, which will return a second result set to the client. But see the added code. Let me know if you need any other info.
Mar
16
comment Reusing values from SELECT in second result set
If I add INTO #tmp, that first select no longer returns a result set to the client. (Incidentally, adding an index, clustered or not, actually slows down the query).
Mar
16
revised Reusing values from SELECT in second result set
adding more code
Mar
16
comment Reusing values from SELECT in second result set
@Shnugo What other info would help you answer the question? Almost any join you want will work, and even 0 joins are fine. For example, the original table has values (id, my_flag) ((123, 1), (456, 0)); the first select should return both rows. After the first query completes, there must exist a table variable containing the value 123.
Mar
16
asked Reusing values from SELECT in second result set
Feb
17
awarded Famous Question
Feb
11
comment TypeScript strips down comments and spoils JSDoc documentation
You are writing a JS library in TS and you want JS-only docs - perfectly reasonable. You are hoping that the TS compiler might emit code in a way that facilitates your workaround of reading the transpiled JS with JSDoc. It doesn't do that, and I agree that it is disappointing, but sometimes the most helpful answer is just "you can't" (but I couldn't post only that). Instead of trying to change the compiler, why not file a request with the TypeDoc project for a flag that omits docs related to typescript? Seems like a reasonable request. And then you won't need the redundant @public or @var.
Feb
5
answered TypeScript strips down comments and spoils JSDoc documentation
Jan
29
comment Function objects in Typescript d.ts
@DavidSherret Yep, you're right, it's not exact, though the answers are just about the same except for declare. I updated my answer in that other question to cover .d.ts files.
Jan
29
revised build a function object with properties in typescript
added 186 characters in body
Jan
29
comment Function objects in Typescript d.ts
Possible duplicate of build a function object with properties in typescript
Jan
27
comment How to wrap several TypeScript modules into groups for organization
You will be able to achieve the hierarchical grouping nicely using (time-tested) folders. Instead of Foo.Bar.MyClass, it will be "foo/bar/MyClass". Good luck :)
Jan
27
answered How to wrap several TypeScript modules into groups for organization
Jan
27
answered In TypeScript, generics parameter before function
Jan
26
answered what is the correct way to add type definition for this module
Jan
22
awarded Supporter
1 2 3 4 5