ChrisM@Work (3/24/2014)

---

The article isn't always easy to follow and might be helped by this:

DECLARE @pString VARCHAR(8000), @pDelimiter CHAR(1);

SELECT @pString = 'The,quick,brown,fox', @pDelimiter = ',';

WITH E1(N) AS (

...

touché

Same query as before with the addition of a conditional statement to format the output.

with Groups as (

select 1 as GroupId,'Oracle' as GroupName,0 as IdParentGroup union all

select 2 as GroupId,'Microsoft'...

Or in other words

with Groups as (

select 1 as GroupId,'Oracle' as GroupName,0 as IdParentGroup union all

select 2 as GroupId,'Microsoft' as GroupName,0 as IdParentGroup union all

select 3 as GroupId,'IBM' as GroupName,0...

Recommend using Script Component in the Data flow. The split function is normally faster than anything in T-SQL and less complicated than most other options.

Better late than never :w00t:

Here is an example;

DECLARE @DTSXML XML = N'<?xml version="1.0"?>

<DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"

DTS:refId="Package"

DTS:CreationDate="11/7/2013 12:57:04 PM"

DTS:CreationName="SSIS.Package.3"

DTS:CreatorComputerName="USER-COMPUTER"

DTS:CreatorName="MyUserName"

DTS:DTSID="{10A38C50-3656-42E0-A054-87E8D9DFBD8A}"

DTS:ExecutableType="SSIS.Package.3"

...

A better way is to use the nodes method

http://technet.microsoft.com/en-us/library/ms188282.aspx

A good article on this: Ad-Hoc XML File Querying by Seth Delconte

https://www.simple-talk.com/content/article.aspx?article=1756

Could you provide the output of sp_help 'view', might shed some light on the problem.

Luis Cazares (3/21/2014)

---

Eirikur Eiriksson (3/21/2014)

---

Just a quick thought;

Splitting the string is somewhat like crossing the stream for a sip of water, when all that is needed is to get the...

Hi,

the string has to be parsed / split for this to work. Quick solution;

grab the splitter function from

http://www.sqlservercentral.com/articles/Tally+Table/72993/

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'Customer' AND...

Two serious issues here,

the first is that the

@AcctType nvarchar

is only going to be one character in size;

DECLARE @getCnt int

DECLARE @AcctType nvarchar

SET @AcctType = 'ABC'

SELECT LEN(@AcctType)

CHLEN

1

The second is the...

Just a quick thought;

Splitting the string is somewhat like crossing the stream for a sip of water, when all that is needed is to get the position of the spaces/delimiters....

Got this one more or less ready, should be with you this weekend.

Do you mean something like the nitty-gritty of a schema collection and typed xml?

Hi,

the usage would be restricted to running R from a desktop using ODBC connections and Windows authentication. The users can access the same data...