But nowhere is there any check for

"if the user id already exists in the database".....

isn't the requirement that the procedure return -1 if the userid exists and if not...then...

oh good - always nice to get feedback!

as for "speedy response" - I must tell you that on this site people "fight" with each other to get their responses in...

You mean - other than Query Analyzer ?!

Yogender - under Enterprise Manager - if you right click on the table that you created the trigger on - you can go to "manage triggers" - select the trigger...

surya - you didn't mention in your original post that you wanted to merge 2 databases into 1  - as it stands your way may be the best way!

Well - Tony would first have to fight George if that happens as I'm sure he'd (dubbya ie) want first dibs at meting out appropriate justice...

Hi - if you want the syntax for a trigger on tbl_REJ it would be something like this:

CREATE TRIGGER InsertNumber ON tbl_REJ

FOR INSERT

AS

DECLARE  @NumberID         Int

SET @NumberID = SELECT MAX(IDfield) from Inserted

OR

SET...

I meant to keep away from this forum as it is more interesting than work - hence takes up "productive time"!

However I am...

Also - what is the A&E number data type and how is it generated ?!

It should be possible to extract the Patient information and insert into the Patient table that Phil...

I'm confused...if you insert something then your rowcount is going to be greater than 1 and your procedure is going to return -1

And where in the procedure does it say:

if...

maybe it's set to single or restricted user ?!

you could check with "select DATABASEPROPERTYEX('abs', 'useraccess')....

also, what about your permissions ?

Mark - please take a look at the DATEADD SQL date function on BOL - it's tailormade for your requirement....

You would do something like : "SELECT DATEADD(wk, 6, getdate()) AS...

Only a couple of things come to mind:

are you by any chance creating a temp table on the fly or do you already have a table in your database ?!

also,...

sorry - don't know any cold fusion...

what does "#listlen(form.option1values, chr(13))#" do ?!

could you pl. post the snippet of code that generates the SQL - incl. variable declaration ?!

Also, how are you parsing your string ? - the length must be...