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 |
|
jamie123
Starting Member
15 Posts |
 Posted - 2009-06-08 : 19:38:50
|
| "The multi-part identifier ElectronicClaim.ExamDate could not be bound"I am getting that error when creating an SQL statement in the dataset designer with this code:INSERT ElectronicClaim (PatientNumber, ExamDate, PatientName)SELECT Insurance2.[SPatient Number], Insurance2.Date, Insurance2.[Patient's Name]FROM Insurance2WHERE CAST(FLOOR(CAST( Insurance2.Date AS float)) AS datetime) > CAST(FLOOR(CAST( ElectronicClaim.ExamDate AS float)) AS datetime)I have two tables, ElectronicClaim and Insurance2. I need to select an array of data from Insurance2 where the Date is greater than the ExamDate of ElectronicClaim. ElectronicClaim is the child and Insurance2 is the parent. I'm sure what I'm doing is just a trivial mistake, please let me know if I need to provide any additional info.Thank you! |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-06-08 : 19:45:38
|
| You need to include [ElectronicClaim] in your FROM clase. So you 'll need to JOIN those two tablesBe One with the OptimizerTG |
 |
|
|
|
|
|
multi part identifier could not be bound