My start parameters are looking for the master here:

dF:\MSSQL\OVOPS\Datafiles\master.mdf

2010-01-26 13:29:44.60 Server -e C:\Program Files\Microsoft SQL Serve

r\MSSQL.5\MSSQL\LOG\ERRORLOG

2010-01-26 13:29:44.61 Server -l G:\MSSQL\OVOPS\Logfiles\mastlog.ldf

I checked both paths and the master.mdf and mastlog.ldf exist....

I tried to start from a command line using -f -m and this is what I got:

C:\Program Files\Microsoft SQL Server\MSSQL.5\MSSQL\Binn>sqlservr -sOVOPS -m -f

2010-01-26 13:29:44.60 Server ...

2010-01-26 13:03:20.18 Server This instance of SQL Server last reported using a process ID of 9096 at 1/26/2010 9:34:35 AM (local) 1/26/2010 2:34:35 PM (UTC)....

awesome. thank you! they syntax kills me everytime!

You guys are awesome!

I have a new requirement. I need to pull in matching rows from the Client table.

the receive_email_notice column is either Y, N or...

This works for displaying all rows where History = 'Y'

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 c...

Fraternal.contacts table contains the History_YN column

SELECT a.Contact_info

,b.MEMBER_NUMBER

,c.CLIENT_NUMBER

,a.CONTACT_TYPE_ID

,d.history_YN

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

WHERE a.CONTACT_TYPE_ID in ('Email1')

AND b.MEMBER_NUMBER...

awesome.. it's actually all coming together in my head 🙂

another dilema...

Add a History_YN column to the contacts table and Select where not equal to Y

I...

Actually I don't need a count and it does return Email address in the contact_info column

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...

Awesome !! Thank you all for your help!

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 c...

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 I...

Thanks for all you help. it is not just counts that I need. I need to extract Client_number, Member_number and contact_type_id (with a where clause for Email1)

I've attached...

Thank you all!