Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag CSV Rss

   Items 1 to 7 of 7   
 

Excel Function Returns Cell Address

This article details an Excel 2010 function to return the cell address of min and max functions.  Read more...
By Russ Mulkey 2013/06/04 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 5,734 reads

Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 42,952 reads

String Split

Generate table from comma separated string  Read more...
By Falguni Thakor 2012/12/10 | Source: SQLServerCentral.com | Category: comma separated string
Rating: |  Discuss |   Briefcase | 1,634 reads

The T-SQL of CSV: Comma-Delimited of Errors

Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.  Read more...
By Additional Articles 2012/05/11 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,757 reads

Working with Perfmon CSV logs in Powershell

When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.  Read more...
By Hemanth Damecharla 2012/03/05 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,924 reads

Tally OH! An Improved SQL 8K “CSV Splitter” Function

The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).  Read more...
By Jeff Moden 2012/12/28 (first published: 2011/05/02) | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 42,952 reads

Dynamically generate Format File For OPENROWSET tekst file import

Dynamically generate XML format file for use with OPENROWSET or XML bulk insert.  Read more...
By Joey Moelands 2010/11/19 | Source: SQLServerCentral.com | Category: openrowset
Rating: |  Discuss |   Briefcase | 1,362 reads
   Items 1 to 7 of 7   
 
Tags
perfmon (2)    
t-sql (2)    
bcp (1)    
blg (1)    
bulk insert (1)    
comma separated string (1)    
excel (1)    
format file (1)    
import files (1)    
numbers table (1)    
openrowset (1)    
powershell (1)    
table from comma separated string (1)    
tally table (1)