Search results for query: *

When you create your links to the SQL 2000 tables, rename the to what they were under SQL 7

Thanks Bygs What I'm trying to do is show all Injury Codes from luICD9 with a count of visits from tblInjury with corresponding date from tblvisit. I need the outer join because There are Injury codes that have no visits. Dennis

You could also use WHERE convert(Varchar(10),StatDate,101) = convert(Varchar(10),GetDate,101)

Here is a shortened version SELECT case when Diag_Code = 'BLAH' then 'BLAH BLAH' when Diag_Code = 'BAM' then 'BAM BAM' else 'Unknow' END as Cluster, COUNT(i.VisitID) AS Visits FROM (select visitid,Diag_Code from tblInjury inj, luICD9 icd where icd.Diag_Code *= inj.Injury_Code and...

The whole statement is huge. It has a very large case statement which in turn has a very large group by statement.

when attempting to query three tables with this from and where clause, FROM (select visitid,Diag_Code from tblInjury inj, luICD9 icd WHERE icd.Diag_Code *= inj.Injury_Code and icd.Diag_Code like 'E%')i, tblVisit v WHERE i.visitid = v.visitid I am receiving the following error. 'The...

Actually, what DrewConn says is not necessary. Once you have linked the SQL Server tables, you can change the name in Access to match you Access codes, providing you don't already have an existing Access table with the same name.