.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Foriegn key

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :ASP.Net
Hi All, In my databse i have a databse tablesUserRole -UserID,UserName,RoleName.Compaign - CompaignId,Region,CompaignName,LOB.Employee -EmpNo,EmpName,CompignIdTimesheet -TimeId,EmpNo,Date.I dont have primary key for Compaign Table CompaignId is Identity column.Now i want to use CompaignId in Employee Table because based on compaign user will retrieve employee data in Front end.Again Employee table doesn't have primary key.I am uploading excel file data to databse but in excel file there is no empNo so i cannot use primaryKey i have EmpName in excel file.How to solve this issue.How to use master table if possible create table structure for my requirements.Above are the tables.

View Complete Post

More Related Resource Links

foriegn key confliction with the dimension error


Hi  all ,  

I need  sujjestions  on ssis error ,

iam getting error while loading fact table with foriegn key conflict with dimension,i was unable to predict the cause of error ,

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend