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

Visio 2010 (Multiple Editions) with Service Pack 1 Visio 2013 Professional Visio 2013 Service Pack 1 Visio Professional 2016 Visio Professional 2019 Visio Standard 2013 Visio Standard 2016 Visio Standard 2019 Visio Tools SDK and DDKs Visual Basic .NET 2003 Visual Basic 2.0 Visual Basic 2.0 Professional Visual Basic 2.0 Standard Visual Basic 3.0 Professional Visual Basic 4.0 Visual Basic 6.0 Code Advisor Visual Basic 6.0 Enterprise Visual Basic for Applications Visual C++ 1.52 Visual C++ 2.0 Visual C++ 2010 Redistributable Package Visual C++ 2010 Service Pack 1 Redistributable Package Visual C++ 2015 Redistributable Visual C++ 2015 Redistributable Update 3 Visual C++ 4.2 Enterprise Visual C++ Browser Toolkit Visual C++ Build Tools 2015 Update 2 Visual C++ Build Tools 2015 Update 3 Visual C++ Redistributable for Visual Studio 2012 Visual C++ Redistributable for Visual Studio 2012 Update 3 Visual C++ Redistributable for Visual Studio 2012 Update 4 Visual C+

Windows 10 (business edition), version 1803 (updated Aug 2018) Windows 10 (business edition), version 1803 (updated Sept 2018) Windows 10 (business editions), version 1803 (updated April 2019) Windows 10 (business editions), version 1803 (updated Jan 2019) Windows 10 (business editions), version 1803 (updated July 2018) Windows 10 (business editions), version 1803 (updated July 2019) Windows 10 (business editions), version 1803 (updated June 2019) Windows 10 (business editions), version 1803 (updated March 2018) Windows 10 (business editions), version 1803 (updated March 2019) Windows 10 (business editions), version 1803 (updated May 2019) Windows 10 (business editions), version 1809 (updated April 2019) Windows 10 (business editions), version 1809 (updated Dec 2018) Windows 10 (business editions), version 1809 (updated Feb 2019) Windows 10 (business editions), version 1809 (updated Jan 2019) Windows 10 (business editions), version 1809 (updated July 2019) Windows 10 (b

Office 2003 Professional Office 2003 Professional Enterprise Office 2003 Proofing Tools Office 2003 SDK and DDKs Office 2003 Service Pack Office 2003 Standard Office 2007 Enterprise Office 2007 Language Pack Office 2007 Professional Office 2007 Professional Plus Office 2007 Proofing Tools Office 2007 SDK Office 2007 Service Pack Office 2007 Standard Office 2007 Ultimate Office 2010 Language Pack Office 2010 Proofing Tools Office 2010 Service Pack 1 Office 2010 Service Pack 2 Office 2013 Language Pack Office 2013 Language Pack with Service Pack 1 Office 365 Office 95 Professional Office Accounting 2007 SDK Office Accounting Express Office Accounting Professional Office Accounting Service Pack Office Communications Server 2007 Enterprise Office Communications Server 2007 R2 Enterprise Office Communications Server 2007 R2 Standard Office Communications Server 2007 Standard Office Communicator 2005 Office Communicator 2007 Office Communicator 2007 R2 Offi

Kinect for Windows Developer Toolkit v1.6 Kinect for Windows Developer Toolkit v1.7 Kinect for Windows Developer Toolkit v1.8 Kinect for Windows SDK 11.0 Language Pack Kinect for Windows SDK 2.0 Kinect for Windows SDK 2.0 Language Pack Kinect for Windows SDK v1.0 Kinect for Windows SDK v1.5 Kinect for Windows SDK v1.5.0 Kinect for Windows SDK v1.5.1 Kinect for Windows SDK v1.6 Kinect for Windows SDK v1.7 Kinect for Windows SDK v1.8

GP 10.0 GP 10.0 SDK GP 10.0 Service Pack GP 7.5 GP 7.5 SDK and DDKs GP 7.5 Service Pack GP 8.0 GP 8.0 Service Pack GP 9.0 GP 9.0 SDK GP 9.0 Service Pack

Forefront Client Security Forefront Endpoint Protection 2010 Forefront Exchange Server Service Pack Forefront Identity Manager 2010 Forefront Identity Manager 2010 Language Pack Forefront Identity Manager 2010 R2 Forefront Identity Manager 2010 R2 SP1 Forefront Protection 2010 for Exchange Server Forefront Protection 2010 for SharePoint Forefront Security Management Console Forefront Security, Office Communications Server Forefront SharePoint Service Pack Forefront Threat Management Gateway 2010 Enterprise Forefront Threat Management Gateway 2010 Standard Forefront Unified Access Gateway 2010

Expression 1 Blend Expression 1 Service Pack Expression 1 Studio Expression 1 Web Expression 2 Blend Expression 2 Design Expression 2 Encoder Expression 2 Media Expression 2 Studio Expression 2 Web Expression 3 Studio Expression 3 Studio (Plus WebsiteSpark Level) Expression Blend 2 Service Pack 2 Expression Blend 3 Service Pack 1 Expression Blend 4 Service Pack 3 Expression Studio 4 Premium Expression Studio 4 Ultimate

Exchange 2003 Enterprise Exchange 2003 Service Pack Exchange 2003 Standard Exchange Server 2007 Enterprise Exchange Server 2007 SDK Exchange Server 2007 Service Pack (Trial Only) Exchange Server 2007 Standard Exchange Server 2010 Exchange Server 2010 Service Pack 1 Exchange Server 2010 Service Pack 2 Exchange Server 2010 Service Pack 3 Exchange Server 2013 Exchange Server 2013 with Service Pack 1 Exchange Server 2016 Exchange Server 2019 Cumulative Update 2

BizTalk Server 2002 Developer BizTalk Server 2004 Developer BizTalk Server 2004 Enterprise BizTalk Server 2004 Partner BizTalk Server 2004 Service Pack BizTalk Server 2004 Standard BizTalk Server 2006 Accelerators and Adapters BizTalk Server 2006 Developer BizTalk Server 2006 Enterprise BizTalk Server 2006 R2 Accelerators and Adapters BizTalk Server 2006 R2 Branch BizTalk Server 2006 R2 Developer BizTalk Server 2006 R2 Enterprise BizTalk Server 2006 R2 Standard BizTalk Server 2006 Standard BizTalk Server 2009 Branch BizTalk Server 2009 Developer BizTalk Server 2009 Enterprise BizTalk Server 2009 RFID BizTalk Server 2009 Standard BizTalk Server 2010 Branch BizTalk Server 2010 Developer BizTalk Server 2010 Enterprise BizTalk Server 2010 RFID BizTalk Server 2010 Standard BizTalk Server 2013 Branch Edition BizTalk Server 2013 Developer Edition BizTalk Server 2013 Enterprise Edition BizTalk Server 2013 R2 Branch Edition BizTalk Server 2013 R2 Developer Edition

 Visual Studio 2012  Visual Studio 2012 Update 2  Visual Studio 2012 Update 3  Visual Studio 2012 Update 4  Visual Studio 2012 with Update 1  Visual Studio 2013  Visual Studio 2013 Update 2  Visual Studio 2013 Update 3  Visual Studio 2013 Update 4  Visual Studio 2013 Update 5  Visual Studio 2015  Visual Studio 2015 Update 3  Visual Studio 2015 with Update 1  Visual Studio 2017 (version 15.0)  Visual Studio 2017 (version 15.9)  Visual Studio 2019 (version 16.0)  Visual Studio 2019 (version 16.2)

2001-10 MSDN Library October 2005-07 MSDN Library July 2006-01 MSDN Library January 2006-05 MSDN Library May 2006-06 MSDN Library June 2006-07 MSDN Library July 2006-08 MSDN Library August 2006-12 MSDN Library December Team Edition 2007-01 MSDN Library January Team Edition 2007-04 MSDN Library April 2007-06 MSDN Library June

.NET Compact Framework 1.0 Developer Redistributable .NET Compact Framework 1.0 Redistributable .NET Compact Framework 2.0 .NET Compact Framework 2.0 Service Pack .NET Framework 1.0 SDK and DDKs .NET Framework 1.0 Service Pack .NET Framework 1.1 SDK and DDKs .NET Framework 1.1 Service Pack .NET Framework 2.0 SDK and DDKs .NET Framework 2.0 Service Pack .NET Framework 3.5 .NET Framework 3.5 Service Pack .NET Framework 4 .NET Framework 4 Client Profile .NET Framework 4 Full .NET Framework 4.5 .NET Framework 4.5.1 .NET Framework 4.6 .NET Framework 4.6.1 .NET Framework 4.6.2 .NET Framework Redistributable 1.0 .NET Framework Redistributable 2.0 .NET Framework Redistributable 3.0 .NET Micro Framework Porting Kit .NET Micro Framework SDK and DDKs

What is the difference between programmer and software developers Answer programming is a phase in software development. A developer that program a software. Programmers focus on the physics and the logic of the app/game. While software developers do almost everything from graphics design, sound design, and the code. A software developer is a programmer that uses the knowledge of programming to build programs/software. A programmer is to a scientist as a developer is to an engineer. Programmer is the one who write only the code(program)and software developer is the one who use to do documentation,program and procedures. Software is a series of programs. - Program is just a logic in a software. - Software developer is someone that uses a programmer(him as one or another person) as one of his tools to accomplish his goal( finished software). - Programmer is either a software developer or a tool in a software developers tools. The difference is real programmers do not giv

To Write a PL SQL code for reverse digits of given number at run time you can use below code.

You can learn  Microsoft Paint and 3D paint faster after watching this video. I hope you will like share and subscribe this video to get more updates, English version video. Hindi Version Video.

Below clip will show you English basic grammar learning start from Tenses in Hindi language. I hope you will like share and subscribe this channel . To get more video in list visit below playlist. English basics and Grammar Learning online easy way in Hindi

SQL injection (SQLi) is a type of attack in which a hacker can take advantage of the insecure SQL query a web application makes to a database server (such as MySQL, Microsoft SQL Server and Oracle). It exploits weaknesses in a web application that are usually the result of poor development practices or mistakes. SQL injections are among the oldest, most prevalent and dangerous web application vulnerabilities. Since SQL injections affect web applications that make use of an SQL database, virtually every type of web application needs to pay attention to it. By abusing an SQL injection vulnerability, an attacker may be able to bypass a web application’s authentication and authorization mechanisms, retrieve the contents of an entire database, and even add, modify and delete records  in that database, impacting its data integrity.

Please like , share and subscribe to learn more about MS Word, PPT, Excel.