Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error applying TurboUnSchema932.sql #14

Open
roman-yagodin opened this issue Feb 12, 2021 · 1 comment
Open

Error applying TurboUnSchema932.sql #14

roman-yagodin opened this issue Feb 12, 2021 · 1 comment

Comments

@roman-yagodin
Copy link

roman-yagodin commented Feb 12, 2021

CREATE PROCEDURE dbo.[GetAllTabsModules]
--  get all tabmodules, which are added to any page
	@PortalID int, -- Not Null
	@AllTabs  bit  -- Not Null, get modules displayed on all pages or others?
AS
BEGIN
	 SELECT M.*
	 FROM dbo.[vw_ModulesOnTabs] M
	 JOIN (SELECT MIN(TabModuleID) MinTabModuleID
			FROM  dbo.[vw_ModuleTabs]
			WHERE isDeleted = 0
              AND PortalID  = @PortalID
			GROUP BY ModuleID) S
		WHERE M.AllTabs   = @allTabs
	 ORDER BY M.ModuleId;
END; -- PROCEDURE
GO

I believe what WHERE M.AllTabs = @allTabs should be ON M.AllTabs = @allTabs here.

@markmcavoy
Copy link

I'm getting the same error too, applying your change on the WHERE clause to be an ON clause does allow the script to run for me.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants