September 18, 2008 at 7:28 am
When I attempt to cut and paste the sql code from this article to SQL Server Management Studio, the line feeds are all wrong. I don't see any links for downloading the plain text sql code.
September 18, 2008 at 7:36 am
First of all, what article? Secondly does the code run?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2008 at 7:39 am
http://www.sqlservercentral.com/articles/TSQL/62867/
Yes, the code runs great, when I take the time to add back the line feeds in the correct positons.
September 18, 2008 at 8:01 am
Since there are 15 code blocks in the article is there a specific one you are having a problem with?
SQL itself doesn't care about whitespace, so as long as you are getting a space the code should work.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 18, 2008 at 8:09 am
The very first one (and all). When I copy and paste into MS Word I can see that only about every 5th line is terminated by a CR LF the others are terminated by a text wrap break. This will not work in SSMgtStudio. I must first paste into word then copy from word and past into SSMgtStudio. THis works. sqlservercentral.com could easily make it much much easier to use their example code.
September 18, 2008 at 8:19 am
I'd sympathize, but I cut and paste them directly into SSMS and have no problems running the code. As far as SSC making it easier, it is actually the author's responsibility to attach any files that accompany the article. Since all the code it included in the article and this is the first I have heard of anyone having issues with copy and paste, most authors in this situation assume having the code in the article is sufficient. I know I think that way and maybe I should change that and include a .sql file.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply