patrickmcginnis59 10839 (4/14/2015)

---

Sean Lange (4/14/2015)

---

patrickmcginnis59 10839 (4/14/2015)

---

Sean Lange (4/14/2015)

---

liamdemasi (4/14/2015)

---

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in...

patrickmcginnis59 10839 (4/14/2015)

---

Sean Lange (4/14/2015)

---

liamdemasi (4/14/2015)

---

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in the EmployeeCountry table, then...

Hi and welcome to the forums. You need to provide...

rajemessage 14195 (4/14/2015)

---

hi,

Q1)followng is from https://msdn.microsoft.com/en-IN/library/ms187928.aspx?f=255&MSPPError=-2147217396

please explain "1 These style values return nondeterministic results. Includes all (yy) (without century) styles and a subset of (yyyy) (with century) styles."

Q2) please explain...

Just to demonstrate how much difference aliases can make. I used aliases in your joins and that massive wall of text in the middle is a LOT more friendly.

SELECT ItemKey

,...

Something like this should be pretty close. Since you didn't post ddl or data this is untested but it should work.

declare @EmployeeID int = 10001;

with SortedVals as

(

select CountryId

, ROW_NUMBER ()...

liamdemasi (4/14/2015)

---

Right, I figured that. My real question, though, is how do I insert the data into the denormalized table?

My select: Select TOP 3 FROM EmployeeCountry where EmployeeId = 10001

Will...

Then you will need to do this one...

liamdemasi (4/14/2015)

---

I am not splitting it back into 2 tables. I am trying to get the CountryIds associated with an EmployeeId in the EmployeeCountry table, then I am going to...

liamdemasi (4/14/2015)

---

They would know which is the EmployeeId and which are the CountryIds by the column headings in the table I will insert the data into.

I will attempt your suggestion...

liamdemasi (4/14/2015)

---

I have a requirement to provide data in a denormalized form from normalized tables. Working in SSIS.

I have two tables: EmployeeCountry and Country.

EmployeeCountry

EmployeeId (PK)(FK)

CountryId(PK)(FK)

Country

CountryId (PK)

CountryName

There will only be ...

Naveen J V (4/14/2015)

---

Hi,

I have around 3 tables having around 20 to 30gb of data. My table A related to table B by a FK and same way table B...

Here is another way of handling this type of thing. This is using a cross tab.

Please notice how I created tables and sample data to work with. This is something...

This works but...

I would say that rewriting the storage engine is what "fixed" the problem.