ling ming - am addressing ONLY the error portion...

"[MICROSOFT][ODBC SQL SERVER DRIVER][SQL SERVER]Violation of PRIMARY KEY constraints '..._PK'. Cannot insert duplicate key in object 'Table_name'"

Somewhere a piece of code is...

You have 2 FROM statements...

Don't know what this is:

"FROM (Select tr.Id as TestRequestId, p.FirstName, p.FullAddressName, a.AddressLine1, a.AddressLine2, a.Town, a.PostCode, p.FullLegalName, h.Id AS HerdID, ttli.Name AS TestType,...

The formatting's all off so your post is one long line...

however, if you want to check if your code is successful then @@ERROR should return 0.

If you have several statements...

sachin - as far as I know the only way you can preserve and display formatting is by using an image datatype.

As Brendan points out - I tried using an...

Ling Ming - can you please describe briefly what you want to accomplish!

WOW! It took a lot of courage to say and do what you did (last day - 10 minute window or not)...

Unfortunately PeopleSoft doesn't seem to be very different from...

The first request for an ado function has been addressed in one of the other forums.

The second one should be:

UPDATE table1

SET b1 = B.b1,

c1 = B.c1,

...

Here're some links for you - the first seems to have what you want!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=183331#bm184520

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=181191#bm181614

Vidya - I don't have time to analyze your problem but your syntax seems to be incorrect in the last line...

try : SELECT @cTAGVALUEText = REPLACE(@ParaInd, '', '@' + @ParaValue)

Steve - I sent you a personal msg through scc...everytime I try to send an email to anything@sqlservercentral.com it bounces back...

fyi - the msg I sent you pertains to both...

I'm not really sure I understand your question but can you not ensure that something is selected from the dropdown box when the user tries to enter "other data" -...

Michael - I read on one of the sites that you can enable impromptu log in [Impromptu - Audit Configuration] and if it is a database connection error you will...

Ryan - I don't have the time to check the exact syntax but your editor should be able to help you along...here's something to get you started...

Private Function KeyFields(strTable As...

It seems that you have a default constraint on that column. Remove the constraint and alter the column to accept Nulls.

These may seem obvious - but are you using system dsn (as opposed to user) & are you referencing the dsn name in your connection string (& not the db...