By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Access queries convert to sql server stored procedures???

P: 16
How would i convert or write a simple or complex access query to sql server stored procedures i will include my most complex query i hope somebody can help.

Thankyou in advance.

Expand|Select|Wrap|Line Numbers
  1. SELECT tblRiskCategory.RiskCategoryID, tblRiskCategory.RiskCategory, tblRiskReference.RiskRef, tblRiskReference.RiskDescription, tblCluster.ClusterID, tblCluster.Cluster, tblAPDescription.AP_ID, tblAPDescription.APName, tblAPDescription.APRef, tblBUReference.BUID, tblBUReference.BusinessUnit, tblProcessName.ProcessID, tblProcessName.ProcessName, tblApplication.Application_id, tblApplication.Application_Name, tblDB_Management_System.Db_Manage_id, tblDB_Management_System.Database_Management_System, tblOperating_System.Operating_System_id, tblOperating_System.Operating_System_Name, tblPhysical_Infrastructure.Physical_Infrastructure_id, tblPhysical_Infrastructure.Physical_Infrastructure_Filepath, tblNetwork_Infrastructure.Network_Infrasructure_id, tblNetwork_Infrastructure.Network_Infrastructure_Filepath, [tblRiskReference]![RiskRef] & ' ' & [tblRiskReference]![RiskDescription] & '' & [tblRiskCategory]![RiskCategory] AS CombinedFields
  2. FROM (tblRiskCategory INNER JOIN tblRiskReference ON tblRiskCategory.RiskCategoryID = tblRiskReference.RiskCategoryID) INNER JOIN (tblPhysical_Infrastructure RIGHT JOIN (tblOperating_System RIGHT JOIN (tblNetwork_Infrastructure RIGHT JOIN (tblDB_Management_System RIGHT JOIN (tblCluster INNER JOIN ((tblApplication RIGHT JOIN (tblBUReference INNER JOIN (tblMatrix LEFT JOIN tblProcessName ON tblMatrix.ProcessID = tblProcessName.ProcessID) ON tblBUReference.BUID = tblMatrix.BUID) ON tblApplication.Application_id = tblMatrix.App_id) INNER JOIN (tblAPDescription INNER JOIN tblAPRisksCombine ON tblAPDescription.AP_ID = tblAPRisksCombine.AP_ID) ON tblBUReference.BUID = tblAPRisksCombine.BUID) ON tblCluster.ClusterID = tblBUReference.ClusterID) ON tblDB_Management_System.Db_Manage_id = tblMatrix.DB_Manage_id) ON tblNetwork_Infrastructure.Network_Infrasructure_id = tblMatrix.Network_id) ON tblOperating_System.Operating_System_id = tblMatrix.OS_ID) ON tblPhysical_Infrastructure.Physical_Infrastructure_id = tblMatrix.Physical_id) ON tblRiskReference.RiskRef = tblAPRisksCombine.RiskRef
  3. ORDER BY tblRiskCategory.RiskCategoryID;
Jul 6 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
It sounds like you want your work done for you.

My advice, ask in the SQL Server forum for advice on how YOU can recode YOUR queries into T-SQL code. Learn what you need to do here, then go off and apply your new knowledge to your SQL.
Jul 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.