Brandie Tarvin (4/12/2012)

---

Steve Jones - SSC Editor (4/12/2012)

---

Both printers here are acting up. One doesn't want to inject ink on the the paper. The other keeps sending offline messages...

can you post some sample data and table definitions so we can see what you are looking at for an output??

Lynn Pettis (4/12/2012)

---

drew.allen (4/12/2012)

---

I've come to the conclusion that he's not really interested in answers. He's only...

hbtkp (4/12/2012)

---

i have one sp(sp1) which return values for the specific periods

now i have another sp (sp2),which has all the values for all the periods.

now...

drew.allen is saying that you have asked a similar question in the above posted thread...

suhailtajraja (4/12/2012)

---

the table that i have provided is the actual table. is that needs to be in new temp table so that i dont mess with the actual table? also,...

with out seeing your table structure the sample data in that table and the query you are trying to run we can go no further....

good catch sean, im getting ready for work and posting. apparently not a good combination.

pathankhan (4/12/2012)

---

Really, I was setting it up the opposite way.

So 3 foreign keys on Person_Information table to the same primary key Lookup_Country table will run perfectly fine.

ALTER TABLE Person_Information ADD...

ill come in and say it could be a select distinct... but even so DDL (Create table statements) and sample data (Insert statements) will be incredibly helpful in this...

as Gazareth said the foreign key references the primary key (the home_country_id references Country_ID) i would also read up on foreign key relationships to make sure you under stant...

suhailtajraja (4/12/2012)

---

Hi Vinu:

I checked entity_id,and user_id are retruning multiple records in a table. So, what field do I need in my statement as a distinct.Are these entity_id

,user_id ones? or something...

danderson 73949 (4/11/2012)

---

Hello all,

I've 2 separate sql servers, both 2008R2. On srv1 i created a link to linksrv in order to update data between 2 tables. essentially what i want...

pathankhan (4/12/2012)

---

Can someone please help me out setting up primary and foreign key relationships. Here is my issue...

Lookup_Country Table list all the countries.

1. USA

2. Canada

3. China

4. India

Person_Information Table

Birth_Country_ID

Citizenship_Country_ID

Home_Country_ID

I can create...

vinu512 (4/12/2012)

---

dwain.c (4/11/2012)

---

Being the contrarion that I am, I'll offer another solution.

DECLARE @t TABLE (id INT, test VARCHAR(10), status VARCHAR(10))

INSERT INTO @t (id, test, status)

SELECT 1, 'test1', 'Passed' UNION ALL

SELECT...