PIVOT should get you what you need. Have a look at this example and see whether it helps you.

I have an 'XML-hacker' solution:

declare @add1 xml

set @add1 = (SELECT a.* from @address a

where a.AddressID = 9

FOR XML path('Addresses'))

if @add1 is null

begin

set @add1 = cast('<Addresses>

<AddressID />

<AddressType />

<Address1 />

<Address2 />

<City...

Don't think this works if there is no underlying row selected.

ronan.healy (7/30/2014)

---

yes its just going from 1 column in flat file to 1 column in a table just with the new fix up data.

so say its security name in the...

Same as any other view.

It's going to be tricky for a newbie, because the data seems to vary by 'type' and some techniques are required to get you through that.

Do you know what your...

+1 - beat me to it.

What is the nature of this data - a flat file?

And you want to clean the data as part of an import to a db - is that right?

OK. Problem?

Might need to tweak your filter a bit:

--

WHERE date_of_attendance >= '2014-07-01' and date_of_attendance < '2014-07-03'

Here is how I would try to do it.

Do an INSERT to your identities table such that it generates all of the idents you need in one hit.

Then use an...

Things are going wrong with this line, clearly:

select @newid, otherstuff, otherstuff1 from @temp where @i = idx

Does the actual version of the code select its data from multiple tables, by...

alezar (7/28/2014)

---

Hi,

I'm working on the conversion of a group of DTS to SSIS and the function of a part of them is to export data from an Oracle database to...

Not sure whether it will work, but I think your regex may be incorrect.

string toreplace = "[\uFFFC]";

Can you try removing the square brackets?

string toreplace = "\uFFFC";

Let's see whether anyone takes the bait 😉