Jpotucek (1/5/2010)

---

Thank you all for your guidance!!!! This worked :

SELECT

a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

FROM FRATERNAL.CONTACTS a

inner join FRATERNAL.CLIENT_CONTACTS a1 on a.CONTACT_ID = a1.CONTACT_ID

inner join FRATERNAL.MEMBER b on a1.CLIENT_ID = b.CLIENT_ID

inner join FRATERNAL.CLIENT...

Hi Jacob

Sure it will work - I think you can use the same trick to get NEWID() into a function. Many sites however don't allow it (openrowset, linked servers etc).

Cheers

ChrisM

Sometimes...

Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource'

sunpalozzi (1/5/2010)

---

New issue, I am testing the script. I defined the condition field to be varchar(500) in the table. I queried out the table into a cursor. ...

What have you tried so far? Read the link in my sig.

chandrashekar.2512 (1/5/2010)

---

Hi Chris,

i am really sorry i did not get your point, But one thing i would like to tell you is i am not an expert...

chandrashekar.2512 (1/5/2010)

---

Thanks Jack,

I have attached my table and structure details in as txt file. please find it.

As you told i have created tables structure, since i have 5 to...

Jeff Moden (1/4/2010)

---

The reason why it took so long is because, in the presence of a triangular join, it must spawn over 405,000,450,000 rows. To put it more succinctly,...

oot thgir etiuq!

chandrashekar.2512 (1/4/2010)

---

Dear all,

I need to create dynamic stored procedure in which,

i need to select id from one table,should be passed to where condition of another sql statement. This should work...

Please provide sample data scripts. The link below will show you how to do this.

SwePeso (1/4/2010)

---

Thank you. I thought I should post the link so that no more double unneccessary work is done.

I suggested your approach first, but after som clarifications, I saw that...

Hi Justin

This solution has a triangular join, notorious for scaling poorly - but over a day! Blimey. The solution I posted earlier doesn't, so may be worth a try. If...

Nice answer, Peso.

Hi Steven

Please modify the code below to provide sufficient sample data to return your required result set.

-- Set up test data

-- “CompetencyImportanceData“

-- For each JobID, the table contains ImportanceScoreBand values...