Delicious, I am totally impressed. I'm going to spend some time thinking about your example. Thanks for providing details.

I would have been proud too. Nice nice nice!

ok, thank you very much for spending time with me on this question today, 'delicious' and Sean.

interesting. Still looks like a main use for splitters is to split data strings into columns when built in functionality of ssis or import/export wizard isn't enough.

in the book SQL Server Common Table Expressions Joes 2 Pros by Steve Stedman et al., I read about the use of splitters to count the number of times a...

ooh, I see more posts. --looks like it's primarily used to scrub data--

Sean, I've taken a look at Jeff's article and it does chain to another prerequisite read on Tally Tables to get the most out of the 'how'. But I'll...

Reason I need this file is because I want to use SQLCMD to execute script.sql script that I have for creating a database with schema & data. I'm following Dave...

yes

Koen,

I encountered this error today and read this post. I have Microsoft SQL Server 2012 Native Client installed, but when I try to run repair from Control Panel, I...

hmmm, is equi join just no good? Can I just ignore that syntax totally as functional residue, little use, less time wasted learning it the better? Cause I'd like...

ja ja, SQLRNNR, I get you, but I need to know the components available before making any decisions. Probably the equi join is good for something in some other...

Oh, it is a non equi join! For example.

http://www.w3resource.com/sql/joins/perform-a-non-equi-join.php

Thanks.

Even your syntax is new stuff for me. The only joins I've ever used are of two kinds: ON and WHERE a.x = b.x. Never ON-LIKE. What...

So, are you saying that I need to first move the zip file to a second folder to isolate it, before unzipping and moving it's contents to a third folder?...

thank you Koen