Are the posted questions getting worse?
-
It's a half eaten pretzel balanced on top of 2 rolls of toilet paper. Not the worst ERD I've seen!
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
-
Now Steve, you just made me spill my coffee!
😎
-
Heh... all good guesses but... nope.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
If the symbols were the other way around it could be a graphic of a euphemism for falling over.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
Ok... one final set of hints...
If something goes wrong, they call the DBA and that's 24/7/365.
They also blame the DBA and the database for everything until the DBA can prove otherwise.
The top symbol is a body part that both men and women have. The thing that looks like a horizontal line is just exactly that.
And, of course the bottom symbol is the sign of infinity. There's a 7 letter word that begins with "F" that also means "infinity".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
My 15 yo brain is saying "ass/butt being divided infinity"...
- Jason A. Long wrote:
My 15 yo brain is saying "ass/butt being divided infinity"...
"semper in excretia, solum profundum variat"?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses - Jason A. Long wrote:
My 15 yo brain is saying "ass/butt being divided infinity"...
Jason, you're closer than you think.
- Jason A. Long wrote:
My 15 yo brain is saying "ass/butt being divided infinity"...
Like Ed said, you're closer than you think...
Rather than continuing to torture with trivia... the answer is...
"My ass is on the line forever". 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Jeff Moden wrote:Jason A. Long wrote:
My 15 yo brain is saying "ass/butt being divided infinity"...
Like Ed said, you're closer than you think...
Rather than continuing to torture with trivia... the answer is...
"My ass is on the line forever". 😀
I was thinking, “ass on the line...something”. I just could not get the infinity symbol to fit. I even thought, “my ass is always on the line” but thought it was a stretch.
The way you phrased it, it makes perfect sense.
-
I thought it was either your hair standing on end or on fire and your eyes bugging out from all of the RBAR.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. - Sergiy wrote:David Burrows wrote:Sergiy wrote:Robert Sterbal wrote:
In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.
built a report from an SQL database for a big international customer. The actual recipients of the report were their customers. So, the output was requested in the most common format - CSV.
Almost immediately they started complaining about incorrect account numbers in the report. Tirned out, 18 digit account numbers have been converted to float numbers while importing to Excel.
Can you suggest a workaround for this issue?
Apart from moving to Open Office?
Only way I know is to put apostrophe before the number, it will appear when the file is loaded in excel but at least it will not be converted.
that was the first thing I did - they were not quite satisfied.
Apostrophes had to be manually removed after importing, or all sorts of lookups they've been using would not work.
If you want a real wacky long winded way, create a 2003 XML Worksheet formatted file with .xls extension. They will get the usual excel data differs from extension prompt but least the data will load correctly formatted.
Far away is close at hand in the images of elsewhere.
Anon. -
I must have explained that issue (opening CSV in Excel rogers the underlying data) more than a thousand times.
Access solves the problem, but how many accountants use Access?
Viewing 15 posts - 65,071 through 65,085 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply