Viewing 15 posts - 631 through 645 (of 2,443 total)
GSquared (5/17/2011)
Brandie Tarvin (5/17/2011)
jcrawf02 (5/17/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 17, 2011 at 2:35 pm
Stefan Krzywicki (5/17/2011)
jcrawf02 (5/17/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 17, 2011 at 2:34 pm
Data Analyst job will be opening up soon where I work (not mine) in Columbus, OH. Mostly report writing, some dev work in SSRS/SSIS, rest is trending patient utilization and...
---------------------------------------------------------
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 17, 2011 at 12:30 pm
Tom.Thomson (5/17/2011)
Jack Corbett (5/16/2011)
Tom,But you have SQLBits:-P
Thanks Jack. I don't know how I missed that - although it's been going for three and a half years I had never...
---------------------------------------------------------
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 17, 2011 at 7:27 am
That first pdf is specifically about xQuery, and the second link is about Sybase?
In any case, the parsing/normalization is not the issue here, the CREATE statement successfully completes, because 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 17, 2011 at 7:01 am
By which Gianluca is saying that the script you executed completes successfully because it's not RUNNING the code in the stored procedure, it just created a procedure (with bad code...
---------------------------------------------------------
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 16, 2011 at 7:53 pm
See http://facility9.com/2010/02/24/rounding-to-the-nearest-x-minutes for a way of doing this through a reference table as an alternative. Note that Jeremiah is rounding differently than I would when he builds the table, where...
---------------------------------------------------------
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 16, 2011 at 7:49 pm
Or, lazy folks like me in SSMS could expand the Object Explorer, look under Server Objects and Linked Servers and see if your server is listed there.
---------------------------------------------------------
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 16, 2011 at 7:43 pm
You're coming FROM Excel, right? Everything in Excel uses Unicode, so the problem is your destination is NON-Unicode. make your datatype nvarchar in the master table, and you should 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 16, 2011 at 7:42 pm
Set your Action for that cell to Go To URL, and build the URL pointing at your sub-report, with a rendering option of Excel. (see BOL for more details here:...
---------------------------------------------------------
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 16, 2011 at 7:12 pm
SQLRNNR (5/16/2011)
You mean you don't feel like you are involved?
Oh, just ignore me Jason. PASS has been trying very hard to make changes, I can see that.
---------------------------------------------------------
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 16, 2011 at 2:14 pm
SQLRNNR (5/16/2011)
Grant Fritchey (5/16/2011)
Jack Corbett (5/16/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 16, 2011 at 1:56 pm
Grant Fritchey (5/16/2011)
Jack Corbett (5/16/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 16, 2011 at 1:54 pm
Stefan Krzywicki (5/16/2011)
GSquared (5/16/2011)
Peoplesoft and JD Edwards are Oracle products, not Oracle competitors. The survey was about Oracle products, not just about their database engine, so it would naturally include...
---------------------------------------------------------
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 16, 2011 at 1:52 pm
WayneS (5/14/2011)
jcrawf02 (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 16, 2011 at 7:49 am
Viewing 15 posts - 631 through 645 (of 2,443 total)