View Single Post
  #2 (permalink)  
Old March 21st, 2007, 06:27 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:I have to compare the values of two fields called Name(nvarchar) in two different tables and then if they match (or contain something similar) I have to get the CompanyID of the Company table and check if this is already present in the CompanyCompare table...
What is the Relationship you have set between these two tables? Does CompanyCompare have NAME column in it? Or the CompanyID is the common column in both these tables?

Also where do you get the NAME and MAXVALUE from for the insert statement?
Code:
Insert into CompanyCompare (CompanyID, Name, MaxValue)
_________________________
- Vijay G
Strive for Perfection
Reply With Quote