GSquared (8/17/2009)

---

Like Steve, I'm not sure why you'd have separate tables for projects and jobs if it's a 1:1 relationship. There are reasons to do that kind of thing,...

So you must ALSO create a TSQL wrapper for them. Man, what good is having to do that?

Someone must be nuts to use CLR SPs...

Can you tell me exactly how the CLR SPs are created and stored?

I was under the impression that you could just write them in a .Net language in SSMS

just like...

I actually have it working for all columns but for some reason, the char(13) + char(10) doesn't input a CRLF in the text when I paste it into a text...

ok, cool..

How would I check to see if the column has a constraint that I must remove, first?

Thanks, Lynn. I'd like to see what the problem is..

I want a GO after each...

Let me post the actual SQL being used to fill that selection grid.

Any more thoughts on the union with the structures I've provided?

Another sticky issue we have is that when a person is, say, a subscriber contact AND and emergency contact, they will have two records in ptContacts.

Whoa....

Well, ptDemographics doesn't have the same structure as ptContacts but they both have an MRN field that "point" to each other. We currenlty have a TableAdapter that is filled with...

GSquared (1/20/2009)

---

The base-problem is the database design. You shouldn't have contact data in the patients table. It should all be in one place, with a foreign key to...

Yeah I did forget the from.

select name, type from sys.procedures

where name not in (select name FROM FIVER.AHOG.sys.procedures)

order by name

How do I link the servers so I can use the NTLogin...

This worked. Had somebody else from the office work on it. 😉

;WITH ip(MRN, CarrierID, PolicyID, InsuranceLevel,ExpirationDtTm,EffectiveDtTm)

AS (SELECT MRN, CARRIERID, PolicyID, InsuranceLevel,ExpirationDtTm,EffectiveDtTm

FROM ptInsurancePlans where InsuranceLevel...

Thanks, I forgot about the HAVING clause.