Out of interest, did you also try saving the input file with UTF-8 as suggested in the link?

Well, that narrowed the problem down well.

I think that the solution may be found in this article.

Nice article Andy. I have recently written a stored proc which looks very like yours.

The differences:

1) It lives in a separate library-type database (I want it clean and fully source-controlled)

2)...

I presume that you've checked that the T-SQL script works fine if you run it in SSMS? (Works fine on my system, so I am guessing yes.)

You could perhaps try...

brad.mccollum (1/20/2015)

---

Just upgraded last night from SQL Server 2012 to SQL Server 2014.

I have a bunch of earlier-versioned SQL Server stuff still on my laptop and I'd like...

JoshDBGuy (1/20/2015)

---

It's not a nightmare,...

dmj120 (1/20/2015)

---

First, hello!! 🙂 I hope this is the right place to post such a beginner question. I am a complete novice, at best, but really like sql/php/et...

JoshDBGuy (1/20/2015)

---

Phil Parkin (1/20/2015)

---

JoshDBGuy (1/20/2015)

---

I inherited an environment with a SQL Server 2014 environment. It looks like they installed 2014 SSIS concurrently with 2012, leaving both services on the box....

Sorry but I don't have a clue – I did not know that was even possible!

JoshDBGuy (1/20/2015)

---

I inherited an environment with a SQL Server 2014 environment. It looks like they installed 2014 SSIS concurrently with 2012, leaving both services on the box. They then deactivated...

Koen Verbeeck (1/20/2015)

---

Phil Parkin (1/20/2015)

---

For a bit...

For a bit of balance, have a...

Jay Sapani (1/20/2015)

---

The Tables Are Related To Each Other As 1st Table Has List Of Employee And Other The Department In Which They Work.MapPerID = PersonID Of First Table.MapGrp =...

Jay Sapani (1/20/2015)

---

I Have 2 Different Table As Follows

Table 1 - Person

With Columns PersonID,PersonGrp,PersonName

1,'',Person1

2,Grp1,Person2

3,Grp1,Person3

4,Grp2,Person4

5,Grp2,Person5

6,'',Person6

7,'',Person7

Table 2 - PersonMap

With Columns MapID,MapDepartment,MapGrp,MapPerID,DateFrom,DateTo

1,'ADMIN',,1,'01-JAN-2007',''

2,'MGMT',Grp1,,'01-JAN-2007','31-DEC-2008'

3,'MGMT',Grp2,,'01-JAN-2009',''

4,'OTHER',,,'01-JAN-2007',''

Required Output

PersonID,MapID,MapDepartment,DateFrom,DateTo

1,1,'ADMIN','01-JAN-2007',''

2,2,'MGMT','01-JAN-2007','31-DEC-2008'

2,4,'OTHER','01-JAN-2009',''

3,2,'MGMT','01-JAN-2007','31-DEC-2008'

3,4,'OTHER','01-JAN-2009',''

4,2,'MGMT','01-JAN-2009',''

5,2,'MGMT','01-JAN-2009',''

6,4,'OTHER','01-JAN-2007',''

7,4,'OTHER','01-JAN-2007',''

Please Help With Query To Achieve Them Same

WithOut Temp Shifting and...

And I'll be interested to hear which 'imaginary' column names you come up with 🙂