June 22, 2017 at 2:59 pm
Well, my new job has been keeping my very busy, so I haven't had much time to come here, and even less time to post.
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
June 23, 2017 at 6:52 am
Is anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every time I post SQL or a dataset. Especially as the text in the post reply box isn't a truetype font, so I have to guess where the alignments are meant to be and then scroll down to the preview pane to check (and try again if i guessed wrong). 🙁
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 6:57 am
Thom A - Friday, June 23, 2017 6:52 AMIs anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every time I post SQL or a dataset. Especially as the text in the post reply box isn't a truetype font, so I have to guess where the alignments are meant to be and then scroll down to the preview pane to check (and try again if i guessed wrong). 🙁
You're definitely not the only one. I try to do the same thing and get it, but it takes a few tries and I sometimes just give up before getting it 100% fixed.
My post reply box is a truetype font, so it's sometimes difficult. It might look fine as I paste it, but text within the code tags displays differently with a truetype font.
June 23, 2017 at 7:42 am
Thom A - Friday, June 23, 2017 6:52 AMIs anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every time I post SQL or a dataset. Especially as the text in the post reply box isn't a truetype font, so I have to guess where the alignments are meant to be and then scroll down to the preview pane to check (and try again if i guessed wrong). 🙁
Happens every single time. And yes, it's frustrating.
"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
June 23, 2017 at 8:58 am
Grant Fritchey - Friday, June 23, 2017 7:42 AMThom A - Friday, June 23, 2017 6:52 AMIs anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every time I post SQL or a dataset. Especially as the text in the post reply box isn't a truetype font, so I have to guess where the alignments are meant to be and then scroll down to the preview pane to check (and try again if i guessed wrong). 🙁Happens every single time. And yes, it's frustrating.
There's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2017 at 9:06 am
Jeff Moden - Friday, June 23, 2017 8:58 AMThere's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
Tried that, no effect. SSMS -> notepad -> SSC gives the exact same problem as SSMS -> SSC.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 23, 2017 at 9:09 am
Jeff Moden - Friday, June 23, 2017 8:58 AMGrant Fritchey - Friday, June 23, 2017 7:42 AMThom A - Friday, June 23, 2017 6:52 AMIs anyone other than myself still having problems when pasting to SSC? I'm getting a little "fed up" with having to realign my text in the post reply box every time I post SQL or a dataset. Especially as the text in the post reply box isn't a truetype font, so I have to guess where the alignments are meant to be and then scroll down to the preview pane to check (and try again if i guessed wrong). 🙁Happens every single time. And yes, it's frustrating.
There's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
The forum will still mess up some of that formatting, notably alignment.
This query, for example (I already use a fixed-width font, Consolas, in SSMS, so the result is the same whether I copy into Notepad first or not):
SELECT *
FROM sys.databases d
INNER JOIN
msdb.dbo.backupset bs ON d.name=bs.database_name
;
Both in SSMS and in Notepad, it looks like this, which took some fiddling here:
SELECT *
FROM sys.databases d
INNER JOIN
msdb.dbo.backupset bs ON d.name=bs.database_name
;
It doesn't seem to matter whether I use tabs or spaces, alignment never quite matches once it's in code tags here.
Cheers!
June 23, 2017 at 9:27 am
Thom A - Friday, June 23, 2017 9:06 AMJeff Moden - Friday, June 23, 2017 8:58 AMThere's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
Tried that, no effect. SSMS -> notepad -> SSC gives the exact same problem as SSMS -> SSC.
I don't know what to say except that it works perfectly for me.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 23, 2017 at 10:07 am
Jeff Moden - Friday, June 23, 2017 9:27 AMThom A - Friday, June 23, 2017 9:06 AMJeff Moden - Friday, June 23, 2017 8:58 AMThere's a work-around for this although it won't help the very poor color-mix that occurs (they had this right for a long time... they should simply revisit that code to make it right again).
The work around is to copy your well-formatted code from SSMS into NotePad. The copy from NotePad into the SQL Code IF Code and the format will be nicely preserved. It also makes it a whole lot easier for others to copy your code from an SQL Code block.
Tried that, no effect. SSMS -> notepad -> SSC gives the exact same problem as SSMS -> SSC.
I don't know what to say except that it works perfectly for me.
Isn't that always the case, "It works on my machine." 😀
June 23, 2017 at 10:45 am
This thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 23, 2017 at 10:53 am
Phil Parkin - Friday, June 23, 2017 10:45 AMThis thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.
Yeah, I don't get it either. If the advice provided here were a paid service, then I might (even then, only might) understand.
As it stands the OP requested help on a free community forum, and a couple posts were not direct attempts to answer the OP's questions, but were instead an interaction between two of the contributors.
I'm with you...I don't get the ruffled feathers.
June 23, 2017 at 11:21 am
Jacob Wilkins - Friday, June 23, 2017 10:53 AMPhil Parkin - Friday, June 23, 2017 10:45 AMThis thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.Yeah, I don't get it either. If the advice provided here were a paid service, then I might (even then, only might) understand.
As it stands the OP requested help on a free community forum, and a couple posts were not direct attempts to answer the OP's questions, but were instead an interaction between two of the contributors.
I'm with you...I don't get the ruffled feathers.
Been here a while, not sure why the OP got upset. Looked like a normal day on the forums to me. If the OP doesn't like it they are welcome to go elsewhere for help.
June 23, 2017 at 12:03 pm
Jacob Wilkins - Friday, June 23, 2017 10:53 AMPhil Parkin - Friday, June 23, 2017 10:45 AMThis thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.Yeah, I don't get it either. If the advice provided here were a paid service, then I might (even then, only might) understand.
As it stands the OP requested help on a free community forum, and a couple posts were not direct attempts to answer the OP's questions, but were instead an interaction between two of the contributors.
I'm with you...I don't get the ruffled feathers.
I saw this originally, and started to give him the answer, and stopped when I realized he was looking for an SSIS answer.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 23, 2017 at 12:22 pm
Lynn Pettis - Friday, June 23, 2017 11:21 AMJacob Wilkins - Friday, June 23, 2017 10:53 AMPhil Parkin - Friday, June 23, 2017 10:45 AMThis thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.Yeah, I don't get it either. If the advice provided here were a paid service, then I might (even then, only might) understand.
As it stands the OP requested help on a free community forum, and a couple posts were not direct attempts to answer the OP's questions, but were instead an interaction between two of the contributors.
I'm with you...I don't get the ruffled feathers.
Been here a while, not sure why the OP got upset. Looked like a normal day on the forums to me. If the OP doesn't like it they are welcome to go elsewhere for help.
I don't get it either. I meant it as a compliment to Phil, but it somehow was a distraction to the OP. I read it a could more times to make sure I wasn't off my rocker (I know...separate issue 😛) and I didn't see the problem with it. I appreciate the feedback here because it lets me know the post wasn't seen as weird by others. Thank you for it.
June 23, 2017 at 12:52 pm
Ed Wagner - Friday, June 23, 2017 12:22 PMLynn Pettis - Friday, June 23, 2017 11:21 AMJacob Wilkins - Friday, June 23, 2017 10:53 AMPhil Parkin - Friday, June 23, 2017 10:45 AMThis thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.Yeah, I don't get it either. If the advice provided here were a paid service, then I might (even then, only might) understand.
As it stands the OP requested help on a free community forum, and a couple posts were not direct attempts to answer the OP's questions, but were instead an interaction between two of the contributors.
I'm with you...I don't get the ruffled feathers.
Been here a while, not sure why the OP got upset. Looked like a normal day on the forums to me. If the OP doesn't like it they are welcome to go elsewhere for help.
I don't get it either. I meant it as a compliment to Phil, but it somehow was a distraction to the OP. I read it a could more times to make sure I wasn't off my rocker (I know...separate issue 😛) and I didn't see the problem with it. I appreciate the feedback here because it lets me know the post wasn't seen as weird by others. Thank you for it.
There is certainly some weirdness in that thread...and it all came from the OP. They clearly do not understand what spam is. Was your comment relevant as part of the answer, NO. But is it just your normal day to day banter between regulars seen on this and every other forum ever, YES. If your comment bothered that person they need to grow some thicker skin quick, this industry is far too intense to get that worked up about nothing.
_______________________________________________________________
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/
Viewing 15 posts - 58,996 through 59,010 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply