Software Applications Programming Errors and solutions.

Getting Below Power BI Report connection error during execution . Error: Something went wrong Unable to connect to the data source undefined. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: Business Sector. Underlying error message: AnalysisServices: A connection cannot be made. Ensure that the server is running. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.DataSourceKind: AnalysisServices Microsoft.Data.Mashup.ValueError.DataSourcePath: 10.10.10.60;T_CustomerMaster_ST Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: c72c4f12-8c27-475f-b576-a539dd81826a Request ID: dfb54166-c78f-4b40-779f-e8922a6687ad Time: 2019-09-26 10:03:29Z Solution: We found report connection not able to connect to SQL Analysis service so tried below option. Re

How to select particular day date from given month in SQL. You can see below example to get some ideas. select dates,to(char(dates,'day-mon-yyyy') from (select to_date(:start_date,'dd-mon-yyyy')+rownum -1 as dates from all_objects where rownum<=to_date(:end_date,'dd-mon-yyyy')- to_date(:start_date,'dd-mon-yyyy')+1) where upper(regexp_substr(to_char(dates,'day-mon-yyyy'),'([[:alpha:]])+'))=upper(:day_name); 02-JUN-17 FRIDAY 09-JUN-17 FRIDAY 16-JUN-17 FRIDAY 23-JUN-17 FRIDAY 30-JUN-17 FRIDAY 07-JUL-17 FRIDAY 14-JUL-17 FRIDAY 21-JUL-17 FRIDAY 28-JUL-17 FRIDAY 04-AUG-17 FRIDAY 11-AUG-17 FRIDAY 18-AUG-17 FRIDAY 25-AUG-17 FRIDAY 01-SEP-17 FRIDAY

To separate string from email id in SQL you can try below query. seperate ' test' '@' 'xyz'   ' com'   from test@xyz.com SELECT SUBSTR(mailID, 1, INSTR(mailID, '@', 1, 1)-1) String1, SUBSTR(mailID, INSTR(mailID, '@', 1, 1), 1) String2, SUBSTR(mailID, INSTR(mailID, '@', 1, 1)+1, INSTR(mailID, '.', 1, 1)-INSTR(mailID, '@', 1, 1)-1) String3, SUBSTR(mailID, INSTR(mailID, '.', 1, 1)+1) String4 FROM ( SELECT '&MailID' mailID FROM Dual );

To write query second highest salary in for Employee in SQL there are many way to achieve this I am sharing here some sample examples. Select * from(select deptno,sal,dense_rank() over (partition by deptno order by sal desc)r from emp) where r=2 select empno,ename,sal,deptno, row_number() over(partition by deptno order by sal desc)rn from emp )select * from cte where rn=2 Select max(sal)from emp  Where sal <(select max(sal) from emp) Select deptno, max(salary) from(Select a.deptno,a.salary from employee a, (Select deptno,max(salary) from employee group by deptno) b where a.deptno=b.deptno And a.salary<b.salary) group by deptno;

To get Last 10 records from SQL table you can get idea from below example. You can try that by rounum condition. select * from emp minus select * from emp where rownum<=(select count(*)-10 from emp); or you can try this also. select * from ( select * from emp  order by empno desc) where rownum<=10

The question is How get middle name from full name column in SQL Table? Full name can be like this. Santosh kumar singh Raj Narayan verma Middle name is Kumar and Narayan etc. Solution. Use instr to get the position of first space and second space.use substr to get the string from first space +1 to 2nd space - 1. I hope you will get solution. Example.  Using substr function it will get the result of middle names. Substr(colname,instr(colname, ' ', 1,1),instr(colname,' ' , -1,1))

Getting below Error during Code Upgrade Ax 2012 from R2 to R3 . Can you suggest to resolve these errors. Description The first enabled data source(ProjForecastEmplView_1) in union query cannot have disabled field(Qty). Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Duty DOCommerceOnlineSalesOrdersMaintain does not exist. The first enabled data source(RetailTransactionTable_1) in union query cannot have disabled field(transactionId). Menu item RETAILLOYALTYMSRCARDTRANS does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item RETAILLOYALTYCUSTTABLE does not exist. Menu item InventAging_CN does not exist. Menu item RETAILLOYALTYMSRCARDTRANS does not exist. The class 'FormRun' does not contain the method 'isRetailAttribute'. The RetailPricingEngine::setRetailDiscountsOnOrder method is obsolete. Use method calculateIndependentPriceDiscounts in