Join dbo.clients u on u.logon_name = r.CREATED_USER (select ASSET_ID,T.pno,CREATED_DATE_UTC,CREATED_USER, MODIFIED_USER,u.EAL as EAL_Location,Įnd ) over (partition by ASSET_ID order by RDATE) next_status, RDATE, lead(RDATE) over (partition by ASSET_ID order by RDATE) next_datum from dbo.trim_request r However, I am getting this below error in Power BI.ĭataSource.Error: ODBC: ERROR ORA-00933: SQL command not properly ended I have this below query and it is working very well in SQL navigator. SQL Modeler dialog provides a fast means for creating the framework of a Select, Insert, Update, or Delete statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |