Search Results

Search found 7417 results on 297 pages for 'customer relationship'.

Page 150/297 | < Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >

• SQL query to get most

  - by chama

  I have a database with the following tables: Employee (EmpID, FirstName, LastName, RegionID) EmployeeSkills(EmpID, SkillID) [this is a linking table for the M:N relationship between Employees and skills] Skills(SkillID, Description) I need to list the name of the skill that most employees have. I tried doing a max(count(skillID)), sqlserver said that you can't do an aggregate function on an aggregate function. Any other ideas? Thank you in advance!

  Read the article

• Is it good practice to model to-one relationships in only one direction? Or must they be modeled in

  - by dontWatchMyProfile

  In Core Data, most of the time relationships are modeled bidirectional. But the docs say in another place: It typically only makes sense to model a to-one relationship in one direction.

  Read the article

• Is there some tool to visualize Java class hierarchies and relations?

  - by Niyaz

  Here is my problem: I will provide the source code of my application as input and what I want as output is a visual representation of the relationship between classes, method calls etc. Is there some tool to do this?

  Read the article

• How to describe a contained map in UML class diagram?

  - by gooli

  I have a MyServer class that contains a Map whose keys are MyClientType objects and whose values are MyClient objects. I'd like to depict this relationship in a class diagram but I can't figure out a clean way to do that.

  Read the article

• JPA - How to persist java.util.Set through JPA?

  - by Yatendra Goel

  I have a field aliases of type java.util.Set in one Entity. This Set doesn't denote any relationship to an Entity. Q1. How can I store this aliases field through JPA? Q2. How this field get stored in database? I think that for the database, this field is a multi-valued attribute.

  Read the article

• many-to-many mapping in NHibernate

  - by Chris Stewart

  I'm looking to create a many to many relationship using NHibernate. I'm not sure how to map these in the XML files. I have not created the classes yet, but they will just be basic POCOs. Tables Person personId name Competency competencyId title Person_x_Competency personId competencyId Would I essentially create a List in each POCO for the other class? Then map those somehow using the NHibernate configuration files?

  Read the article

• Question on different ways to link tables

  - by dotnetdev

  What is the difference between linking two tables and then the PK is an FK in the other table, but the FK has not got the primary key option (so it does not have the gold key), and having the PK in one table as a PK in another table? Am I right to think that the second option is for a many-to-many relationship? Thanks

  Read the article

• Grails many to many using a third 'join' class

  - by andy mccullough

  I read that a m:m relationship often means there is a third class that isn't yet required. So I have m:m on User and Project, and I created a third domain class, ProjectMembership The three domains are as follows (minimized for illustration purposes): User class User { String name static hasMany = [projectMemberships : ProjectMembership] } Project Membership class ProjectMembership { static constraints = { } static belongsTo = [user:User, project:Project] } Project: class Project { String name static hasMany = [projectMemberships : ProjectMembership] static constraints = { } } If I have the ID of the user, how can I get a list of Project objects that they are assigned to?

  Read the article

• How do I map to a parent or child in the same table with NHibernate?

  - by adolfojp

  Lets suppose that I have a Category table with a column that holds the id of a parent or child category from the same table. This design would allow me to have unlimited levels of Categories, or unlimited levels in a thread, for example. How can I map this relationship with NHibernate? Are there any disadvantages or warnings that I should take into consideration when doing this?

  Read the article

• Is it good practice to have foreign keys in a datawarehouse (relationships)?

  - by Lieven Cardoen

  I think the question is clear enough. Some of the columns in my datawarehouse table could have a relationship to a primary key. But is it good practice? It is denormalized, so it should never be deleted again (data in datawarehouse). Hope question is somewhat clear enough.

  Read the article

• Is it bad OOP practice to have objects reference each other?

  - by lala

  Pardon my noobness. I'm making a game in which several characters have relationships with each other and they need to be able to interact with each other and store some relationship data regarding how they feel about each other. I have an object for each character. Is it bad for each of those character objects to have an array of all the other character objects in order to perform these interactions? Is there a better way to do this?

  Read the article

• Disable automatic index on related object id from yml

  - by BugBusterX

  Doctrine Automatically creates indexes on columns that are used to define object relations, For example user: id, name message: id, sender_id, receiver_id, message if I define relationship between message and user in a way that message has one Sender and has one Receiver, doctrine will automatically index sender_id and receiver_id fields when I generate sql from model. I would like to disable index on sender, because I manually create index with sender_id and receiver id together. How can I disable auto generated index?

  Read the article

• Core Data - Best way to save a "number of items"

  - by Daniel Granger

  The user will have a static list of items to choose from. Using a Picker View they will choose one of the items and then select how many of them they want. Whats the best way to save this in core data? A Struct? struct order { NSInteger item; NSInteger numberOf; }; Or some sort of relationship? Many Thanks

  Read the article

• OrderBy on children in a LINQ Query

  - by eka808

  Hello everybody I have a user entity who contains a one to many relationship with a role entity So with this linq expression : from user in USER_TABLE.Include("USERROLE_TABLE") order by user.Name select user I can get users with related roles as a child. My problem is that i want to get roles of each user ordered alphabetically. How can i do that ? I googled a lot and don't find anything Thank's by advance !

  Read the article

• Which kind of changes can't I do with lightweight migration in Core Data?

  - by dontWatchMyProfile

  I recently tried a lot of different stuff with lightweight migration. These all work: 1) Rename attributes (with renaming identifier specified) 2) Add attributes 3) Add new entity + new attribute + inverse relationship to an already existing entity 4) remove existing entity + relationships to that entity = It almost looks like just about anything can be handled with LM. Did I miss something? In which cases am I getting into trouble and need an some more complex approach?

  Read the article

• When should carry flag be set in assembly language.

  - by Summer_More_More_Tea

  Hi everyone: I'm puzzled by this problem when writting an ARM assembly simulator in C. I've found some similar questions in the forum, but none of them explain how to set the carry flag just using the relationship between two operands and the result. Any reply is appreciated. Thanks in advance. Regard.

  Read the article

• Database design

  - by Hadad

  Hello, I've a system, that have two types of users (Companies and individuals).all types have a shared set of properties but they differ in another. What is the best design merge all in one table that allows null for unmatched properties, or separate them in two tables related to a basic table with a one to one relationship. Thanks.

  Read the article

• MySQL One to Many order by number found in joined table

  - by Finbarr

  Two tables: table_a ------- table_a_id: (primary, int) table_b ------- table_a_id: (index, int, from table_a) table_b_value: (varchar) A one to many relationship between table_a_id and table_b_value. Given a query like this: SELECT DISTINCT(table_a_id) FROM table_a JOIN table_b ON table_a.table_a_id=table_b.table_a_id I want to order by the number of occurrences of table_a_id in table_b. I'm not really sure how to write this in MySQL.

  Read the article

• rails, accepts_nested and has_many :through is creating duplicate entries

  - by Sam

  Hi, I have a store model that has many products with a has_many :through relationship. I have this working with accepts_nested_attributes, but the result is that rails is making duplicate associates. I don't have anything special going on it is a very simple app. Any ideas on why duplicates associates are getting created?

  Read the article

• Does Doctrine 1.2 support importing indexes with Doctrine_Core::generateModelsFromDb function?

  - by Coagulant

  Does Doctrine 1.2 support importing indexes with Doctrine_Core::generateModelsFromDb() function? I need to make a migration between 2 database connections, one of them having unique index on 2 fields and one doesn't. And my migration is empty. It looks like Doctrine doesn't support indexes when importing from databae, other than those tied to relationship foreign keys. $changes = Doctrine_Core::generateMigrationsFromDiff($migrationsPath, array('doctrineOld'), array('doctrine'));

  Read the article

• Hibernate subclass with foreign key relationships

  - by shikarishambu

  I need some help defining the following object hierarchy/ database relationship in Hibernate From the object sense – Agent is inherited from Person and Agency is inherited from Organization. they are inherited from Party which can have multiple Addresses associated with it The database consists of Agent - ID - Name -PartyID (references Party.ID) Agency -ID -Name -PartyID (references Party.ID) Address -AddrID -PartyID (references Party.ID) -Street Party. -PartyID

  Read the article

• What's -mutableSetValueForKey: returning, actually? Is that something special?

  - by dontWatchMyProfile

  From the docs: You usually access to-many relationships using mutableSetValueForKey:, which returns a proxy object that both mutates the relationship and sends appropriate key-value observing notifications for you. So this returns an "intelligent" NSMutableSet which automatically lets the context delete objects when they get deleted from the set, and reverse? Is that a proxy object?

  Read the article

• nonparametric regression method using R

  - by user1782652

  I need to find the certain driver variables for unit sales & their impact on sales. My data is such data the error does not follow normal distribution & the unit sales is also not following any particular statistical distribution. Given such condition, it is difficult for me to use simple liner regression or GLM. Can any of you please suggest me some non parametric regression technique which I can use in R to model the relationship? Thanks,

  Read the article

• Erro while join table in SQL

  - by Color Shadow

  I have two tables that have relationship with UserName field. Based on UserName column, I want to get ID from CarReserve table. Here is my SQL statement: SELECT CarReserve.ID FROM CarReserve INNER JOIN aspnet_Users ON CarReserve.UserName = aspnet_Users.UserName WHERE UserName = @UserName Unfortunately, I am getting this warning: Ambiguous column name "UserName" Can anyone here tell me what is wrong with my statement?

  Read the article

• Is this possible in sql server 2005?

  - by chandru_cp

  This is my queries select ClientName,ClientMobNo from Clients select DriverName,DriverMobNo from Drivers It gives me two result tables... But i want to combine both the result tables into a single table... I tried union and union all it doesn't give me what i want.... Note: There is no relationship between the two tables...... There may be 200 clients and 100 drivers...

  Read the article

< Previous Page | 146 147 148 149 150 151 152 153 154 155 156 157  | Next Page >