Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 65,086 through 65,100 (of 66,815 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65144 More actions · Answer 1

Phil Parkin wrote:

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?

Was that aimed at me ?

Far away is close at hand in the images of elsewhere.
Anon.

Phil Parkin SSC Guru Points: 247180 More actions · Answer 2

David Burrows wrote:

Phil Parkin wrote:
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?
Was that aimed at me ?

Your post provoked the rant, but it wasn't 'aimed' at anyone.

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

Random frozen pork chop?

Do launchers require registration and a permit?

Does Anyone offer a safety class?

It seems injuries are rather rare. Or is this something the news ignores?

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 4

Greg Edwards-268690 wrote:

Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?

The news ignores it. It's easier to change the long standing names of parts of DNA. 😀

--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)

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 5

Greg Edwards-268690 wrote:

Random frozen pork chop?
Do launchers require registration and a permit?
Does Anyone offer a safety class?
It seems injuries are rather rare. Or is this something the news ignores?

Cannon's are legal in Massachusetts. I'd go with one of those over a launcher.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 6

Amazing!

Is there a guide for in flight cooking? Frozen, thawed, and properly cooked would be good to know.

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 7

Greg Edwards-268690 wrote:

Amazing!
Is there a guide for in flight cooking? Frozen, thawed, and properly cooked would be good to know.

The rules for in flight cooking are simple... Frozen only... it makes a better impact and allows for higher velocities because it moves through the barrel without sticking and the coldness also allows for a denser charge. 😀

--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 SSC Guru Points: 1004638 More actions · Answer 8

Speaking of pork chop cannons... here's one that needs about a 9 course dinner. I'll never understand such requests.

https://www.sqlservercentral.com/forums/topic/cutting-out-the-middleman-dba-how-to-give-access-without-involving-dba

--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)

Robert Sterbal SSChampion Points: 11067 More actions · Answer 9

Here is the macro I use in my personal.xlsb that eliminates the errors I get when pasting data from SSMS:

Sub SelectAllFormatAsText()

'

' SelectAllFormatAsText Macro

'

Cells.Select

Selection.NumberFormat = "@"

Range("A1").Select

End Sub

412-977-3526 call/text

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 10

Wow!

I could not resist. I would if they leave keys in the car, and the door unlocked.

I take that back - door open and running.

The other scenario would slow them down too much.

David Burrows SSC Guru Points: 65144 More actions · Answer 11

Phil Parkin wrote:

David Burrows wrote:
Phil Parkin wrote:
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?
Was that aimed at me ?
Your post provoked the rant, but it wasn't 'aimed' at anyone.

Just checking 🙂

Your rant is quite correct though, but Excel will not go away and one has to accommodate it's use. I do a lot of Excel import and export and regularly come across this type of problem. I either code round problems or get the end user to fix them.

Based on information from Eirikur I build a library to extract data from Excel without using Excel :-;

Far away is close at hand in the images of elsewhere.
Anon.

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 12

David Burrows wrote:

Phil Parkin wrote:
David Burrows wrote:
Phil Parkin wrote:
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?
Was that aimed at me ?
Your post provoked the rant, but it wasn't 'aimed' at anyone.
Just checking 🙂
Your rant is quite correct though, but Excel will not go away and one has to accommodate it's use. I do a lot of Excel import and export and regularly come across this type of problem. I either code round problems or get the end user to fix them.
Based on information from Eirikur I build a library to extract data from Excel without using Excel :-;

Now we are talking! Are you willing to share the library? Done extensive work on the subject and always interested in exploring alternatives.

😎

David Burrows SSC Guru Points: 65144 More actions · Answer 13

Eirikur Eiriksson wrote:

Now we are talking! Are you willing to share the library? Done extensive work on the subject and always interested in exploring alternatives.
😎

It is a .NET VB class library that unzips .xlsx file and deserializes the xml in to classes. It is very basic as all I needed was the data not the styling, but it does produce worksheets with rows, columns and cells.

Far away is close at hand in the images of elsewhere.
Anon.

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 14

David Burrows wrote:

Eirikur Eiriksson wrote:
Now we are talking! Are you willing to share the library? Done extensive work on the subject and always interested in exploring alternatives.
😎
It is a .NET VB class library that unzips .xlsx file and deserializes the xml in to classes. It is very basic as all I needed was the data not the styling, but it does produce worksheets with rows, columns and cells.
Unfortunately in my contract at work, everything I create is covered by intellectual property rights and copyright, so I will have to check.

I've used a similar approach for the last few years, instead of .Net I'm using 7zip command line for the unzipping of the .xlsx files, works fine and has saved me thousands of hours of work.

😎

If you are interested, I'll ping you a draft of the writeup, mind you that this the first draft so few bits are missing, very interested to see your feedback on it.

A question, how did you resolve the column mapping?

Edit: Added a question

This reply was modified 5 years ago by Eirikur Eiriksson.

David Burrows SSC Guru Points: 65144 More actions · Answer 15

Eirikur Eiriksson wrote:

If you are interested, I'll ping you a draft of the writeup, mind you that this the first draft so few bits are missing, very interested to see your feedback on it.

Yes please, would be very interested.

Eirikur Eiriksson wrote:

A question, how did you resolve the column mapping?

I convert cell references to column indexes and use Dimension for the upper bound, is this what you mean.

Far away is close at hand in the images of elsewhere.
Anon.