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 |
|
jfkennedy5
Starting Member
6 Posts |
 Posted - 2007-05-08 : 12:29:08
|
| Which way to go?Have two separate programs(Visual Studio-Coded in Visual Basic) that share the same sql 2005 database(called Night Audit)The tables are called RoomSettlement and Settlement.They were separate tables and separate programs in the past because it was just exported in excel to a visual integrator that dumped the amounts into our accounting software.Now needing to combine the two tables(that have no link) on to a single excel sheet daily where the tables have the same date:Table: Room Settlement – Field: RoomSettlementDatetxt =Table: Settlement – Field: SettlementDatetxtAny Ideas on the best way to go? (Link the tables with a foreign key and primary key, maybe union based on date, or any easier suggestion with out having to change a lot of the program ) Room Settlement TablePrimaryKey Availabilitytxt Ratetxt Othertxt Arrivalstxt departurestxt GuestCounttxt HotelOccupancytxt AverageDailyRatetxt RevPahrtxt HotelRevenuetxt ownerrentaltxt hoteltransienttxt hotelcorptxt hotelgovtxt hotelpacktxt hotelexpediatxt hotelsynxistxt hotelothertxt rentalpooltxt employeetxt Hotelnightstxt activitestxt Bonustxt Golftxt Tvinternettxt laundrytxt misctxt petstaytxt Telephonetxt Purchaseunittxt Damageincometxt resalerevtxt latefeestxt IntrestIncometxt Taxestxt RoomSettlementDatetxt sitetxt senddatetxt Settlement Table: PrimaryKey int UnPreviousGuesttxt TransferCityLedgertxt ActivityGuesttxt transferfromadvdepositguesttxt transfromguesttoguesttxt GuestchagefromInctxt Guestnetcashtxt Guestcheckstxt guestpaidout guestlockboxtxt guestaetxt GuestDinerstxt GuestDiscovertxt GuestMastercardtxt GuestVisatxt guestdepositchangecashtxt guestnetchangetxt guestnewbalancetxt guestsystembalancetxt guestvariance PreviousCity ActivityCitytxt Citynetcash Citychecks citypaidouttxt citylockboxtxt cityaetxt CityDinerstxt CityDiscovertxt CityMastercardtxt CityVisatxt citydepositchangecashtxt citynetchangetxt citynewbalancetxt citysystembalancetxt cityvariance Sitetxt DateStamptxt SettlementDatetxt Thanks JK |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Combing two tables with no relationship