Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1314151617»»»

Forum Etiquette: How to post data/code on a forum to get the best help Expand / Collapse
Author
Message
Posted Monday, February 9, 2009 12:10 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
Olga B (2/9/2009)
I suspect it's because thinking through the problem is not the norm. ;)


BWAA-HAA!!! That's the perfect answer! Thanks for the feedback, Olga! :D


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #653101
Posted Monday, February 9, 2009 10:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:30 PM
Points: 104, Visits: 317
One problem I run into with these articles is only one inch of the code is visible at a time. Is there a way I can get more of the code to show without having to copy it and throw it into notepad?

Thanks!

Kay
Post #653411
Posted Tuesday, February 10, 2009 7:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
kbatta (2/9/2009)
One problem I run into with these articles is only one inch of the code is visible at a time. Is there a way I can get more of the code to show without having to copy it and throw it into notepad?

Thanks!

Kay


I don't know what the heck they've done to the forum recently, but I sent an email to the WebMaster alerting him to the problem.

In the meantime, the copy/paste to notepad or word is gonna have to do. Sorry about that.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #653665
Posted Wednesday, February 11, 2009 5:09 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,471, Visits: 1,402
I didn't got time to enter the forum in last few days, so I read this late. It was excellent explanation. First I thought it was something related about this forum. But as usual I glued to your article from start to finnish. No words to praise your writing...




Post #654672
Posted Wednesday, February 11, 2009 6:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
Thank you, Anirban. You're always gracious and kind with your words.

They republish this article about every two months or so to try and help folks with their posted questions so they can get better help quicker. Many of use keep a reference to this article in our signatures to make it easy to point out for people who come up a little short on a posted question.



--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #654704
Posted Thursday, May 28, 2009 12:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 6, 2013 5:34 AM
Points: 4, Visits: 31
I am trying to understand how to post data and table definitons.

I did read the article. Just having a bit of a problem understanding it.

I know how to export data out of SQL 2005 and generate table definitions.

Does this article apply to SQL 2005? Are these instructions a manual process? Or do I use my exported data and defintions?

I take it it is not as simple as using the upload process when am creating a post?

I must be a slow learner? Just doesn't seem clear to me.

Apreciate any assistance. I started a T-SQL question and wanted to clean it up.

Dave
Post #725341
Posted Thursday, May 28, 2009 1:17 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:44 AM
Points: 1,332, Visits: 19,320
It does apply to '05, and it's not really a manual process, if you write your SQL as Jeff suggests, e.g. ...
SELECT 'SELECT '      + QUOTENAME(ID,'''')+','      + QUOTENAME(DateValue,'''')+','      + QUOTENAME(Value,'''')+','      + QUOTENAME(YearValue,'''')+','      + QUOTENAME(MonthValue,'''')      + ' UNION ALL' FROM yourtable

... then you get your output already.

The manual part would be writing that script, and adding in the DDL for your table structure etc, but the end user only has to Execute, not reformat, your data to see exactly what your issues are.

I'm lazy, so I created a script that I can just copy/paste my SELECT into, update my column names, and let the system tables do the work of generating both the DDL and the data (attached)


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."


  Post Attachments 
Generate Test Data.txt (12 views, 6.76 KB)
Post #725382
Posted Tuesday, March 2, 2010 7:19 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 19, 2014 9:26 AM
Points: 312, Visits: 1,028
Great article, perhaps valid though for those who rely heavily on posts for answers to their issues..personally i dont post issues and of late, answers either. The reason mainly is that it takes an awful lot of time posting all the details of a problem, try putting in a support call with Microsoft for example and see how many details they ask for. Granted most people dont post right, on the other hand most people don't know how much of detail is enough. Sometimes you may miss a vital detail such as a version #. Answers are given for free and *assume* stuff all the time, somebody taking time to answer itself is doing you a favor and he/she does nto have to consider all involved before doing it. In short there are lots of limitations to this mechanism of getting information and while I think it is admirable to keep it up I also think you should take everything you read with a sack of salt before implementing especially on production.
Post #875134
Posted Wednesday, April 7, 2010 11:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 5, 2013 11:48 AM
Points: 8, Visits: 111
Hey,

I'm quite new to the forum and I greatly appreciate this article.
Much thanks for posting it.
Post #898786
Posted Wednesday, April 7, 2010 5:49 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 35,769, Visits: 32,437
nicholas.bazin (4/7/2010)
Hey,

I'm quite new to the forum and I greatly appreciate this article.
Much thanks for posting it.


You bet. Thanks for stopping by and thanks for the feedback.


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #899150
« Prev Topic | Next Topic »

Add to briefcase «««1314151617»»»

Permissions Expand / Collapse