SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 How to get unmatched and duplicate rows
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sriguru4kunu
Starting Member

India
2 Posts

Posted - 03/28/2012 :  17:27:31  Show Profile  Reply with Quote
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:-

http://forums.asp.net/post/4904917.aspx

Thanks and Regards,
Sriguru Pattanayak

X002548
Not Just a Number

15586 Posts

Posted - 03/28/2012 :  17:59:00  Show Profile  Reply with Quote
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

India
2 Posts

Posted - 03/29/2012 :  08:11:34  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 03/29/2012 :  12:41:00  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000