Monday November 20th 2017

Categories

Insider

Archives

‘Transact-SQL’ Archives

Database Programmer

Database Programmer

(one year contract) The Institute for Clinical Evaluative Sciences (ICES) is seeking a Database Programmer to design and develop reports using inTool, their web-based reporting tool. The successful candidate will be capable of understanding and working with an existing SQL server database that contains data spanning a variety of health [...]

Sample: Specific Job Skills for data analyst

Sample: Specific Job Skills for data analyst

Database professionals like sql developer, reporting analysts in Crystal Reports, Sql Reporting services and sql programmers can enter into new promising field of healthcare data analysts by following the job descriptions in this field. Following is the sample job description from - The Washington State Hospital Association (WSHA) published on [...]

Data related job titles

Data related job titles

This post about trend in new job titles we searched in data analyses, reporting / BI. We are writing these because job seekers can search job by using these titles on major job websites and will find lot of job openings. Data / Content Migration Assistant, Data / Content Migration Assistant data analyst data analyst data [...]

Changing a Traditional information system to adapt new technologies for effective decision making

Changing a Traditional information system to adapt new technologies for effective decision making

This is about an experience of an anonymous writer of this post describing his/her hands on experience in upgrading company’s information to adapt to new technologies for effective decision making and resultantly growth of the company. This post also reveals that how the hands on experience sets the foundations of understanding new [...]

Comparing SOUNDEX and DIFFERENCE

Comparing SOUNDEX and DIFFERENCE

The SOUNDEX function converts a character string to a four-digit code for use in a comparison. Vowels are ignored in the comparison. Nonalphabetic characters are used to terminate the comparison. This function always returns some value. This example displays the results of the SOUNDEX function for the similar character strings of "chappel" and [...]

Transact-SQL Insert post inventory data in related ledgers

This post is about posting only new data from inventory table into vendor ledgers and material control account  by automatically checking exisiting data. We are using true example from our accounting database. Transactionz table is a financial transactions table resulting from material received or returned. In inventory table data is recorded [...]

Temp table a useful tool in many reports

Temp table a useful tool in many reports

Reporting the payments received against shipment’s C&F value. In this example our client was facing an  issue where shipments are made  and C&F value amount is taken as Accounts Receivable, payments are received in 2 to 3  installments.  Management wants to know how much is outstanding against each shipment C&F Invoice. In [...]

Real world example of usage of Case statement in SQL Server Stored Procedure

This post is our practical experience of using Case statement in Calculating monthly overtime amount. Issue was actually usage of different no hours for Overtime worked for different departments. In this case Security departments overtime was calculated based on 12 hours and in all other departments base was 8 hours. Salary was categorize [...]

Practicality of Floor function in SQL Server

We are writing this post to share our experience of usefulness of Floor function. We use the floor function in calculating product manufactured and raw material wastage in the process. The problem was to calculate how many units of a product can be manufactured from certain weight of a raw material. We were getting answer like 8.67 products [...]