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.
| 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 |
|
|
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 Pattanayakquote:
Originally posted by X002548
So you want to enforce Primary Key Constraints against the sum of 2 tables?Why not just have 1 tableI guess you could use triggersORYou could normalize your databaseBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxWant to help yourself?http://msdn.microsoft.com/en-us/library/ms130214.aspxhttp://weblogs.sqlteam.com/brettk/http://brettkaiser.blogspot.com/
Thanks and Regards,Sriguru Pattanayak |
 |
|
|
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 questionsHave you read about normalisation?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to get unmatched and duplicate rows