Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 How to get unmatched and duplicate rows

Author  Topic 

sriguru4kunu
Starting Member

2 Posts

Posted - 2012-03-28 : 17:27:31
Guys Please click the below link and solve the issue for me ASAP. the main topic is posted by me and it is a very good question too..

Link to the post:-

[url]http://forums.asp.net/post/4904917.aspx[/url]

Thanks and Regards,
Sriguru Pattanayak

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-28 : 17:59:00
So you want to enforce Primary Key Constraints against the sum of 2 tables?

Why not just have 1 table

I guess you could use triggers

OR

You could normalize your database



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

sriguru4kunu
Starting Member

2 Posts

Posted - 2012-03-29 : 08:11:34
Hi, Thanks for the suggestion. But I am really sorry to say you That I cant understand what u want to say. Yes I have one table where all data are inserted. But I need a query to accomplish My work. So please suggest me a good solution or a query as well as soon as possible.

Thanks and regards,
Sriguru Pattanayak




quote:
Originally posted by X002548

So you want to enforce Primary Key Constraints against the sum of 2 tables?

Why not just have 1 table

I guess you could use triggers

OR

You could normalize your database



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/






Thanks and Regards,
Sriguru Pattanayak
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-29 : 12:41:00
What part you didnt understand. I thought Brett is clear with his questions
Have you read about normalisation?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -