Click here to Skip to main content
15,882,698 members
Home / Discussions / Database
   

Database

 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 4:54
perlmunger4-Nov-03 4:54 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi4-Nov-03 5:38
professionalJeff Varszegi4-Nov-03 5:38 
GeneralRe: Trouble Running Sql Script from Code Pin
perlmunger4-Nov-03 6:55
perlmunger4-Nov-03 6:55 
GeneralIdentity Seeds Pin
Colin Angus Mackay3-Nov-03 6:56
Colin Angus Mackay3-Nov-03 6:56 
GeneralHandling Disconnected Data In ADO.NET Pin
L Thomas3-Nov-03 5:10
L Thomas3-Nov-03 5:10 
Generalsql tables Pin
ranjjj31-Oct-03 3:14
ranjjj31-Oct-03 3:14 
GeneralRe: sql tables Pin
ranjjj31-Oct-03 3:18
ranjjj31-Oct-03 3:18 
GeneralDublication of rows Pin
Vaibhav Sanghavi30-Oct-03 22:15
Vaibhav Sanghavi30-Oct-03 22:15 
Hi All,

I am storing details of many hotels in a database. Details are coming from different providers. And we store it into our database.

Now sometimes, details about the same hotel come from different providers. And each provider may use different ID or name to refer a hotel. So when we enter this details we end up entering dublicate rows.

For example. Provider A give the details of InterContinental hotel and they refer the hotel with the ID "Inter". Provider B also give the detail of the same hotel but they refer that hotel with the ID "InterCon".

So after saving the details of InterContinental provided by the provider A when I store the detail given by provider B I need to make out that details of InterContinental is already stored and so I should not store it second time.

But as the IDs are different how do I make it sure. More over I dont have any other ID etc.

Can any one give me answere quickly.

Regards,
Vaibhav
GeneralRe: Dublication of rows Pin
Rahul Walavalkar3-Nov-03 2:54
Rahul Walavalkar3-Nov-03 2:54 
GeneralRe: Dublication of rows Pin
Vaibhav Sanghavi3-Nov-03 3:10
Vaibhav Sanghavi3-Nov-03 3:10 
GeneralSystem.Data.Sqlclient.TdsParser Pin
yyf30-Oct-03 9:27
yyf30-Oct-03 9:27 
GeneralConnectionString.Timeout Pin
yyf30-Oct-03 8:06
yyf30-Oct-03 8:06 
Generalsimple sample of ADO + Access + VC++ Pin
slomoman30-Oct-03 7:12
slomoman30-Oct-03 7:12 
Generaldate Pin
Anonymous30-Oct-03 6:30
Anonymous30-Oct-03 6:30 
GeneralRe: date Pin
andyharman3-Nov-03 11:26
professionalandyharman3-Nov-03 11:26 
GeneralIDbCommand.CommandTimeOut Pin
yyf30-Oct-03 4:21
yyf30-Oct-03 4:21 
GeneralRe: IDbCommand.CommandTimeOut Pin
Mike Dimmick30-Oct-03 4:59
Mike Dimmick30-Oct-03 4:59 
GeneralRe: IDbCommand.CommandTimeOut Pin
yyf30-Oct-03 8:07
yyf30-Oct-03 8:07 
QuestionProblem in connection string??? Pin
d meenakshi29-Oct-03 18:53
d meenakshi29-Oct-03 18:53 
GeneralRows Pin
Anonymous29-Oct-03 9:17
Anonymous29-Oct-03 9:17 
GeneralUpdate and select in same procedure with a dataadapter Pin
MrDanJordan29-Oct-03 5:49
MrDanJordan29-Oct-03 5:49 
GeneralHelp, why sql server is pending..... Pin
yyf29-Oct-03 4:09
yyf29-Oct-03 4:09 
GeneralRe: Help, why sql server is pending..... Pin
Jeff Varszegi3-Nov-03 15:07
professionalJeff Varszegi3-Nov-03 15:07 
Generalabout connection pooling Pin
yyf28-Oct-03 10:12
yyf28-Oct-03 10:12 
QuestionThe functions in ADO.NET are asynchronism or synchronism? Pin
yyf28-Oct-03 9:14
yyf28-Oct-03 9:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.