Previous Thread

8/7/2006 9:08:02 PM    SQL query doesn't work with SQL Server
Hi, 
 
I have got some errors while migrating Access to SQL Server Express 2005 via 
 
SSMA for Access. 
 
The following is the error 
 
Message: 
 
A2SS0058: SQL Server Migration Assistant for Access Error message: SQL 
 
statement is not supported. 
 
Description: 
 
SELECT PSQuery.FO_Order, Projects.Project_Name, Projects.PS_ID, 
 
Projects.[Project Code], Projects.Proj_ID, PSQuery.System_Name, 
 
PSQuery.PN_ID, Projects 
 
FROM (PSQuery INNER JOIN Projects ON PSQuery.PS_ID = Projects.PS_ID) INNER 
 
JOIN [CHW Job] ON Projects.J_ID = [CHW Job].J_ID 
 
GROUP BY PSQuery.FO_Order, Projects.Project_Name, Projects.PS_ID, 
 
Projects.[Project Code], Projects.Proj_ID, PSQuery.System_Name, 
 
PSQuery.PN_ID, Projects.J_ID, [CHW Job].Job_Name 
 
ORDER BY PSQuery.FO_Order, PSQuery.System_Name, PSQuery.PN_ID; 
 
Is there any way of getting this query to work in SQL Server? 
 
Thank you in advance 
 
It seems to me that i



8/8/2006 10:05:15 AM    Re: SQL query doesn't work with SQL Server
Queries migration support is so limited in this  release that I would say it 
 
actually does not exists. 
 
In 3 mouth (10/30) we will release a version that supports queries 
 
migration. 
 
"associates" <associates@discussions.microsoft.com> wrote in message 
 
news:5C02B377-C06F-4F5F-989D-943034828104@microsoft.com...