# Are the posted questions getting worse?

• Jeff Moden

SSC Guru

Points: 997364

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".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

• Jeff Moden

SSC Guru

Points: 997364

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".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

• Robert Sterbal

SSChampion

Points: 10995

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: 20587

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: 64836

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: 182523

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: 64836

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: 182523

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

• David Burrows

SSC Guru

Points: 64836

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.

• Phil Parkin

SSC Guru

Points: 244807

Eirikur, I've been waiting for what feels like years to see this write-up ðŸ™‚

I'd be happy to take a look at your draft, if you feel it would be helpful.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

• Eirikur Eiriksson

SSC Guru

Points: 182523

Phil Parkin wrote:

Eirikur, I've been waiting for what feels like years to see this write-up ðŸ™‚

I'd be happy to take a look at your draft, if you feel it would be helpful.

Just pinged you a PM Phil.

ðŸ˜Ž

Mesa Boogie? Never tried those, are you using a head amp or a stack? My self I'm into small, high distortion, sustain, anything like Pignose and upwards. What's your axe?

• Phil Parkin

SSC Guru

Points: 244807

Eirikur Eiriksson wrote:

Phil Parkin wrote:

Eirikur, I've been waiting for what feels like years to see this write-up ðŸ™‚

I'd be happy to take a look at your draft, if you feel it would be helpful.

Just pinged you a PM Phil.

ðŸ˜Ž

Mesa Boogie? Never tried those, are you using a head amp or a stack? My self I'm into small, high distortion, sustain, anything like Pignose and upwards. What's your axe?

Head + 2x12 speaker cab. Crystal clear on the clean channel, to full-on high gain on channels 2 and 3. Really a great amp. Having said that, I spend most of my playing time in front of a computer playing through a modeller (Line6 Helix). The neighbours appreciate that.

Guitars: Ibanez RG Prestige, Schecter Hellraiser. Plus a US Fender Strat, for those more mellow moments.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

• Eirikur Eiriksson

SSC Guru

Points: 182523

Phil Parkin wrote:

Eirikur Eiriksson wrote:

Phil Parkin wrote:

Eirikur, I've been waiting for what feels like years to see this write-up ðŸ™‚

I'd be happy to take a look at your draft, if you feel it would be helpful.

Just pinged you a PM Phil.

ðŸ˜Ž

Mesa Boogie? Never tried those, are you using a head amp or a stack? My self I'm into small, high distortion, sustain, anything like Pignose and upwards. What's your axe?

Head + 2x12 speaker cab. Crystal clear on the clean channel, to full-on high gain on channels 2 and 3. Really a great amp. Having said that, I spend most of my playing time in front of a computer playing through a modeller (Line6 Helix). The neighbours appreciate that.

Guitars: Ibanez RG Prestige, Schecter Hellraiser. Plus a US Fender Strat, for those more mellow moments.

Ibanez with DiMarzios?

;cool:

Kind of old school my self, used to have few Fenders and such, my axe of choice is

heavy as a rock and the sustain is just never ending, playing Parisian Walkaways without any effects ðŸ˜‰

• Phil Parkin

SSC Guru

Points: 244807

That is a thing of beauty!

I swapped out the stock pickups on the Ibanez for EMGs.

Here's my Strat.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

• Brandie Tarvin

SSC Guru

Points: 172766

Sooooooâ€¦ This is a weird one.

My coworker just set up a SQL Server (2019) and can't connect to it without the port number. IE, SeverName\InstanceName,1433. Oddly enough, I can connect to it with ServerName\InstanceName (no port). He's got Browser running on his desktop, and it can't be a UDP firewall block if I can connect to it.

We're scratching our heads on this one. Very odd.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 65,101 through 65,115 (of 65,230 total)

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