• Home
  • Data Analysis
  • Data Cleansing
  • Data Mining
  • Data Scraping
  • Data Warehouse
  • Blog
  • Contact

Import multiple text files with the same csv format using T-SQL

March 2, 2014

Recently needed to import 4,000 plus text files into SQL. This was an easy job as: All files were in the same directory All files had the same csv structure. All files had the same file name except for a changing date suffix (eg: 20140131.txt) For the following code to work, you need to have previously set up a date table (tDate) and a … [Continue reading...]

Boost SQL performance with Date (Calendar) tables

February 10, 2014

A date (or calendar) table is a SQL table containing a variety of date-related parameters. By joining to this table, one can rapidly access the pre-calculated values, thus significantly simplifying & speeding up your queries. Using 18 December 2013 as an example, the following parameters would be available: Parameter Value Date … [Continue reading...]

Search

Categories

  • Big Data
  • Business Intelligence
  • Creativity
  • Data Analysis
  • Data Cleaning
  • Data Mining
  • Data Scraping
  • Data Warehouse
  • Decision Making & Valuation
  • KPIs & Metrics
  • Management Frameworks
  • Management, Leadership & Teams
  • Organisation, Culture & Change
  • Problem Solving
  • Programming
  • Report Writing
  • SQL
  • Uncategorized
Sending
Algorithm Creation
Blog
Cleansing Salesforce Data
Comments Policy
Contact Us
Customer Analysis
Data Analysis
Data Analysis Methods
Data Cleansing
Data Deduplication
Data Management
Data Merging
Data Migration
Data Mining
Data Scraping
Data Scraping Landing Page
Data Verification
Data Warehouse
Data Warehouse Methodology
Disclaimer
Financial Analysis
Home
Privacy Statement
Procurement Analysis
SSRS Report Writing
Text Analysis
Web Scraping

The Data Group

The Data Groups Phone Number  1300 788 662

info@data-group.com.au

6 Somerset Close, Heatherton
Victoria,    3202,    Australia

ABN: 89095802985

Established: 2005

Copyright ©, The Data Group is a division of Net Assets (Australia) Pty Ltd. Log in