nevermind : I found the problem and it's fixed.

Sam

how can I modify usp_Prognote_Insert to return the value of the PK if a record already exists?

This doesn't seem to work:

CREATE PROCEDURE usp_ProgNote_Insert

@SecondaryKeyValue int

, @EmpName...

Thanks so much. Believe it or not, I spent an hour on Google and never could get a clear example to work from.

sorry, should have supplied that to begin with:

CREATE PROCEDURE usp_ProgNote_Insert

@SecondaryKeyValue int

, @EmpName varchar(150)

, @PrimaryKeyValue int OUTPUT AS

IF EXISTS

(SELECT

pn.AppointmentID

FROM ProgNote pn

WHERE pn.AppointmentID = @SecondaryKeyValue

)

RETURN

INSERT...

You've helped me several times, Jeff. Thanks!

thanks very much. I've got it licked.

Sam

Thanks,

Next question is if the return data is null, how do I set the declared variable to '' (empty string)?

Here's what I have so far that's not working:

SELECT @FHComm=p.TextBody

 FROM PartyText...

Thanks so much. THe problem is on the frontend afterall.

it works. thanks

Thanks, Jeff. You know you're talking to a rookie. Or at least not a real SQL person. I will format on the frontend as you suggest.

and display just the time part of a datetime: "4:15pm" ?

sorry for the unclear question. I've got it worke out. Thanks so much.

Thanks! I will test both

table def:

CREATE TABLE [dbo].[AilmentDetail] (

 [AilmentDetailID] [int] IDENTITY (0, 1) NOT NULL ,

 [AilmentID] [int] NOT NULL ,

 [DataPointID] [int] NOT NULL ,

 [DataValue] [varchar] (200) NOT NULL ,

 [DateStart] [smalldatetime] NULL ,

 [DateEnd] [smalldatetime] NULL...

Really appreciate the help. Thanks!

Sam