Sorry I pasted the same row and didn't change the data.

create table #a( a nvarchar(1000))

Insert Into #a

select '.A.A 02.A 02D.A 251487.Jeff Moden 1.'

Union all

select '.A.A 02.A 02D.A 251488.Jeff...

these EntityIDs have different Types with them, say Jeff Mordan is Moderator of this site but at the same time he's an author as well.

Did you have a look...

Jeff, Can you please fix this one? I have a feeling if we fix this one we'll be through at least as a step 1.

if OBJECT_ID(N'tempdb..#a', N'U') is not null...

OrgEntityID has to be unique by all means, can you please tell me the ID that's occurring more than once?

Thanks,

Kazim Raza

Um.. I am trying to get those but my staging server is offline right now; I'll make an attempt again. B/w you want those 161 K rows with proper data?...

🙂

Here's the schema of the target table

Key Bigint

EntityID Bigint

Level1 nvarchar(500)

Level2 nvarchar(500)

Level3 nvarchar(500)

Level4 nvarchar(500)

Level5 nvarchar(500)

this table is then used by SSAS cube to perform different aggregations etc. but thats beyond...

This query is part of an ETL process where I am extracting the data out of the transactional database and inserting them into the data mart where our architect has...

Jeff, assume those numbers are name; you may replace them with some alphabets. I have used the numbers instead of the original data to avoid propriety issues; and probably your...

Nope it is not for MLM. It is a part of a system that will allow organizations to manage different hierarchal structures within their organizations. Any suggestions how to break...

This is why I am concerned about the last select, consider this

CTE gives me the data in this form

ID Name Level ...

Thank you for your reply. The CTE itself gets executed within a minute, actually within 40 seconds; its the last select on #Hie that takes time actually a lot of...

Select * From #Hie

this select is the one that has problems. exact count of records after inserting in #Hie is 161343. My data export to Excel failed after exporting 65000...

Yes Paul, I know its not simple and that's the reason I have turned up here to get expert opinion to get the basic groundwork correct. As I mentioned in...

Thank you all.

I have to focus on another task as a result of shuffling priorities but I will certainly get back to it in a few days, with the...

Can you suggest some other resource? I have tried to look up on Google but haven't come across anything concrete.