MERGE INTO TBL_MenU b
USING (
SELECT TRANNAME,TRANID
FROM TBL_TRANS
) e
ON (b.MenuTEXT = e.TRANNAME)
WHEN MATCHED THEN
UPDATE SET b.MENUURL = CONCAT( 'GuideMain.aspx?TransId=', e.TRANID)
Subscribe to:
Post Comments (Atom)
-
Introduction The SAP .Net Connector is a software component supplied by SAP that makes it possible to communicate between an SAP host and ...
-
SSRS will often timeout when starting under Windows Server: The error is: Windows could not start the SQL Server Reporting Services (MS... -
Many times I found that the Reporting service is configured to access as "Anonymous Access", so any user having URL can access r...
No comments:
Post a Comment