Can you transfer the database $ales to a SpreadSheet by EOD?

[preserver3.livejournal.com]

Yes, I can, but there's no computer on the network that can open a 90 GB XLS or 23.4GB CSV

It's a database, we have a DBAdmin, there's nothing you can do in Excel they can't do in SQL better.

Check that, there's nothing you can do that I can't do better with notepad, sqsh and vi.

Figure out what you want to do, write a query, or write an email asking a Developer other than a senior developer working on a deadline on something important to write it for you.

Update: "Select * from * where *=*" is not a valid sql query on our system.

Comments

[kingogre.livejournal.com]

When I was working at DHL... we had regular people who tried to import CSV files approximately that large into DHL's shipping software...

Was lots and LOTS of fail...

[jecook]

That's... a *lot* of packages. like an entire train's worth.

[benatwork.livejournal.com]

That's not unheard of. I used to work for a tiny wholesale company. So tiny, I was the shipping department, IT department, half the stock management, and guy who unclogged the toilets. We would still routinely fill UPS trucks at least one day out of the week. I can imagine a decent-sized mail-order place would do quite a bit more.

Shoot, just imagine what an Amazon hub's daily dispatch must look like. o.o

[sethb.livejournal.com]

A train is a mile or several long, which is a lot of trucks. UPS trucks are small trucks.