|
In my current application I am getting an error "Cannot insert duplicate key row in object with unique index .\r\n51062\r\nThe statement has been terminated." while trying to run the command sqlCommand.ExecuteNonQuery();
Please advice me if anyone has any idea on this.
Thanks & Regards
Mishra
|
|
|
|
|
Well, the error message seems pretty clear to me.
You are trying to insert rows which have a duplicated key in your table/database.
Avoid doing that, or remove/change the key if you need duplicated values.
|
|
|
|
|
You allready got answer from error message.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
hi
how can i transfer database from Magic to SQL server ?
thanks
|
|
|
|
|
Maybe I am the only one who doesn't know it, but what is 'Magic'?
|
|
|
|
|
i have the Following Query, i would like to know how can i use Distinct from this Query based on Property_ID Field, but i dont the order of my Field to Change, because there are Duplicates.
SELECT REC_NO,LIS_KEY,FUNC_KEY,UNIT_NO,RIGHTS_ZONING,USE_CODE,OWNER,RATEABILITY,
EXCLUSION,MARKET_VALUE,EFFECTIVE_DATE,CATEGORY_CODE,SUPPLE_NUM,AREA,PROPERTY_ID,
OLD_MARKET_VALUE,VALUATION_ID,REASON,SORT_DATE
FROM SDE.EXPORT_OITPS_GV_TEST
GROUP BY REC_NO,LIS_KEY,FUNC_KEY,UNIT_NO,RIGHTS_ZONING,USE_CODE,OWNER,RATEABILITY,
EXCLUSION,MARKET_VALUE,EFFECTIVE_DATE,CATEGORY_CODE,SUPPLE_NUM,AREA,PROPERTY_ID,
OLD_MARKET_VALUE,VALUATION_ID,REASON,SORT_DATE
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Your question is not clear but you can Try this
SELECT REC_NO,LIS_KEY,FUNC_KEY,UNIT_NO,RIGHTS_ZONING,USE_CODE,OWNER,RATEABILITY, EXCLUSION,MARKET_VALUE,EFFECTIVE_DATE,CATEGORY_CODE,SUPPLE_NUM,AREA,min(PROPERTY_ID), OLD_MARKET_VALUE,VALUATION_ID,REASON,SORT_DATE
FROM SDE.EXPORT_OITPS_GV_TEST
GROUP BY PROPERTY_ID
Order By min(PROPERTY_ID)
or this
SELECT distinct REC_NO,LIS_KEY,FUNC_KEY,UNIT_NO,RIGHTS_ZONING,USE_CODE,OWNER,RATEABILITY, EXCLUSION,MARKET_VALUE,EFFECTIVE_DATE,CATEGORY_CODE,SUPPLE_NUM,AREA,PROPERTY_ID, OLD_MARKET_VALUE,VALUATION_ID,REASON,SORT_DATE
FROM SDE.EXPORT_OITPS_GV_TEST
Order By PROPERTY_ID
|
|
|
|
|
I'll try to describe my problem. I'm trying to make a program that will display online the articles that are on stock in our company. All these things have completely different properties, so they cannot be put in the same table.
Just to illustrate: Let's say I'm trying to combine apples, oranges, sports cars and rockets. First ones have sorts, cars have horse powers and gas engines and rockets... it doesn't matter. All these are articles/products.
I my case I'm talking about resistors, capacitors, CPU s, micro controllers, LCDs, aluminum boxes, light diodes, electronic units, etc. As you see all these should belong to different product categories and each category in a separate table.
And also this is my very database first project and it turned out to be much more complex than I've anticipated initially. I've searched a lot of DB examples but I cannot find any similar scenario.
Please give me an idea how to approach this problem! Is it possible to use the standard approach - product table - categories tables or such relation is impossible?
The only idea I have so far is to create different tables for each category and to keep them separated and the link between them to be on the application level and not on the SQL database level.
Thank you for reading all that! 
|
|
|
|
|
I think you're falling into the trap of trying to model the 'real world'. In software systems we don't model all the properties of the real-world objects we deal with, only those properties that are significant to the problem we're trying to solve.
In a retail system only a few things are significant: an identifier to uniquely identify this product, (commonly) a more user-friendly description, the price we plan to sell it at, and the level of stock we have. If you need to categorise, put a 'category' indicator on the product table.
Generally you shouldn't split up a logical collection of items into multiple tables. It becomes very hard to join them back together. If for any reason you actually do need to, for example if one category is queried much more heavily than others and it would benefit from being placed on a different disk, consider the database's partitioning support (if any). I believe it was possible to simulate partitioning efficiently in SQL Server 2000 but can't remember the details.
If you need to store additional information that won't be uniform across all items, consider nullable columns and using NULL where the value doesn't apply, or what I call 'extension tables' which are associated with the main, common, table in a one-to-one relationship, which stores only the extended information about this type of item.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Thank you! What I have in mind for example is the product browser of the website http://www.farnell.com This site is huge. Mine will be very small with not that many items (compared to Farnell) and with few users.
I have difficulty to accept the idea with NULLable columns yet, because because I might end with dozens and dozens if not hundreds of columns.
Thank you for the remark. A friend of mine also told me: "Forget about that OOP way of thinking". I'll think about my problem a little while longer.
|
|
|
|
|
You could have one table of Categories and another of CategoryProperties (multiple rows for each Category, containing CategoryId, Property Name and Value) - will that work for you?
|
|
|
|
|
I don't understand how to do that yet.
|
|
|
|
|
For example...
Table 1: Category
Fields: CategoryId (PK), CategoryName
Sample data:
1 Car
2 Apples
Table 2: CategoryProperties
Fields: CategoryId (FK), PropertyId (PK), PropertyName, PropertyValue
Sample data:
1 1 HorsePower 1500
2 2 Sort 10
Hopefully, the above clarifies my thought on this... don't know if it helps you.
|
|
|
|
|
Thank you! Interesting suggestion. I'll think about it. It could do the job!
|
|
|
|
|
Hi guys!
I am having a problem generating an overviewwith information from 3 different tables.
This is the situation:
There is a table (Users) with a list of all Users. These users can create their own groups and add users to these groups. So there are different groups with different users added to it for each user.
I have the following tables:
Users
user_id
user_name
data
1,Demo1
2,Demo2
3,Demo3
4,Demo4
5,Demo5
6,Demo5
Groups
group_id
group_user_id (Users.user_id who owns this group)
group_name
data
1,1,Design
2,1,Support
3,1,Sales
4,2,tmp_demo2
Groupmembers
groupmember_group_id (Groups.group_id)
groupmember_user_id (Users.user_id)
data
1,2
3,2
1,4
Now I want to generate an overview for a specific user (in this case: user_id #1), show ALL users in a list including their Groups.group_name if added to a group (created by user_id #1).
When using this query
SELECT Users.user_id, Users.user_name, Groups.group_name
FROM Users LEFT OUTER JOIN
Groupmembers ON Users.user_id = Groupmembers.groupmember_user_id LEFT OUTER JOIN
Groups ON Groupmembers.groupmember_group_id = Groups.group_id AND Groups.group_user_id = 1
I get the following data
1 demo1 Design
1 demo1 NULL
2 demo2 NULL
3 demo3 Support
4 demo4 NULL
5 demo5 NULL
6 demo6 NULL
Why do I get user_id #1 dubble? I guess it has something to do because user_id #1 had is added to two different groups, but form different users. I tried using DISTINCT, but no results. How can I generate a correct overview?
Thanks in advance!
|
|
|
|
|
What should display here ? Can you post your assuming results result ?
Can clarify on your result or requirement ?
Parwej Ahamad
R & D with IIS 5.0/6.0
|
|
|
|
|
1 demo1 Design
2 demo2 NULL
3 demo3 Support
4 demo4 NULL
5 demo5 NULL
6 demo6 NULL
This is what I would like to get:
- An overview of ALL users (not any double users)
- Name of the group the users are added to. BUT this group must be created by user_id #1 (in this case)
|
|
|
|
|
Hello all,
I have Typed-DataSet with 2 TableAdapters one for grades and one for courses.
The TableAddapters have relation, so when I use grade row I can get the parent row from a property:
foreach (DataSetCollege.GradesRow var in grades)
{
Response.Write( var.grade + var.CoursesRow.crsName);
}
My problem is that the var.CoursesRow is always null 
How do I use this property?
Thanks, Roy.
|
|
|
|
|
Hi,
It seems that courses TableAdapter is not getting populated therefore, please double check whether data is coming in TableAdapter or not.
Hope this helps
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
Hello Every one i have a problem ,i want to selct the all record from one table and get the limited recode from the other table and combine then with a query like
SELECT * FROM Personal p INNER JOIN DailyRecord dr ON p.pCODE = dr.pcode INNER JOIN Department dept ON p.deptid = dept.deptid where cast(CONVERT(datetime,dr.TIMEIN,105) as datetime) between cast('2008-06-05' as datetime) and cast('2008-06-05' as datetime)+1
when i run this query it only returns limited rows if i remove the last where condition then it gives me the whole table with joins but i want to get all data from pernal and the time in out from daily record if avlaible if not then its null in given dates
|
|
|
|
|
My guess is you are using the wrong join logic based on what I can deduct from your post.
Try using LEFT JOIN instead of INNER JOIN.
|
|
|
|
|
i am very thankfull for your replay i also used left join,left outer join but when its comes on where its only selct the limited like between these record and eleminate all other record
|
|
|
|
|
Move the content of the WHERE clause up on the relevant LEFT JOIN ON clause.
|
|
|
|
|
Does it make any performance benefit if we split our records across more tables instead of just one table ?
|
|
|
|
|
there could be... provided the database is hosted on raid and the tables are located in diffetent physical files.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
