p_uzd_id Decimal 9,2 Begin Set @summa := (select Sum(lÄ«gumi.summa) from ligumi, uznemumi where uznemumi.uznemuma_id = ligumi.uznemums and uzņēmumi.uznemuma_id = p_uzd_id); Set @attalums := (select pirkumi.attalums from ligumi, uznemumi, pirkumi where uznemumi.uznemuma_id = ligumi.uznemums and ligumi.liguma_id = pirkumi.liguma_id and and uzņēmumi.uznamuma_id = p_uzd_id); Set @transCena := @attalums * 1.22; Set @kopejaSumma := @summa + @transCena; Set @kopajaSumma := @kopejaSumma * 1.71; Return @kopejaSumma; END ©

I am seeking a web development career with a company that offers a work-life balance to their employees, while working in a team oriented and collaborative environment. I have six years of professional web development experience in a Windows platform using IIS 7.0 with SQL database for SharePoint Server 2010. My job responsibilities consisted of developing multiple sites for several organizations based upon their immediate needs and requirements. I implemented the development of content based upon object oriented programming (OOP), managed metadata as well as setup a search query using REST services alongside writing SQL queries for tables and setup of Taxonomy for navigation. I have additional job experience in system administration of Windows Server 2008 R2, Exchange Management for Active Directory, FTP, DFS, Lync Communications Server/Client, SFDC.com and many other resources. I have additional knowledge and hands-on experience with web development languages such as HTML(5), CSS(3), XHTML, XML, PHP, JSON, JQuery, Ruby, Ajax, Python, JavaScript, SASS. My experience includes MySQL for use as a local host database in conjunction with WordPress PHP and GitHub for version control of content. I have found that I would enjoy working with Bootstrap for HTML, CSS, and JavaScript framework for developing responsive web services. I know this works well with converting PSD to HTML. I’ve been practicing in my downtime using Adobe PhotoShop CC! I have learned how to use WordPress for creating a new site and posts from my local host using XAMPP with MySQL and Apache along with PHPmyadmin for database. I have developed my own website from scratch and have published using . I also have a account that features my portfolio. I have another that I published using PHP. And of course I cannot go without mentioning my site. Thank you for visiting! ©