Software Applications Programming Errors and solutions.

Lets If You have  have data in following format in Excel 1*(4+3.00)/2*3 5*(4+5.00)/2*4 1*(5.30+300)/2*4 1*(2.30+400)/2*3 1*(5.30+3.00)/2*4 1*(t.30+3.00)/2*3 You  want to convert it in formula ( Result ) without entered "=" manually. how cant it possible ? Solution: Download and install ASAP Utilities ( http://www.asap-utilities.com/ ) Open your worksheet. Select all the cells that you want to convert. In the ASAP Utilities menu: Go to "Text". Click on "Insert before and/or after each cell in your selection". Put in an = sign in the "add before:" box. "treat cells as:" values (default) Click on "OK". Now, press and hold Ctrl. Press the "H" key. That will open the "Find and Replace" dialogue box in Excel. (Type an = sign into both boxes.) "Find what:" = "Replace with:" = Click on "Replace All".

If you want to kill any sql process for which your system is being hang or any other problem then you can read following comments. Get SPID of process then write following command at sql query browser. KILL 121 WITH STATUSONLY spid 121 : Transaction rollback in progress. Estimated rollback completion: 80% Estimated time left: 10 seconds. ReRun the same. spid 121 : Transaction rollback in progress. Estimated rollback completion: 99% Estimated time left: 1 seconds.

You can get Difference in Exists and In operator in sql query by below example. Using SQL server database 2008 R2 in query editor. SELECT * FROM Dept where DeptID IN (select Deptid from subDept ) SELECT * FROM Dept where exists (select Deptid from subDept ) This a simple example where I know the second query will execute faster than the first. The qualifier "if both Deptid columns are unique" is a critical requirement in order for the JOIN to produce the same results as the IN. So: •JOIN will produce one row for each matching row in subDepts. •IN will produce only one row if there is one or more matching rows in subDepts •EXISTS will produce one row if there are any rows in subDepts regardless of whether they match or not

Nulls are neither good nor bad. NULL is simply the absence of data. How one deals with NULL is entirely dependent on the environment you are working within. The various forms of VB and xBase platforms seem to be  the worst at accommodating NULL within code. So, from that perspective, . However, from a database perspective (excluding MS-Access) a column having a NULL state is actually useful information (the absence of a value). I find NULL to be a useful data state, in that this clearly indicates that a value has either not been set, or specifically cleared. It's a pain to deal with fields that can either contain a value, blank, or null. It's just a bunch of extra coding to deal with the variations when writing code. It is different from dealing with results from a query where there is a left join that returns a null value.

To get common Sql server developer interview question and answer you can visit following website link. Sql server developer interview question and answer To get question related to sql authority you can visit link below. SQL Server Journey with SQL Authority To get some common quesion and answer related sql database. SQL Server - Common Interview Questions and Answers

If you are going to attend Team leader /Project manager interview then some common question you should prepared. I am sharing link where you can get some idea about answers of some typical question. If you read it in advance then interview will be easy for you. Project Manager Interview Questions and Answers 50 interview questions You can get lot of questions and answer for different categories here Interview Questions I hope after reading all answer your confidence level will improve.

clear cache Clear cookees,history,cache,data trafic,serch history etc try google chrome to use google products like gmail,google,google plus etc. delete temporary files. Go to run->write temp->del all files->den go again in Run and type %Temp% and del all files here also!! Use Disc cleanup and defragment utility of disc properties. Clean desktop items. Delete unused user profiles from document and settings folders.

To search subfolders and Add hyperlink for file from the top level folder using Macro code in Excel. You can take help from code below. Private Files As Dictionary Private StrFile As String Public Function FindFolder(strpath As String) As String Dim fs, f1, f2, FleCollection Set fs = CreateObject("scripting.filesystemobject&quot ;) Set f1 = fs.getfolder(strpath) Set f2 = f1.subfolders Set FleCollection = f1.Files For Each subfld In f2 FindFolder subfld.Path Next For Each fle In FleCollection Files.Add fle.Name, fle.Path Next End Function 'add below code before adding hyperlink If (Files Is Nothing) Then Set Files = New Dictionary End If 'Filename should contain Extension like "test.pdf" If Not ((Files.Exists(Filename))) Then 'replace c:\ with root folder of the file,if you are no sure about Root folder, You need to call it with all possible drives like "C:\" "D:\" etc

I got one good site which is Excellent Investment Calculator for diffierent purposes. You can visit following link. http://investmentyogi.com/Financialcalculators.aspx By this site you You can get following calculators Income Tax Calculator,Home Loan EMI,Double your money Calc,Systematic Investment Plan,Recurring Deposit Calc,Life Insurance Calculator,Fixed Deposit Calculator,SIP Investment calculator,Final return on monthly SIP,Annuity Calculator,Retirement Corpus,Save To Become Crorepati,CAGR Calculator,Insurance Calculator Future Value Calculator,Inflation Calculator,Interest Payable Calculator,Time To Become Crorepati Housing loan eligibility,Home Loan Refinance,Financial Health Calculator,Investment Planning Calculator etc.

This is a Macro code in excel to insert blank row on column change in excel. Dim rval As String, i As Long rval = Cells(1, 1): i = 2 Do Until Trim(Cells(i, 1) & "") = "" If Cells(i, 1) <> rval Then rval = Cells(i, 1) Rows(i).insert shift:=xlDown i = i + 1 End If i = i + 1 Loop End Sub

Machines can never be as intelligent as human beings, although it is just a matter of perspective! By the term intelligence, if you refers only the modelling of human behavior [weak AI],it might b possible with the help of a large computational power. But if u want to built the real intelligence [strong AI], the task is going to b tough. In 1980, John Searle introduced a famous thought experiment called Chinese room experiment. He argued that intelligence can never be attained with the blind manipulation of symbols, as suggested by "The physical symbol system hypothesis"[by Newell and Simon, 1976].The thought experiment is explained bellow. "Consider an 'intelligent machine”, which answers to questions asked in Chinese, back in Chinese. Then, given the algorithm of the machine, one who doesn't speak Chinese can also answer the Chinese qns, executing the algorithm line by line. But that don’t makes him know Chinese. Like this, the "intelligent" ma

Use the SUBST command to substitute a drive letter for a path in order to treat a virtual drive (a reserved area rather than an actual disk drive) as a physical drive i.e create a new drive for your Favourite Folder in MS-DOS Prompt. For e.g if you want to create a drive named Z for your Program files folder then u need to enter the following in your DOS mode : - subst z: "c:\program files" This will create a drive named Z in your My Computer so that you can directly access your program files contents from this Drive. You can also create a Separate drive for your separate folder for accessing data easily. For e.g Separate drive for your music folder etc.

In case of SSRS  in SharePoint Integrated mode. You may have report server in SharePoint integrated mode and the Reporting services running under domain account. which will be part of domain admin group as well.but when you try to connect to http:\\localhost\reportserver it may give following  error: Reporting Services Error -------------------------------------------------------------------------------- Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help User cannot be found. -------------------------------------------------------------------------------- SQL Server Reporting Services and in reporting service log it gives me following information w3wp!webserver!1!8/15/2007-13:40:01:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: User cannot be found. at Microsoft.SharePoint.SPUserCollection.Get

Proclarity - ease of use; Dashboard and KPI capability; chart types etc., are better than in Microsoft. Also, Proclarity is something even Business users can use (we can create libraries as starting points and the business users can deploy onto a PAS server) SSRS - offers greater control over formatting, which sometimes can actually be quite frustrating because expectations from an SSRS report is also higher in terms of formatting detail. But SSRS cannot be used by business users; Also no dashboard or KPI capability within SSRS. printing capabilities SSRS have which proclarity doesn't have. In fact formatting in SSRS might be difficult to achieve but anyway its is better than Proclarity. The point where Proclarity is better is KPI and Dashboard reports. Once configured even SSRS reports are used by business users. Proclarity as one of my friends said is more of an analytic tool. Even the Ad-hoc report functionality of SSRS involves Report Builder is meant to be shared

RAJ Connexion Technologies ERP Training Center(Chandra Institute ESI) Ilogic Institute Appworld Institute Oracle images SPAM Technologies VISHNU TECHNOLOGIES iWareLogic Vivid Technology Wilshire Gensys (Himayat Nagar). Comp-u-learn institute SR Nagar. Vennela Technologies Pvt. Ltd. srihitha technologies ANEESH Technologies 4Bss Solutions Inferdata Computer Education Peer's Technologies Pvt Ltd Anitech Software Solution’s Webnology Institute SRISYS, Inc Applsys Solutions Gandam technologies in s.r. nagar Naresh Technology Sql star

Adding items from listbox to database First you need to write code for connection and recordset opening then you can set following code in your program for i = 0 to list1.listcount -1 if list1.selected(i) = true then rs.addnew rs!fieldname = list1.list(i) rs.update next i Validating user name and password from the database using visual basic Set con = CreateObject("adodb.connection") con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test.mdb;Persist Security Info=False" con.Execute ("select Username, Password from table1 where Username='" & UID & "'") If Not con.Execute("select * from table1 where [username]='" & txtUsername.Text & _ "' AND [password]='" & txtPassword.Text & "'").EOF Then MsgBox "Login Successfull", vbInformation, "Success!" Else MsgBox "Login Failed-Enter UserID and Pas

Disable minimize and maximize buttons in windows form If you are using .Net then in property window of "Windows Form" set "Control Box" to "False". If You are using .Net 2008. You can disable the form close button by using "e.Handled=true" in Window's Form_Closing event. 

Partition is used to split the table i,e Partition  this is recommended when your table is so large. Types of partition are range part hash list composite range hash partition composite range list partitions Partition can be done at create table statement or can alter table .

rank() assigns each row a unique number (rank) giving identical ranking for duplicate  values,leaving a gap in the sequence to the next rank. dense rank() similar to rank(), it leaves no gaps in the rank after identical ranking. this link http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php