http://www.learningsqlserver2008.com/ https://youtu.be/KmsmPOImpHo - Date functions in SQL Server 2012 GETDATE -- Today's date DATEADD - adding time interval to an existing Date DATEPART - return part of the date like year or month DATEDIFF - Give you the different between two dates DAY - returns the day of the month MONTH - return the Month of the Year YEAR - returns the year in the Sql expression CAST - Converts an expression of one data type to another in SQL Server 2008 R2 CONVERT - Convert expressions of one data type to another in sql server r2 SQL Tutorial
Views: 65961 baghul
How to create a basic user account in an Oracle database
Views: 21217 jbleistein11
How to re-create a dropped/deleted Oracle supplied PL/SQL package
Views: 1453 jbleistein11
How to drop a job from the internal DBMS scheduler
Views: 2544 jbleistein11
How to put an Oracle database in restricted session mode
Views: 2586 jbleistein11
How to create a trigger which fires when the Oracle database starts up.
Views: 1828 jbleistein11
How to drop/delete an Oracle database via the DBCA
Views: 2516 jbleistein11
How to convert an ASM managed Oracle database to a cooked filesystem
Views: 1741 jbleistein11
Oracle (NASDAQ:ORCL) issued a statement claiming that Hewlett-Packard (NYSE:HPQ) knew all about itanium end-of-life plans before the company found out. The company stated, "We believe that HP specifically asked Oracle to guarantee long-term support for Itanium in the September of 2010 agreement because HP already knew all about Intel's plans to discontinue Itanium, and HP was concerned about what would happen when Oracle found out about that plan. What we know for certain is that Ray Lane and HP's current board members and Leo Apotheker and HP's current management team now know full well that Intel has plans in place to end-of-life of the Itanium microprocessor. Knowing this, HP issued numerous public statements in an attempt to mislead and deceive their customers and shareholders into believing that these plans to end-of-life Itanium do not exist. But they do. Intel's plans to end-of-life Itanium will be revealed in court now that HP has filed this utterly malicious and meritless lawsuit against Oracle." Oracle has a potential upside of 20.7% based on a current price of $31.16 and an average consensus analyst price target of $37.61.
Views: 205 FinancialNewsOnline
How to drop/delete a tablespace from an Oracle database
Views: 3532 jbleistein11
How to drop/delete an Oracle database trigger
Views: 1167 jbleistein11
This morning, Oracle (NASDAQ:ORCL) issued the following statement in regards to the claims that Autonomy CEO Mike Lynch never shopped his company to the tech giant prior to their $11.7 billion dollar acquisition by Hewlett-Packard. "Autonomy had been 'shopped' to Oracle as well, but Oracle wasn't interested because the price was way too high. Mike Lynch, Autonomy CEO, then publicly denied that his company had been shopped to Oracle. Lynch came to Oracle, along with his investment banker, Frank Quattrone, and met with Oracle's head of M&A, Douglas Kehring and Oracle President Mark Hurd at 11 am on April 1, 2011. After listening to Lynch's PowerPoint slide sales pitch to sell Autonomy to Oracle, Kehring and Hurd told Lynch that with a current market value of $6B, Autonomy was already extremely over-priced." Shares of Oracle are trading up 2.5% to $30.20, while Hewlett-Packard are also trading up over 3% to $23.92. Oracle (NASDAQ:ORCL) has a potential upside of 18.9% based on a current price of $30.15 and an average consensus analyst price target of $35.84.
Views: 227 FinancialNewsOnline
How to re-create the special table dual in an Oracle database
Views: 1470 jbleistein11
How to create an Oracle database via the DBCA - DataBase Configuration Assistant.
Views: 5025 jbleistein11
What happens to transactions when the sqlplus program is closed
Views: 1640 jbleistein11
شرح لطريقة إنشاء الجداول في قواعد البيانات باستخدام الأمر CREATE TABLE و طريقه كتابه اﻻعمدة داخل هذا الجدول و شرح طريقه اسناد نوع بيانات للاعمدة و شرح بعض الخصائص مثل NOT NULL و PRIMARY KEY رابط تحميل الدرس http://abdullaheid.org/download/mysql101/8.CREATE-TABLE.zip
Views: 32374 Abdullah Almehmadi
http://www.accounting101.org/balance-sheet-example The balance sheet is easy to understand... once you understand why what goes where. The balance sheet example on this page, as well as the video, will help explain what the balance sheet is, how it's organized, and how to interpret the information on it. The balance sheet is an extremely useful tool for all users to quickly get an idea of how a company is doing. The balance sheet is usually described as a snapshot of a company's financial position. This is because the balance sheet is accounting for a single moment in time; not over a period such as the income statement. You'll notice in the example below, that the date is December 31, 2011. It basically means, "this is what we have, and this is who owns it as of today, December 31st, 2011." In contrast, the income statement would show a time period, such as "for the period ending December 31, 2011." As you can see in the example above, there are three major parts or sections that make up the balance sheet. These are: Assets Liabilities Owners' Equity Assets are the things the company owns. These are things such as cash, accounts receivable, inventory, prepaid insurance, prepaid rent, and goodwill. There are basically two classifications of assets; current assets and fixed (or long-term) assets. Current assets are assets that will be used within one year. Current assets include cash, accounts receivable, inventory, prepaid insurance, and prepaid rent. There are other types of current assets, but those are the most common. Fixed assets are assets that will be around for longer than one year. Fixed assets include buildings, equipment, goodwill, and land. Asset accounts have a debit balance. Liabilities are the obligations that a company has to repay. A liability could be amounts owed to a creditor, or to a vendor for supplies and inventory. Some examples of liability titles that you'll see are notes payable, accounts payable, wages payable, interest payable, income taxes payable, bonds payable, and unearned revenue. An easy way to spot a liability is anything that has the word "payable" in it. This obviously means an amount that still has to be paid, and will always represent a liability. Another type of liability is when a company receives payment for a product or service that they haven't delivered yet. This is called unearned revenue. Like assets, liabilities are also classified into both current and long-term liabilities. The same rules apply: a current liability is an obligation that has to be repaid within one year, and a long-term liability is an obligation doesn't need to be repaid within a year. Liability accounts have a credit balance. Owners' equity, or stockholders' equity is basically the portion of the assets that the owners of company own. Since assets=liabilities+owners' equity, the assets of the company are either owned by someone external such as a creditor, or they are owned by the owners of the company, usually in the form of stockholders. The account titles in the owners' equity portion of the balance sheet are usually common stock, preferred stock, paid-in capital in excess of par, and retained earnings. Owners' equity accounts have a credit balance.
Views: 315043 SuperfastCPA
How to rename a tablespace in an Oracle database
Views: 1240 jbleistein11
How to drop/delete a VPD policy
Views: 2241 jbleistein11
How to disable and enable a VPD policy
Views: 2558 jbleistein11
How to determine the date and time that your database instance was started.
Views: 2206 jbleistein11
This video is my response to a YouTube viewer who is looking for help in creating an Accounts Payable Status Summary Report. The key concepts and funtions that I used are: The ISBLANK Function as a Logical Test in one IF Formula Nesting one IF Function inside another IF Function The SUMIF Fuction to total Invoice Amounts by Label: Paid, Pay Now, Delay. When you visit my website - www.thecompanyrocks.com - you will be able to click on a link to download the Excel Workbook that I used in this video tutorial. Danny Rocks The Company Rocks
Views: 148728 Danny Rocks
GM15 In order to perform a Geography search on a table, the table must have a special "Geography" field (supported in certain SQL databases such as SQL Server, MySQL, Oracle, Postgress, DB2, etc.). The Geography field is a special type of field that contains binary data, so you can't update its value as easily in your SQL INSERT or UPDATE statement as you can for regular fields. However, it is highly desirable to automatically update the value in the Geography fields in a record whenever a longitude or latitude value is changed. This video shows how this is easily accomplished in a Grid Component. Alpha Anywhere automatically generates the appropriate Portable SQL statement to update the Geography field whenever there are changes to the longitude or latitude field on which the Geography field is based.
Views: 599 Alpha Software
How to bypass the recycling bin when dropping database objects
Views: 1121 jbleistein11
You cannot shutdown or startup a database while in backup mode.
Views: 2199 jbleistein11
How to delete a specific database object from the recycle bin.
Views: 1198 jbleistein11
Introduction to Accounts Payable. Created by Sal Khan. Watch the next lesson: https://www.khanacademy.org/economics-finance-domain/core-finance/accounting-and-financial-stateme/financial-statements-tutorial/v/fair-value-accounting?utm_source=YT&utm_medium=Desc&utm_campaign=financeandcapitalmarkets Missed the previous lesson? Watch here: https://www.khanacademy.org/economics-finance-domain/core-finance/accounting-and-financial-stateme/financial-statements-tutorial/v/basic-cash-flow-statement?utm_source=YT&utm_medium=Desc&utm_campaign=financeandcapitalmarkets Finance and capital markets on Khan Academy: Corporations use three financial statements to report what's going on: balance sheets, cash flow statements and income statements. They can be derived from each other and each give a valuable lens on the operations and condition of a business. After you know the basics of accrual accounting (available in another tutorial), this tutorial will give you tools you need to responsibly understand any business. About Khan Academy: Khan Academy offers practice exercises, instructional videos, and a personalized learning dashboard that empower learners to study at their own pace in and outside of the classroom. We tackle math, science, computer programming, history, art history, economics, and more. Our math missions guide learners from kindergarten to calculus using state-of-the-art, adaptive technology that identifies strengths and learning gaps. We've also partnered with institutions like NASA, The Museum of Modern Art, The California Academy of Sciences, and MIT to offer specialized content. For free. For everyone. Forever. #YouCanLearnAnything Subscribe to Khan Academy’s Finance and Capital Markets channel: https://www.youtube.com/channel/UCQ1Rt02HirUvBK2D2-ZO_2g?sub_confirmation=1 Subscribe to Khan Academy: https://www.youtube.com/subscription_center?add_user=khanacademy
Views: 171009 Khan Academy
This demonstration shows you how to monitor your database using Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Views: 24594 Oracle Learning Library
This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here: http://www.learnitfirst.com/Course161 In the last video, you looked at a mixture of old and new temporal data types. In this video, Scott focuses on DATETIME2 and DATETIMEOFFSET. He will start by reviewing some date/time commands and introducing some new ones, and you will see some important things to keep in mind when using a DATETIMEOFFSET data type. What is the disadvantage of using the DATEADD function instead of the SWITCHOFFSET function? Highlights from this video: - What command returns the UTC date? - The SYSDATETIME function - What is the advantage of using DATETIME2? - How do you get a time zone aware version of DATETIME2? - Changing the time zone and much more...
Views: 5852 LearnItFirst.com
Example Of Using Excel Depreciation Function in Access Query
Views: 3563 Theodore Timpone
Views: 244581 .NET Interview Preparation videos
Sorry for the lack of audio, this was intended as a personal reference for myself and my team who were present for the demonstration. I'll create another, better one in the future. For migration of data from PSFT to SFDC, we need to extract data from SQL Server in a CSV format. Then use Dataloader to import/upsert data to Salesforce. CSV files are not the best solution, but here is an easy way to get data into Excel so that you can Save As.. a csv file that is ready to go into Dataloader. If you write SQL in a way that you alias the result set with the same names as the fields in Salesforce, then Auto-Mapping is your friend.
Views: 60584 Jon Lal
All Things Digital reported that Oracle (NASDAQ:ORCL) is maintaining that the agreement it entered into with Hewlett-Packard (NYSE:HPQ) last year over Oracle's hiring of former HP CEO Mark Hurd, is questionable since, at the time of the agreement, Oracle did not know that HP was near to hiring Leo Apotheker as its new CEO and Ray Lane, the former CEO and Ray Lane, the former Oracle COO and president, as its new chairman. In part of that settlement there was an understanding that a long standing partnership whereby Oracle would continue making software that runs on hardware using Intel's Itanium chip. Oracle (NASDAQ:ORCL) has a potential upside of 31.4% based on a current price of $27.87 and an average consensus analyst price target of $36.63.
Views: 97 FinancialNewsOnline
Visit us at http://www.sap.com/LearnBI to view our full catalog of interactive SAP BusinessObjects BI Suite tutorials..
Views: 31010 SAP Analytics
American Superconductor (NASDAQ:AMSC) said it will restate financial statements for Q2 and Q3 of fiscal 2010 because it recognized revenue before receiving payments from customers in China, according to a Bloomberg report. Revenue was about $98 million in Q2 and $43 million during Q3. For the full fiscal year, revenue is expected to be $307 million. American Superconductor has a potential upside of 52.7% based on a current price of $8 and an average consensus analyst price target of $12.21.
Views: 200 FinancialNewsOnline
The largest maker of business-management software has made a big purchase that is increasing competition in the cloud-computing market. SAP (NYSE:SAP) has agreed to buy software company SuccessFactors for $3.4 billion in cash, paying $40 per share, a 52% premium on the company's closing price on Friday. With SuccessFactors being a leader in the employee performance software business, the deal will extend SAP's reach in the cloud computing market. Cloud computing is a way for companies to rent software over the internet rather than installing it on their own machines. SAP is promoting the idea as a safe way to outsource data centers and reduce the need for hardware. SuccessFactors has more than 3,500 customers with more than 15 million subscribers in 168 countries. The company is predicted to have $502 million in revenue in 2013. This announcement comes after rival company Oracle (NASDAQ:ORCL) bought RightNow Technologies for $1.5 billion dollars. SAP (NYSE:SAP) has potential upside of 3.6% based on a current price of $59.54 and an average consensus analyst price target of $61.67.
Views: 177 FinancialNewsOnline
CA Final Financial Reporting
Views: 861 Arinjay Academy
One of the most frequent requests that I get from my viewers is: "How can I automatically add a date / time stamp whenever I update, add, or edit a record in Excel?" Most viewers have already tried to use either the =NOW() Function - a volatile function - or some combination of Keyboard Shortcuts - neither of which are satisfactory procedures. In this tutorial, I demonstrate how to write a (short) Event-Handler Macro using VBA (Visual Basic for Applications). If you are "scared" or "intimidated" by the thought of writing VBA Code, you will find that my step-by-step tutorial will show you how easy it is to write this Macro. Try it! If you need to provide an "Audit Trail" for an Excel worksheet, this VBA Code will save you hours of time by automating the process. If you are an experienced user of VBA - I have good news for you! I show you the coding early on in this tutorial! I invite you to visit my new online shopping cart - http://shop.thecompanyrocks.com - to see all of the products that I offer you to "Master Excel in Minutes - Not Months!" Danny Rocks The Company Rocks www.thecompanyrocks.com
Views: 102040 Danny Rocks
http://www.facebook.com/eaa.finance.accounting?sk=app_205495956136471 Join us on our FREE Webinar Series too!. handled by Ms. Sarah Songalia, the manageing director of Entrepreneurs Accounting Academy herself, we would be delighted for you to join us, click this link http://eepurl.com/brXL5 so you'll be updated on all our upcoming webinar schedules and promos. Entrepreneurs Accounting Academy http://eaa.edu.ph
Views: 9768 eaaeduph
Industry: Hospital - Health Care Client: Big hospital in the Netherlands, Rotterdam Business Challenge: Replacement of their current running EBA system, written in Foxpro. The main challenge was to have a full SAP inbound and outbound API with the main ERP system in the hospital, to have a single sign-on setup with Microsoft Active Directory (AD). The program has to organise the purchases of goods and services of employees in the hospital in a working shopping cart environment and has to have different approvement levels and setups. It also has been adjusted for CBRN procurement, as obligated in the law in the Netherlands in 2011. Solution: Net-Certo group has setup OpenERP v6 with a maintenance contract for this customer. The SAP inbound and outbound has been achieved via a direct python API interface. We installed OpenERP LDAP integration module for 1-on-1 communication with the Active Directory environment. As replacement on the EBA functionalities a custom made module for the customer has been made. Business Benefits: The hospital uses the core of OpenERP and in the future it can build on this core for extra modules. The project has been done with a rather small budget compared to other ERP systems.
Views: 1424 Yinius UAB
Oracle (NASDAQ:ORCL) said that it will cease all efforts to develop technology around Intel's (NASDAQ:INTC) Itanium chip, which reportedly took Intel and Hewlett-Packard (NYSE:HPQ) by surprise. The company said its decision on the chip came after multiple conversations with Intel senior management, which made it clear that their strategic focus is on their x86 microprocessor and that Itanium was nearing the end of its life. HP issued a statement saying, "We are shocked that Oracle would put enterprises and governments at risk while costing them hundreds of millions of dollars in lost productivity in a shameless gambit to limit fair competition." Oracle has a potential upside of 14.6% based on a current price of $31.41 and an average consensus analyst price target of $36.
Views: 203 TradeTheTrend
RightNow Technologies (NASDAQ:RNOW) announced that at the company's Special Meeting of Stockholders, stockholders voted overwhelmingly to approve the proposed merger with an indirect wholly owned subsidiary of Oracle Corporation (NASDAQ:ORCL) for $43.00 per share in cash. Greg Gianforte, founder and CEO of RightNow, said, "We are pleased by the strong support we have received from our stockholders, with 87.0% of the shares voting in support of the transaction. We look forward to working with Oracle to realize the significant value this combination will bring to our stockholders and all the new opportunities it will provide our dedicated employees, customers, and partners." Oracle (NASDAQ:ORCL) has potential upside of 42.8% based on a current price of $25.5 and an average consensus analyst price target of $36.41.
Views: 65 FinancialNewsOnline
TPC System online/ real-time production supervision system. Modul (software+ hardware) system, which: Keeps the production under online supervision continuously, Checks, sends data and statistics to the computers, Makes the system available to continuously monitoring of the substance flow, the supply platform and employee work time as well as the machine's current performance, Communicates with any corporate management (ERP/ MRP) e.g.: pl. SAP/ Oracle/ Navision. The favorable effects: The products can be manufactured faster and cheaper, Can decrease direct labor cost and stocks (ties up working capital ) It may reduce process time -- result is a faster customer satisfaction, Speeds up the return of the working capital, Increases the profit and helps in cost saving Reducing the price, In the price competition, it increases the advantages of the Company, Makes checking, the organization and the management easier, Helps to plan the manufacturing, gives a clean feedback on how to reduce expenses. Increases the lifetime of the machines, Reduces the repair expenses of the machines, The exchange of tools becomes planable, The machine adjustment and desertion time becomes planable The production increases without investments and by that, the manufacturing will be more efficient. Decision makers can receive accurate data for fast decision making. Helps to reach goals to be competitive and reduces the waste product percentage Support the optimal work flow with real time data. The return on investment is under 3-9 months -- based on a one shift production plan and on a 6-7 %- capacity expansion. The setup of our system depends on the number of the machines: beside 2-10 workdays, undisturbed production. The work data can be exported to excel or other corporate management (ERP/ MRP) software. With 4 modules (+ hardwares) collection of 4 data groups: 1.Current position of machines (detailed position times, usage time) 2.Positional warehouse register, 3.Production -- usage (material streaming-monitoring) 4.Employee work hour register (decreases unnecessary wage costs). Immediate data processing and statistics Options: 1.e-mail: Reminds the employee at the warehouse when the supplies are low, 2.Text messages: 3.The system sends an automatic message for the repairman/ factory manager/ technical manager, that which machine is failed, and where, like: engine/ crankshaft/ control, feeding, tool break, etc. 4.The system sends messages to the warehouse workers or for a material handler, that a lack of material supply occurred somewhere, 5.The system sends messages if there was a tool exchange or a fine adjustment. 6.LCD TV: 7.It is possible to monitor the whole producing flow on a TV screen, which can be placed near the manufacturing lines (imported production plan from the corporate management software is available) 8.Sends data about current work time of the machines, like: producing/ conversion/ machine statement/ engine trouble, etc. to any computer (owner, shopleader/ technical director). 8.The firm manager dashboard's. Comment: The 8th option is require special technical conditions on the buyer's side, however, the system is capable to satisfy these options without modifications.
Views: 30 LehelsManagement