October 6, 2020 at 3:45 pm
Wow. Just WOW!
--Jeff Moden
Change is inevitable... Change for the better is not.
October 6, 2020 at 3:53 pm
It's the fact that the spent £12 billion of tax payers money on that spreadsheet that really annoys me. Glad to know my money is going to worth while causes... -_-
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2020 at 3:55 pm
It's the fact that the spent £12 billion of tax payers money on that spreadsheet that really annoys me. Glad to know my money is going to worth while causes... -_-
I was seriously considering setting up a consultancy yesterday and offering my services to HM Gov at a fixed fee of £20m to set up a process using punched card, rolled up and attached to carrier pigeons.
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
October 6, 2020 at 4:07 pm
david.edwards 76768 wrote:I was seriously considering setting up a consultancy yesterday and offering my services to HM Gov at a fixed fee of £20m to set up a process using punched card, rolled up and attached to carrier pigeons.
JC has entered the building.
Ahh, so the solution will be written in COBOL.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2020 at 4:15 pm
Phil Parkin wrote:david.edwards 76768 wrote:I was seriously considering setting up a consultancy yesterday and offering my services to HM Gov at a fixed fee of £20m to set up a process using punched card, rolled up and attached to carrier pigeons.
JC has entered the building.
Ahh, so the solution will be written in COBOL.
I know nothing about COBOL or punched cards....... so that should be eminent qualifications for a government IT project 🙂
"Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it. When we enquire into any subject, the first thing we have to do is to know what books have treated of it. This leads us to look at catalogues, and at the backs of books in libraries."
— Samuel Johnson
I wonder, would the great Samuel Johnson have replaced that with "GIYF" now?
October 7, 2020 at 6:54 pm
Typical WYPIWYG, what you pay is what you get.
😎
The number of rows limitation just tells us that someone is using an old version of Excel, something that's probably no longer supported.
October 8, 2020 at 6:39 am
Neil Burton wrote:Typical WYPIWYG, what you pay is what you get.
😎
The number of rows limitation just tells us that someone is using an old version of Excel, something that's probably no longer supported.
Sadly not, Excel 2019 still only supports 1048576 rows. I suppose for many uses that's plenty but probably not for a national track and trace system.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
October 8, 2020 at 2:53 pm
Eirikur Eiriksson wrote:Neil Burton wrote:Typical WYPIWYG, what you pay is what you get.
😎
The number of rows limitation just tells us that someone is using an old version of Excel, something that's probably no longer supported.
Sadly not, Excel 2019 still only supports 1048576 rows. I suppose for many uses that's plenty but probably not for a national track and trace system.
I faced that issue at some point when trying to validate a file using Excel. But I remembered that it showed an error when trying to load a file with more rows than the supported ones. So I just tested by creating a 1.5 million rows csv, and it effectively shows a warning mentioning "File not loaded completely".
Excel has limitations, but this is a pure human error.
October 8, 2020 at 3:13 pm
Excel does have a row limit of 1048576 per tab, of course one can either use multiple tabs or even better, the tabular power query, which does not have any such limits.
😎
The problem in this case very simple, wrong tool for the job. Just like the story of the guy who had the lowest quote for constructing an airfield, based on few blokes with wheelbarrows.
October 8, 2020 at 3:40 pm
Couldn't see if it had been mentioned up thread, but I read that the problem was caused by running out of columns, not rows. Apparently each record was added as a column and not a row. If true, words really do fail me.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
October 8, 2020 at 4:26 pm
Some people like columns. I've run into some tables with high hundreds of columns, which astounds me.
October 8, 2020 at 9:06 pm
Some people like columns. I've run into some tables with high hundreds of columns, which astounds me.
how about a table with 498 columns which is updated daily. And updated in a very Interesting way. First, it’s dropped and recreated with only ID column populated with numbers and all others contain NULLs. Then 497 UPDATE statements populate the rest of the columns one by one.
Did not want to look into index structure because a) my hart is not g that young, and b) there was no point really. One-off indexes - is stupid enough. Still they recreated a bunch of indexes to be used in a report running once a day.
_____________
Code for TallyGenerator
Viewing 15 posts - 65,191 through 65,205 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply