Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Looking for Ideas on how to Generate /Maintain 1000 page publication in Sql

คำตอบ Looking for Ideas on how to Generate /Maintain 1000 page publication in Sql

  • Thursday, March 01, 2012 4:31 PM
     
     
    Sign In to Vote
    0

    Hi

    I need to maintain a large publication that will be distributed on CD/DVD or Web

    It is currently a text file that is parsed and wrapped in html.

    This is a documents of parts where there are categories/ parts /desc / additiona info

    Was thinking of moving into a db to maintain. I was wondering if there are any examples similar to this out there that I can look at for ideas ?

    or possible suggestions on how to procede ?

    -Would need to maintain version/changes by year

    -Generate in Word/PDF and/or HTML for Web or some other HELP like document

    Data will look like

    ie

    Category 01

                  Part 01-001 Wigit for ENgine

                  This part 01-001 is associated with part 02-001 

                  Part 01-002 Wigit for ENgine

                  This part 01-002 is associated with part 02-002, part 01-001 

    etc

    Thanks

    • Moved by Tom Phillips Friday, March 02, 2012 2:09 PM Database Design question (From:SQL Server Database Engine)
    •  
     

All Replies

  • Thursday, March 01, 2012 8:55 PM
     
     Answered
    Sign In to Vote
    0

    Hi,

    You may take a look on the sample databases for SQL Server.

    I hope it helps.

    Janos

    There are 10 type of people. Those who understand binary and those who do not.
    My Blog

    • Marked As Answer by samoc Tuesday, March 06, 2012 1:16 PM
    •  
     
  • Friday, March 02, 2012 7:28 AM
    Answerer
     
     
    Sign In to Vote
    0

    Hi Samoc,

    You could refer to these similar threads for creating the Category table.

    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

     
  • Sunday, March 04, 2012 6:34 AM
    Answerer
     
     Answered
    Sign In to Vote
    0

    Ho many levels could be references part 02-004, part 01-003,part 02-002, part 01-001?????

    Take a look at hierarchy structure db design...

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    • Marked As Answer by samoc Tuesday, March 06, 2012 1:16 PM
    •