Viewing 15 posts - 676 through 690 (of 2,443 total)
DARPA. Because they're DARPA.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 6, 2011 at 6:19 am
I'm not sure I'm completely following, but if this is a performance issue, you could load a snapshot of the report and cache that, then the users wouldn't really be...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 5, 2011 at 7:35 am
[Jim].[dba].[Murphy] (5/3/2011)
GilaMonster (5/3/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 4, 2011 at 6:52 am
Stefan Krzywicki (5/2/2011)
Fal (5/2/2011)
Stefan Krzywicki (5/2/2011)
Fal (5/1/2011)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 2, 2011 at 6:47 pm
I took a Systems Analysis class recently, and they were "explaining" the Cloud as anything you access that doesn't run on your computer. I made a nuisance of myself by...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 2, 2011 at 7:11 am
Thanks for the alternative, Peso
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 29, 2011 at 6:16 am
GilaMonster (4/27/2011)
Brandie Tarvin (4/27/2011)
GilaMonster (4/26/2011)
I don't do epic verse.Though... (read attached at your own risk, very amateur attempt)
Wow. Gail, I loved the ice spirit story. That's beautiful and deserves a...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 3:00 pm
Yep, that works even better! Thanks again!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 2:58 pm
Excellent!
SELECT
carriermemid,
CASE
WHEN NOT EXISTS(SELECT * FROM #enrollment AS e2 WHERE e2.carriermemid=#enrollment.carriermemid AND e2.effdate<'1/1/2011' AND e2.termdate>'11/30/2010') THEN 'fail'
...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 1:52 pm
Dammit! Yes, I think I am, although that's not quite perfect. Here's some better info from me to build the #enrollment table, with a member who has two separate spans...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 1:45 pm
See Itzik Ben-Gan's blog for another alternative, we used this to create our own modified membership table for reporting:
http://www.sqlmag.com/blogs/puzzled-by-t-sql
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 11:29 am
Tom.Thomson (4/26/2011)
Grant Fritchey (4/26/2011)
ChrisM@home (4/26/2011)
Is it me, or are the posted questions from developers working on medical systems a little worrying?
I used to work for a medical software company. it...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 7:33 am
GSquared (4/26/2011)
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
Haiku would be fun.
Shakespearian iambic pentameter would be even...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 6:48 am
Stefan Krzywicki (4/26/2011)
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
That is something that would strongly tempt me...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 27, 2011 at 6:44 am
Personally, I learn a lot by being a wallflower in these kinds of conversations, so if it's not in the Thread but you are having it elsewhere, can we get...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 21, 2011 at 7:48 am
Viewing 15 posts - 676 through 690 (of 2,443 total)