December 16, 2008 at 8:49 pm
david.c.holley (12/16/2008)
Been busy...For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not. Within that framework, the information that I provided would have been sufficient.
I'll be looking for a forum a bit more consistent with my prior experience so as not to waste your time. Thank you though for the code that was posted.
So sorry you think it is beneath you to put forth some effort when asking for help. There is nothing wrong with providing people with as much information and a framework to work with when asking for help. There have even been a few on this site that have solved their own problems just by going through the steps to provide a test suite for posting.
Sure, it took me an extra 30 minutes or so to create a table, and edit your data into a format that I could insert into my table. What is that time to you, absolutely nothing since it wasn't YOUR TIME doing it.
When individuals take the time to follow those guidelines, they get excellent help as well as TESTED code to work with.
December 17, 2008 at 3:40 am
david.c.holley (12/16/2008)
Been busy...For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not. Within that framework, the information that I provided would have been sufficient.
I'll be looking for a forum a bit more consistent with my prior experience so as not to waste your time. Thank you though for the code that was posted.
At which forum can you dump your simply copied output data and get a tested response at the same day? I've been at a few forums, and from my experience everybody have these same stringent rules. Maybe they don't ask for it as much as we do and just don't respond at all.
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
December 17, 2008 at 8:10 am
r.hensbergen (12/17/2008)
At which forum can you dump your simply copied output data and get a tested response at the same day? I've been at a few forums, and from my experience everybody have these same stringent rules. Maybe they don't ask for it as much as we do and just don't respond at all.
Yep, each of the forums I answer questions on have the same kind of article that Jeff made that describes how to create a post that will get answered. In the past I would do as Lynn did an write the table and waste my time creating an answer when I could be helping people who are a bit more willing to help themselves instead of waste my time posting a table of data that is in no way usable for creating a dataset to work off of.
Keep this in mind when you make an example on any forum. If you can at the end of the example you provide do a SELECT * FROM Table and get your data back in a tabular layout, you just told the people on the forums that your time is more important than theirs. If you feel this way, hire a consultant, that is what they do. They take whatever you give them, and provide whatever you want, no strings attached and no
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 17, 2008 at 8:29 am
david.c.holley (12/16/2008)
Within that framework, the information that I provided would have been sufficient.I'll be looking for a forum a bit more consistent with my prior experience so as not to waste your time.
david.c.holley (12/16/2008)
I am presented the data as it exists in the tables and as I need it displayed. Either help or don't bother.
Heh... sure... take that bit of arrogance, intended or not, on SQLTeam and other high profile forums and see the responses you get... they'll be even worse than what you've seen here. And, yes, most forums worth their salt have a "how to post data" standard.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2009 at 12:23 pm
For the record, while the project got shelved temporarily, once it starts up we'll be using a asp:repeater nested within another control to generate CSS which pivots the data as in (roughtly)
div
div style="float:left">Record 1/div
div style="float:left">Record 2/div
div style="float:left">Record 3/div
div style="float:left">Record 4/div
/div
We tested it and it works like a charm.
July 3, 2009 at 12:31 pm
Very cool... thanks for the feedback.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2009 at 2:42 pm
The fields in the parent table will be in the partent Repeater or Gridview with the childs nested if that's not obvious. It also lays the groundwork for the user to specify which of the child fields to display or omit which was a key requirement. We'll probably enforce each project having an identical set of child fields even though not all may be applicable. For example...
Project Start
Project End
Requirements Due
Feasibility Due
Executive Presentation
RFP Due
RFP Distribution Date
RFP Response Date
All of these will most likely be in a master table. The idea is to place a trigger on the parent table so that when a new project is added the records in the master table are automatically inserted into the child table. Deleting a record from the master might get tricky though.
July 3, 2009 at 2:56 pm
It'll be interesting what the performance is when you get this all done.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply