Articles In More Than One Category - How To Organize Tables?
Jun 10, 2005
Greetings,I have one table, named Article, and one table name Category.The problem is, one Article could be in just one or in several categories.What is the best way to connect data between Article and Category according to fast search performance?I have several ideas:1. To have third cross table Article_Category with fields Article_ID and Category_ID, and search Article_Category table 2. To have several INTEGER columns in Article table (like Category_ID1, Category_ID2,..) and search those columns3. Add one VARCHAR field in Article table where I could write Category ID's delimited by some character (e.g. by comma), and do text search in only that column.What is recommended for solving problems like this?
View 7 Replies
ADVERTISEMENT
Jun 7, 2004
Hello,
i want to Select all articles form a category without an article that is selected.
Thanx a lot !
View 1 Replies
View Related
Feb 6, 2008
Hi,
I have information like this:
Apllicant information: Firstname, Lastname, Address, Phone, SSN, county, workphone..
Each applican can earn 3 certificates:
1st Certificate
2nd certificate
3rd certificate
Status of certification
Status of certification
Status of certification
Status of dues
Status of dues
Status of dues
Certification#
Certification#
Certification#
Validation date
Validation date
Validation date
Renewal date
Renewal date
Renewal date
Effective date
Effective date
Effective date
Date of cert # changed > means earned the next(second or third certificate).
These don€™t have this column information
These don€™t have this column information
Some common information for all 3 certificates like NOTE,€¦
How to organize the above information in SQLServer tables. how to apply the normalization . I can store all the contact information in one table and put the SSN as primary key. How to organize the certificates into tables? I have to made 3 tables for 3 certificates and linked to contact information table?
Thanks in advance
View 13 Replies
View Related
Feb 25, 2004
What are the thoughts on using a categoy table? What I mean by this is to have a table used to hold simply a category identifier for other table(s).
Eg:
Hardware Table
Hadware (PK) | Category (FK) | Description | Finish | etc....
------------------------------------------------------------------------------
P1 | Plate | 4"x4"x1/4 plate | Painted |
HardwareCategories
Category (PK)
-----------------
Plate
Channel
Angle
Should this be done or simply provide a category field in the hardware table? I like the extra table because it kind of ensures that a user doens't add a plate with a category value "Plate", another user adds "plate", and another user adds "Plates", etc....
What are your thoughts if any?
Mike B
View 1 Replies
View Related
May 26, 2015
We have restored a database on new server without keeping replication settings. Now while creating the publication no tables are shown in new publication wizard window. In fact we have hundred of tables in database and included in replication on source server from where backup was taken.
What may be the reason that tables are not appearing?
View 1 Replies
View Related
Jun 29, 2005
Hi,
I have a simple table:
Categories
----------
CategoryID
ParentID
Name
I want to associate my Products to a category so that I can search by category....ok. If I just have a simlpe table:
CategoryProducts
-------------------
CategoryId
ProductId
I can link a product to a category. Now, if I just link a product to a single category, such as the bottom leaf category:
Self Help / Personal Development / Spiritual / Meditation
I would link a product to the Meditation category. However if I
click on Self Help while browsing, I want to see all items underneath
Personal Development, Spiritual and Meditiation. So my question
is is this a good way to store the product-category relationships, or
should I put many entries into CategoryProducts to keep the queries
simlpe and faster? Are they faster doing it this way? In this way there
would be 4 entries for a product in meditation. My personal idea
is that adding all entries up a tree arm of a category path will be
cumbersome to manage, but it does solve the problem of clicking on Self
Help and seeing all products that exist within sub-categories. I
am sure an SQL query would be able to work this out, but I dont know if
performance would be something to consider on an ecommerce site? Are
there any patterns fo rthis stuff - seems a reasonably repeatable
pattern for business sites?
Thanks,
jr.
View 5 Replies
View Related
Jan 9, 2007
Hello,
This is more a informational question. Until now we had over 50 reports ready in our system, we are almost ready to go into production and are starting to link all reports with eachohter. The first problem was that we had them all nicely grouped in different projects so that we could publish in a logical folder-tree. Problem is that we can't jump to reports that are nog in the same folder. Going by url changes the layout and parts of the report manager are gone.
We then started to have a look at Sharepoint but i can't find books on the topic SharePoint & SSRS that describes the possible options. I've seen quite some documents and ways to publish reports but until now we prefer to mail the periodical reports to the users with data-driven subscriptions.
So at this moment we don't know quite wha direction to take. Putting all reports in one folder would solve many linking problems but makes it quite messy for the users.... And the linking issue is a must. As we now will start to create our dashboards with SSRS too.
So, any suggestions on what road to take or what publications to read are welcome.
Kind Regards
Harry
View 1 Replies
View Related
Feb 12, 2008
Hi,
I have data like this in Excel table:
ID GameScore1 GameScore2 GameScore3 ClassScore1 ClassScore2 Classscore3
10 10 20 27 5 35 23
I have to arrange like this in SQLServer table:
ID TestRecord GameScore ClassScore
10 1 10 5
10 2 20 35
10 3 27 23
Test Record 1 for score1, 2 for score2, 3 for Score3.
Which way to organize this data in SSIS?
Thanks in advance
View 10 Replies
View Related
Jan 21, 2008
I'm very new to SQL, so you'll have to excuse the nubishness of this question. I've got my trusty O'Reilly book here!
We're using Microsoft SQL Server 2005 on our web server. I'm currently working on a project to get a few MS Access Databases available on the web page.
The web part is actually working fine, with the DBs exported into SQL for performance reasons. (From what I've read pulling data from the .mdb file could cause me problems in the future, so I'm tossing it all onto the SQL server from the start.)
Before I get into the project full-tilt, though, I'm curious about how best to organize all the data?
I'm using the Upsizing Wizard in Access for the conversions, and every new DB gets added under Databases. If this gets approved I may be looking at well over a hundred DBs which will eventually be converted and made web accessible.
I can keep everything neat and tidy on the web server by just tossing things in a few directories, but the menu on the SQL Server Management Studio is going to become a mess really quickly if I let it just keep adding to +Databases.
Is there a way to sort everything into a series of folder/groups, like how System Databases has it?
Thanks in advance,
-Lamune
View 2 Replies
View Related
Jul 4, 2007
Hello,
I have DFTs with around 50 components and future ETLs will have 100+ components in DFTs.
I was wondering that is there anyway to group components like we have #region in C#.
Thanks,
Kapil
View 4 Replies
View Related
Jul 17, 2007
Hello,
I need some advice regarding organizing packages.
I am in starting phase of a data conversion project. As my ETL target, I have to produce around 70 flat files. I am creating one package for each target file. Some target files may be a result of 2-3 packages.
I have some common packages that get called from many other packages.
Before my solution tree grows into unmanageable state, I would like packages to get organized based on their target and purpose of the package.
The ideal solution to this problem would be to organize packages in a folder structure but I couldn€™t see any option to create folders in a solution.
I also noticed that we can€™t easily put package files next to each other even after renaming packages.
I was wondering is there a better or any way to organize packages in solution tree?
Kapil
View 1 Replies
View Related
Jul 23, 2005
Hello,i want to use toad to work with sql-Server for my business. But i cantget rid of it, after extracting the packets i find the toad ss.exe.I dont know how to connect to my database, as i never worked beforewith the odbc-database driver. I think it must be about the manager"start -> controls -> odbc...".All i want is to view the datasets in my db, but i dont want to writethe nesassery querys, like in mysql-admin for mysql databases.Is toad the right applikation or should i use an other manager?plz help me, thanks - xunling
View 1 Replies
View Related
Apr 21, 2015
Is there any way in which I could distinguish a group of Database users from the other users. Say for e.g. store the Database users hierarchically, etc. Adding a Prefix/Suffix to the user name as a distinguish-er will not work in my case. I want to restrict the deletion of these Database users. Even the login with sysadmin or serveradmin rights should not be able to DROP those Database users.
View 11 Replies
View Related
Sep 21, 2006
I used to do this with classic asp but I'm not sure how to do it with .net.Basically I would take a table of Categories, Then I would loop through those. Within each loop I would call another stored procedure to get each item in that Category. I'll try to explain, Lets say category 2 has a player Reggie Bush and a player Drew Brees, and category 5 has Michael Vick, but the other categories have no items.Just for an example.. Category Table: ID Category1 Saints2 Falcons3 Bucaneers4 Chargers5 FalconsPlayer Table:ID CategoryID Player News Player Last Updated1 1 Reggie Bush Poetry in motion 9/21/20062 1 Drew Brees What shoulder injury? 9/18/20063 5 Michael Vick Break a leg, seriously. 9/20/2006 Basically I would need to display on a page:SaintsReggie BushPoetry in MotionFalconsMichael VickBreak a leg, seriously.So that the Drew Brees update doesnt display, only the Reggie Bush one, which is the latest.I have my stored procedures put together to do this. I just don't know how to loop through and display it on a page. Right now I have two datareaders in the code behind but ideally something like this, I would think the code would go on the page itself, around the html.
View 1 Replies
View Related
Mar 11, 2015
How to write a Dynamic Pivot Statement to Calculate and Organize Columns like:
CREATE TABLE #mytable
(
Name varchar(50),
GA int,
GB int,
startdate DATETIME,
enddate DATETIME
[Code] ...
Below is Our Sample Table Data.
Name GAGBstartdateenddate
Pavan 261/1/20151/1/2015
Hema 561/1/20151/1/2015
Surya 501/1/20151/1/2015
Pavan 811/2/20151/8/2015
Hema 311/2/20151/8/2015
Surya 121/2/20151/8/2015
Pavan 1041/9/20151/15/2015
Hema 301/9/20151/15/2015
Surya 6131/9/20151/15/2015
How to write Pivot Satement to get Oupt like below:
1/1/2015 Pavan Hema Surya SumTotal
Total 8 11 5 24
GA 2 5 5 12
GB 6 6 0 12
1/8/2015 Pavan Hema Surya SumTotal
Total 9 4 3 16
GA 8 3 1 12
GB 1 1 2 4
1/15/2015 Pavan Hema Surya SumTotal
Total 14 3 19 36
GA 10 3 6 19
GB 4 0 13 17
View 5 Replies
View Related
May 11, 2006
hi all,
I was trying to set the articles to
"delete data in the existing table that matches the row filter"
in the publications "article>articles>table articles>snapshot" of
the publication
but everytime i reopen that property tab
the publication restore to the
default setting of "drop exisiting table and recreate it"
i"m using sql server 2000. snapshot replication--
thanks,
------------------------------------
joey
View 1 Replies
View Related
Apr 22, 2008
Hello,
maybe anyone knows good books or articles about ETL, ETL processes, ETL optimization ?
If you know where i can download - post a link
Thanks
View 4 Replies
View Related
Jun 19, 2007
Is there a way in T-SQL to programmatically list all the articles? What I'm wanting to do is grab these articles and run this SP:
EXEC sp_publication_validation 'people', @rowcount_only=2, @full_or_fast=0
For each aritcle/publication, but I need a way to programmatically calculate the 'people' article in this case and pass that information along to the sp_publication_validation SP.
Is there a way, perhaps in system tables or system SP to accomplish this?
Thanks,
Phil
View 3 Replies
View Related
May 30, 2006
I have a design that includes articles that will be searched. Obviously its too slow to put them into fields, and impossible because some have photos or are otherwise html documents. So I want to put pointers to their location.
Two questions. For each deployment, both desktop and web, where is the best place to put the articles. In any folder, or only in an iis virtual folder?
dennist685
View 5 Replies
View Related
Oct 25, 2007
Hello Everyonen and thanks for your help in advance. I am developing a conetnet management system to allow for the storage of articles within a SQL Server 2000 database. I am using FreeTextBox as the editor for users to enter articles. I ahve two questions. First, many of the articles are quite lengthy and including HTML formatting go well beyond 8000 characters. How should I go about storing these articles? Should I use a TEXT datatype, or perhaps split the data into more than one row. This leads to my second quuestion. Many sites that display article type data break the artilce into multiple pages with page numbers or next links to page back and forth. I am not sure hot to go about implmeneting this. Any help on this topic would be greatly appreciated. Thanks.
View 3 Replies
View Related
Jan 11, 2004
Hi every1,
Does anyone know where i would be able to find good articles on this subject:
-Best Practices (Logical - planning & Physical) in Setting up Database Projects for MSSQL Server 2000 with Visual Source Safe 6.0
*It would also be helpful if articles take replicated environments into consideration.
thankyou
View 3 Replies
View Related
Nov 4, 2006
Hi
where i can get good articles on indexes ?
View 2 Replies
View Related
Aug 13, 2015
I'm new to replication and set up a Snapshot Replication on the tables in my sample database. Â Everything seemed to work (database created on Subscriber instance, jobs set up, etc) but the articles (tables) are not being created in the subscriber's database. Â
I can see the files created in the folder but I don't see the tables or the data. Â Also, I confirmed that the articles are checked so they should be included.
View 6 Replies
View Related
Aug 7, 2007
Hello Friends
Can any body tell about the database jobs. what are the database jobs and how do they work.
If any body have any link relevant to it please send me as early as possible.
Thanks
SARB
View 1 Replies
View Related
Mar 12, 2008
I have a page which loads an article based on an ID, what i want to do now is when the article loads there will be a repeater control which holds headlines of related articles in it. My problem is how can i achieve this in terms of passing through the articleCategoryID to the stored procedure "stream_RelatedArticles".
This is my stored procedure that loads the initial article;
ALTER PROCEDURE [dbo].[stream_Articles]
as
SELECT TOP 5 articleID, articleTitle,articleDescription, articleAuthor,articleDatePublished,articleBody from Articles ORDER BY articleDatePublished
And this is the page_load;if (!IsPostBack)
{string strID = Request.QueryString["id"];
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString);SqlCommand command = new SqlCommand("stream_ArticlesByID", conn);
command.Parameters.Add("@articleID", SqlDbType.Int).Value = Request.QueryString["id"];command.CommandType = CommandType.StoredProcedure;
conn.Open();SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
ArticleList1.DataSource = reader;
ArticleList1.DataBind();
reader.Close();
}
And here is my related article stored procedure;ALTER PROCEDURE [dbo].[stream_RelatedArticles]@articleCategoryID INT
as
SELECT articleID,articleCategoryID, articleTitle,articleDescription, articleAuthor,articleDatePublished,articleBody from Articles
WHERE articleCategoryID = @articleCategoryID
View 6 Replies
View Related
Mar 4, 2004
Hey All - Another replication question:
Using VBScript in an ActiveX module of a DTS package...
Anyone have an idea how to add ALL articles to a Subscription.
The only way I can figure it is to load an array from sysobjects, then run sp_addarticle on each one.
Thanks for your help
RobbieD
View 2 Replies
View Related
Dec 12, 2005
Guys,
Do you have articles on this? this is for my reference.
thanks!
View 1 Replies
View Related
Sep 5, 2007
I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time.
This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped.
Has that functionality changed from 2000 to 2005? Am I not doing something right?
Thanks,
Amir
View 3 Replies
View Related
Sep 15, 2006
I wonder if anyone can advise, I currently have a replication set to 5 offices. Which has been working fine for some 18 months+, then the replication dropped out. When I looked in the publisher it had lost all its articles and would not allow me to add back in. I deleted the publication and recreated it and then after creating a new snapshot starting rolling back out to the various locations, and one of the locations failed and again all the articles where lost. I deleted and rebuilt the database at that office and went through the same routine again, only for it to happen again, the issue being that now errors where produced!!!.
So at present I have the publication and all the subscriptions running apart from this one office.
Has anyone had this before, or any ideas. I have run a full virus scan just in case and it was fine.
View 3 Replies
View Related
Oct 26, 2006
HelloI am using sql server 2005.I have two tables as described below.Table1UserID UserSales---------------------1 102 133 174 195 216 107 128 119 3110 2311 2412 1013 16Table2UserID Country----------------------1 Canada2 Canada3 Canada4 Canada5 Canada6 USA7 USA8 USA9 USA10 USA11 UK12 UK13 UKI want to get top 2 UserSales for each country and remaining should bedisplayed as Total as Others for that country.Can someone please help me with this query?RegardsAmit
View 1 Replies
View Related
Dec 19, 2005
Hello,
I have some articles already published and would like to change some of the articles default @conflict_retention of 14 days to 45 days. How can I accomplish this via t-sql? Thanks.
John
View 1 Replies
View Related
Dec 22, 2005
Let's say you a 1000 records in the Employees table, who are spread over 40 different cities.
How would you get a breakdown of how many employees in each city ?
Do I have to loop with a Count(*) for each CityID, or something ?
There must be a more straightforward method.
View 1 Replies
View Related
Mar 6, 2006
hi.
I have a table to store salesman's performance..
as you can see at structure.jpg, Tom sold total 18 Processors (5 different modals) and sold 11 mainboards (4 different modals)
I want to report that
what are the TOP 3 Processor and Mainboard modals that Tom sold with the same query
I tried different group by methods. also subqueries.
I could't do
you see the results I need at result.jpg
View 1 Replies
View Related
