Viewing 15 posts - 91 through 105 (of 223 total)
drew.allen (5/26/2011)
The gap/island analysis finds changes in an attribute within a key. The key must be used in both Row_Number() partitions and the attribute is only used in the...
May 27, 2011 at 6:49 am
Here's my initial solution, although it uses a cursor to loop through the multiple insurances.
DECLARE @t TABLE
(
PATID INT
,INSID INT
,YRMONTH INT
)
INSERT @t (PATID, INSID, YRMONTH)
SELECT 1,1,201105
UNION ALL
SELECT 1,2,201105
UNION ALL
SELECT 1,1,201104
UNION...
May 26, 2011 at 7:50 am
Daniel Bowlin (5/18/2011)
Why not just add a very thin row for the interactive sort control below your label headers?
That's exactly what I've already begun to implement as a "work-around." It's...
May 18, 2011 at 9:19 am
I've just come to the realization that interactive sorting makes a text field render in the "middle" vertically even if the text is displayed horizontally -- this occurs when the...
May 17, 2011 at 11:01 pm
Daniel Bowlin (5/14/2011)
I came up with an even easier way to do the descending date sort. Use this as your sort expression:
=DATEDIFF("d",Fields!DateFieldToSortBy.Value,Today())
Daniel -- way to keep "skinning the cat"!...
May 15, 2011 at 8:57 am
Daniel Bowlin (5/13/2011)
May 13, 2011 at 7:39 pm
Ninja's_RGR'us (5/13/2011)
How do you do that with strings / dates?
Good point -- what is the trick for strings/dates?
(For numeric values, multiplying by -1 is indeed clever for the sort...
May 13, 2011 at 10:57 am
Daniel Bowlin (5/12/2011)
2008 has a - for a 0 built in. When I choose it the expression it creates is:
0.00;(0.00);'-'
Try putting that in your format.
Daniel -- thanks for checking...
May 12, 2011 at 10:41 pm
durai nagarajan (5/12/2011)
looks same like iifcan i know why you want to avoid iif
thanks
I have about a dozen columns in a table where the field values are either 1 or...
May 12, 2011 at 6:42 pm
jcrawf02 (5/10/2011)
You know Jeff, eventually "ol' Paint" needs to take a trip to the glue factory 😉
:laugh: Too funny! I like it! ("glue factory" -- Ha! -- way better than...
May 12, 2011 at 7:51 am
Jeff Moden (5/11/2011)
So, here's the new function with a very slight modification that only affects performance a little bit:
--===== Build a real set-based function to find the first letter of...
May 12, 2011 at 7:44 am
jcrawf02 (5/11/2011)
May 11, 2011 at 9:43 am
Vedran Kesegic (5/11/2011)
Today I can throw only cakes, drinks and ice-cream - my son was just born :hehe:
Congrats! Happy early Father's Day!
Jimmy Piersal, on How to Diaper a Baby
Spread the...
May 11, 2011 at 6:43 am
Jeff Moden (5/10/2011)
Pete,Based on the findings in the post above, will you ever have a condition where the first character isn't a letter?
Jeff -- the first character should just be...
May 11, 2011 at 6:31 am
jcrawf02 (5/10/2011)
I'm sure you know this Pete, but throwing in a plug anyways: If you MAKE time for R&D it pays big dividends. Can't count the number of times I've...
May 10, 2011 at 10:27 am
Viewing 15 posts - 91 through 105 (of 223 total)