Viewing 15 posts - 646 through 660 (of 2,443 total)
Jeff Moden (5/12/2011)
Stefan Krzywicki (5/12/2011)
Steve Jones - SSC Editor (5/12/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 13, 2011 at 6:32 am
Jeff, http://www.sqlservercentral.com/Forums/Topic1107435-338-1.aspx#bm1108098
---------------------------------------------------------
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 12, 2011 at 6:54 pm
Thanks Gail! No Swype just sucks. That may be a deal-breaker, it won't be better for my wrists to type on that virtual keyboard than use my ergo one.
---------------------------------------------------------
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 12, 2011 at 6:30 pm
why do I need an iPad2? suggestions? (32GB wifi version, guy at work selling it)
my list so far:
1 - I can use it for my schoolwork online, reading the...
---------------------------------------------------------
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 12, 2011 at 3:22 pm
bpar (5/12/2011)
In the Dates CTE, you reference a table OHIO_REPORT_DETAILS.dbo.Tally that has a column n. What is the purpose this...
---------------------------------------------------------
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 12, 2011 at 2:29 pm
Colleague threw this together when I got stuck, doesn't have your recordID, which might be a problem for you, let me know how it looks. (Thank Adam, not 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."
May 12, 2011 at 12:59 pm
Gotcha. So Anbu, what have you tried so far? Did you read the entry on Datename()? Do you have any questions about how to use 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."
May 12, 2011 at 7:44 am
In addition, if you just wanted to overwrite the file itself, you can specify in a SQL task to DROP TABLE `Sheet1$` and then CREATE TABLE `Sheet1$` and it will...
---------------------------------------------------------
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 11, 2011 at 9:21 pm
See Kimberly Tripp's blog for a detailed explanation of what Lowell is talking about: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Determining-the-position-of-search-arguments-in-a-join.aspx
It's the difference between only joining on the records with that condition (e.g. condition in the...
---------------------------------------------------------
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 11, 2011 at 9:15 pm
which one is the widget number, and what does the Summary column tell us? I was assuming the Summary or the widget numbers would have to be the same, but...
---------------------------------------------------------
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 11, 2011 at 9:09 pm
look up DATENAME() in BOL, that should do the trick. Is this just a reference table for the months of the year? If you're actually trying to store the months...
---------------------------------------------------------
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 11, 2011 at 8:57 pm
Steve Jones - SSC Editor (5/11/2011)
Eric M Russell (5/11/2011)
Steve Jones - SSC Editor (5/11/2011)
Eric M Russell (5/11/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 11, 2011 at 10:11 am
Totally understand the real estate issue. Bet they want to print it out too, right? 😉
We've been working on a patient dashboard ourselves but haven't gotten the lab values in...
---------------------------------------------------------
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 11, 2011 at 10:00 am
Kenneth Wymore (5/11/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 11, 2011 at 9:50 am
Pete, curious why you're doing this? Won't you have to explain the abbreviations to users anyway? What about multiples/duplicates (Mercy Hospital / Mercer Hospital / Mary's Hospital/ etc?) Are you...
---------------------------------------------------------
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 11, 2011 at 8:41 am
Viewing 15 posts - 646 through 660 (of 2,443 total)