Are the posted questions getting worse?
-
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
Good grief...the spammers are out in force today.Reported as spam
Sweet!!! Maybe I can get banned!?!?!?!?!
It's Friday, you can get anything you like 🙂
I would be happy with a beer!!!
Come on over! We have beer - and the boss has just opened a fine Rioja 🙂
I think maybe I will stay here. One of the guys in the office brought me a bottle of this today. http://www.boulevard.com/BoulevardBeers/dark-truth-stout/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
Good grief...the spammers are out in force today.Reported as spam
Sweet!!! Maybe I can get banned!?!?!?!?!
It's Friday, you can get anything you like 🙂
I would be happy with a beer!!!
Come on over! We have beer - and the boss has just opened a fine Rioja 🙂
*Taking the next flight*
-
Ray K (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
ChrisM@Work (7/29/2016)
Sean Lange (7/29/2016)
Good grief...the spammers are out in force today.Reported as spam
Sweet!!! Maybe I can get banned!?!?!?!?!
It's Friday, you can get anything you like 🙂
(in his best Arlo Guthrie voice) "at Alice's Restaurant..."
That was my first thought.
-
Why is Californian rosé all so sweet now? I used to be able to get a reasonable dry Californian rosé back in the late 90s when I was often in Menlo Park and in the mid 00s on the rare occassions I was in in LA, and I could find good dry Californain rosé in the shops in Britain from when I discovered it in California (in 1996) until a few years ago, but now it all seems to be at best medium, there's nothing dry from California in the shops here any more; so I'm now buying French, Spanish or Italian rosé for Ann (who wants dry or very dry) instead of Californian.
Tom
-
Feel free to pitch in, someone not having a great day😀
😎
-
Eirikur Eiriksson (7/31/2016)
Feel free to pitch in, someone not having a great day😀😎
I think you already nailed it in your very first reply, but the OP either misunderstood or didn't want to hear. I tried to explain the same issue in other words. We'll see if he now understands.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ -
Hugo Kornelis (7/31/2016)
Eirikur Eiriksson (7/31/2016)
Feel free to pitch in, someone not having a great day😀😎
I think you already nailed it in your very first reply, but the OP either misunderstood or didn't want to hear. I tried to explain the same issue in other words. We'll see if he now understands.
Thanks Hugo, very good input.
😎
-
djj (7/26/2016)
ZZartin (7/26/2016)
Phil Parkin (7/26/2016)
ChrisM@Work (7/26/2016)
BrainDonor (7/26/2016)
Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.One day I would like to meet these people, but only if I have full immunity from prosecution.
Very well put, Steve.
If you like I'll hold 'em down whilst you perform the surgery.
This is one team I'd like to be a part of.
If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.
I would really like to have a discussion with the
geniustool bag who thought scientific notation was the appropriate format for large strings of numbers :angry:I wonder how many hours are wasted each year forcing excel to open documents like that properly and explaining to less technical people that excel just mangled their data with no warning.
Hey, who needs leading zeros, and who needs a 16 digit number with the 16th digit anyway? Even with the CSV file has double quotes around the number.
I spend way too much time trying to convince people that sending data as an Excel spreadsheet is a bad idea.
I was on vacation last week and have been catching up on the thread. If you're looking to put together a team to beat the "Excel knows best" team, count me in. I also spend a lot of time dealing with the pain it causes, but it seems people don't want to ship data any other way.
-
djj (7/28/2016)
Ray K (7/28/2016)
Brandie Tarvin (7/28/2016)
Jeff Moden (7/28/2016)
Alan.B (7/28/2016)
Lynn Pettis (7/28/2016)
Brandie Tarvin (7/28/2016)
ChrisM@Work (7/28/2016)
BrainDonor (7/28/2016)
I would like to know why they even bother.How many people out there are going to think "I could do with a new kitchen, where should I look? I know - SQL Server Central - the one-stop shop for all of my kitchen needs."
And of course it will be the first place I look when I want sports supplements too - it caters for everybody.
Look on the bright side - nice new cupboards to store all those big containers of whey powder.
Wait. Are you saying that the kitchen isn't where database servers are supposed to live?
Gosh darnit! Now I have to redesign my home office. Where do I put it? The bathroom?
Actually, try Hillary's basement. It was good enough for her. < ducks quickly >
Haha. ... and set the password to "p@ssword"
Totally insecure... It should be "p@55w0rd". :-P:-P:-P:sick:
What is the problem here? Don't you two know that a truly secure password is 12345?
HONESTLY! Some people!
That's the same code that's on my luggage!
Funny, you don't look Druish
Heh - That's assuming she even had a password. Email yes, server??? 😛
-
Ed Wagner (8/1/2016)
djj (7/26/2016)
ZZartin (7/26/2016)
Phil Parkin (7/26/2016)
ChrisM@Work (7/26/2016)
BrainDonor (7/26/2016)
Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.One day I would like to meet these people, but only if I have full immunity from prosecution.
Very well put, Steve.
If you like I'll hold 'em down whilst you perform the surgery.
This is one team I'd like to be a part of.
If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.
I would really like to have a discussion with the
geniustool bag who thought scientific notation was the appropriate format for large strings of numbers :angry:I wonder how many hours are wasted each year forcing excel to open documents like that properly and explaining to less technical people that excel just mangled their data with no warning.
Hey, who needs leading zeros, and who needs a 16 digit number with the 16th digit anyway? Even with the CSV file has double quotes around the number.
I spend way too much time trying to convince people that sending data as an Excel spreadsheet is a bad idea.
I was on vacation last week and have been catching up on the thread. If you're looking to put together a team to beat the "Excel knows best" team, count me in. I also spend a lot of time dealing with the pain it causes, but it seems people don't want to ship data any other way.
My #1 Excel tip when working with data... immediately after opening / creating the worksheet, while still blank... highlight everything and select "Format as Text". After loading your data, then change the necessary columns back to general or to an otherwise appropriate data type (numeric, percent, date, etc.)
Sure, this way has it's problems... but it also solves many.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2 -
Gone for a week and come back to find you guys talking about Excel. Looking around now for talking apes and an exploded statue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
-
Grant Fritchey (8/1/2016)
Gone for a week and come back to find you guys talking about Excel. Looking around now for talking apes and an exploded statue.The monkeys werer blown to shreds when the statue exploded. After we loaded all the debris into Excel, it got automatically reformatted as an email address, which then disapppeared without a trace in the spam filter.
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/ -
WayneS (8/1/2016)
Ed Wagner (8/1/2016)
djj (7/26/2016)
ZZartin (7/26/2016)
Phil Parkin (7/26/2016)
ChrisM@Work (7/26/2016)
BrainDonor (7/26/2016)
Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.One day I would like to meet these people, but only if I have full immunity from prosecution.
Very well put, Steve.
If you like I'll hold 'em down whilst you perform the surgery.
This is one team I'd like to be a part of.
If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.
I would really like to have a discussion with the
geniustool bag who thought scientific notation was the appropriate format for large strings of numbers :angry:I wonder how many hours are wasted each year forcing excel to open documents like that properly and explaining to less technical people that excel just mangled their data with no warning.
Hey, who needs leading zeros, and who needs a 16 digit number with the 16th digit anyway? Even with the CSV file has double quotes around the number.
I spend way too much time trying to convince people that sending data as an Excel spreadsheet is a bad idea.
I was on vacation last week and have been catching up on the thread. If you're looking to put together a team to beat the "Excel knows best" team, count me in. I also spend a lot of time dealing with the pain it causes, but it seems people don't want to ship data any other way.
My #1 Excel tip when working with data... immediately after opening / creating the worksheet, while still blank... highlight everything and select "Format as Text". After loading your data, then change the necessary columns back to general or to an otherwise appropriate data type (numeric, percent, date, etc.)
Sure, this way has it's problems... but it also solves many.
My #1 tip for Excel: Use Access
Ducks and Runs:-D:-D:-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
SQLRNNR (8/1/2016)
My #1 tip for Excel: Use AccessBring back QUATTRO, all is forgiven!
Tom
Viewing 15 posts - 55,141 through 55,155 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply