Sean Lange (3/23/2012)

---

Eugene Elutin (3/23/2012)

---

Sean Lange (3/23/2012)

---

OK, don't use loops in...

Thanks guys for clarification. Got it now.

SELECT * FROM table1

except

SELECT * FROM table2

It means Unicode. All Unicode strings should be prefixed with N.

http://support.microsoft.com/kb/239530

By default the port is 1433, but if it changed you can check do doing the following:

You can open the SQL Server configuration manager and then go to SQL Server...

Thanks John!

Looking into the XML code was my first instinct also and I did that, but the XML also contains the query only.

I think I need to have through look...

Thanks for your reply.

I tried using the wizard by double-clicking the component, but it asks me to re-setup everything.

By re-setup I mean, when the wizard is opened, on the...

Jpotucek (1/5/2010)

---

Thank you!!!!!!

This actaully works:

SELECT

a.CONTACT_TYPE_ID

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

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 c on a1.CLIENT_ID = c.CLIENT_ID

BUT...

check this

SELECT c.Client_number

,m.Member_number

,contact_type_id

FROM CLIENT c

INNER JOIN MEMBER m

ON c.CLIENT_ID = m.CLIENT_ID

INNER JOIN CLIENT_CONTACTS cc

ON cc.CLIENT_ID = c.CLIENT_ID

INNER JOIN CONTACTS ct

ON ct.CONTACT_ID = cc.CONTACT_ID

This is the query from what I can understand what you need

SELECT count(*)

FROM schema.table1

INNER JOIN schema.table2

ON contact_type_id = member_number

where contact_type_id = 'Email1'

IF you can post table schema, sample...

OK. Are you able to copy from the command prompt?

It is because of the keyword [localhost]. local host will not be recognized by the file system (as far as I know), you will have to use the actual server...

Try to have a breakpoint before the COPY command and when you reach the breakpoint check the value of your variables.

Check whether the path are correct

Try this.

sp_helpdb 'database Name'

I have planned to improve my performance tuning skill.

Starting with "SQL Server 2008 Query Performance Tuning Distilled" by Grant Fritchey.