Neither of these companies has a product that...

Then how is it that the FK can be created in the designer?

It might help if I use the correct names for everything. (No, still get the errors)

--**************************************

-- ptPhysicalExam

--**************************************

-- Drop FK_ptPhysicalExamDetails_ptPhysicalExam from...

Can you guys help with this one, too?

This code:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ptLabResultsorg]') AND type in (N'U'))

BEGIN

-- Altering ptLabResultsorg

Print...

Thanks...

OK, got it working based on Jack's last post.

Thanks a lot...

UPDATE ptAppointments SET resource = I.resource + I.site FROM inserted I

...

How would I modify this to work for both the insert and update and am I doing this

correctly or not? I want to concatenate the resource and site columns...

*MOST* good forum...

Then why hasn't that been added into the forums since it is a tool used on the site?

It doesn't look like it would be too difficult to pass the text...

How about fixing the insert of the IFCode for text colors?...

Thanks, will make that recommendation.

Atif Sheikh (7/29/2008)

---

I dont know about the bug found in the SQL Server 2005. But I need to clear a couple of things over here,

1. The variable @ReturnID...

Ok, we've figured it out, it seems to be a bug in SQL2K5 and I will post reproducible code and our fix later.

We're still looking into the situation. Even when we changed to a "Select Into" it is still not keeping the value so it must be something besides the cursor.