Thanks for your reply. Yes, SQL 2000.

Hi Tony,

Thank you so much for your time and help. I went over the link you provided and have some questions. Please pardon my ignorance, but I think this...

Hi Lowell,

There are 3 forms (identified by SurveyID 1497, 1499 and 1500), having about 50+ questions each.

Throughout a clients' life, a client (CaseNoteID) would be filling several versions of...

Sorry bout that...

CREATE TABLE [Survey_Response] (

[ResponseID] [int] IDENTITY (1, 1) NOT NULL ,

[CaseNoteID] [int] NOT NULL CONSTRAINT [DF__Survey_Re__CaseN__4944D3CA] DEFAULT (0),

[SurveyID] [int] NOT NULL CONSTRAINT [DF__Survey_Re__Surve__4A38F803] DEFAULT (0),

[QuestionID] [int] NOT...

Hi Lowell,

Thank you so much for your prompt response. I was wondering what the LastUpdate = GetDate() was for? I tried executing the command and it gave me an invalid...