Tag: table

• SQL

  Oracle SQL script to generate Date Dimension data for use in Microsoft Excel Data Models

  Date dimension is that one dimension or business perspective without which an Excel Data Model cannot ever exist. Here is an Oracle SQL script to generate the data for a Date Dimension. All that you have to do is change the start date and end date values in the in…

  Nov 14, 2016
• Excel and Power BI

  VLOOKUP: Right to Left Lookup

  We all now know that VLOOKUP has one major constraint that the column in the lookup table from where the lookup value is to be searched should be the first column in the lookup table. Here is a tricky way that you can use to overcome this constraint. The trick…

  Jul 23, 2013
• Excel and Power BI

  Introduction to VLOOKUP in MS Excel

  Hi friends… one of the important features of Excel which every user of Excel is expected to be aware of, is VLOOKUP function. Here I take you through the nuts and bolts of VLOOKUP: What does VLOOKUP do ? VLOOKUP function looks up (searches)  a value in one column and…

  Jul 21, 2013
• Other

  Single T-SQL query to swapping the values of two columns without using temporary column

  How to swap the values of two columns of a table ? Let me explain the scenario with an example – Let’s create a table named “Employees” with columns “First_Name” and “Last_Name”. Then populate the table with some fictitious data. Then view the results once and then interchange the values in…

  Jan 9, 2013