You re welcome, glad it helped.

See if this helps

DECLARE @t TABLE(ID INT,SecID VARCHAR(10),CountryID VARCHAR(10),Currency VARCHAR(3))

INSERT INTO @t(ID,SecID,CountryID,Currency)

SELECT 1,'S42DWER','111344','USD' UNION ALL

SELECT 2,'2TG24GG','251464','EUR';

SELECT 'Schedule2' AS "@ref",

(SELECT 'yes' AS "@key",

...

Can anyone chime in here

http://www.sqlservercentral.com/Forums/Topic1655906-364-1.aspx

I'm at home now and don't have access to a working SSIS environment. I suspect the op just needs pointing in the right direction.

You can use a "Derived column transformation" to add in an additional column.

Have a look at "Export Column Transformation"

The first error tells you what the problem is and potentially how to resolve it

"Could not allocate a new page for database 'Test' because of insufficient disk space in filegroup...

You've changed

'/message/body'

to

'/body'

in the second query

ChrisM@Work (1/28/2015)

---

GilaMonster (1/28/2015)

---

That doesn't return alternate rows, it returns rows with odd values of BusinessEntityID. There's...

Change

c2.c3.value('(Address/text())[1]','VARCHAR(50)') AS Address2,

c2.c3.value('(Address/text())[1]','VARCHAR(50)') AS Address3,

to

c2.c3.value('(Address/text())[2]','VARCHAR(50)') AS Address2,

c2.c3.value('(Address/text())[3]','VARCHAR(50)') AS Address3,

What happens when you run this?

DECLARE @fileIds Xml =

'<Ids>

<Id>1</Id>

<Id>2</Id>

</Ids>',

@archiveName varchar(255),

@idoc int

EXEC sp_xml_preparedocument @idoc OUTPUT, @fileIds

SELECT Id FROM

OPENXML(@idoc, '/Ids/Id', 2)

WITH( Id int '.' )

Try changing

SELECT Id FROM

OPENXML(@idoc, '/Ids', 2)

WITH( Id int )

to

SELECT Id FROM

OPENXML(@idoc, '/Ids/Id', 2)

WITH( Id int '.' )

This should work, but has already been mentioned you would be better off normalizing your tables

SELECT t1.id,t2.id

FROM table1 t1

INNER JOIN table2 t2 ON ','+t1.value+',' LIKE '%,'+t2.value+',%'

This is a gaps and islands problem

http://www.sqlservercentral.com/articles/T-SQL/71550/

WITH CTE AS (

SELECT CustomerID,ReadDate,usage,

ROW_NUMBER() OVER(PARTITION BY CustomerID ORDER BY ReadDate DESC) AS rn1,

...

edberg16 (1/13/2015)

---

Mark Cowne (1/13/2015)

---

edberg16 (1/13/2015)

---

Thanks Mark Cowne.

When I try to run the query, its giving following error:

A non-recursive WITH clause or view should not reference itself within its own...

Works for me...