select YEAR(DATEADD(m,3,RegistrationDate)) as Fyear

,MONTH(DATEADD(m,3,RegistrationDate)) as Fmonth

This seems to be cool technic. Thanks for posting.

Thanks Hans...

Thanks to Jack, Grant and Paul for thier invaluable input. As I started learning Relational database, I did had all the foreign key relations defined. But over a period of...

"what is interesting is that every time I tried this, the procedure that I called later completed first and had the smaller OrderID, although when we call the same procedure...

Since you have already tried to debug and provided so much information, I am just curious to know whether you tried running the procedure which you have run on machine...

I am not sure whether I could help you with finding out the reason why it is happeing. But I would suggest to put 'If ' statement and return 'NULL'...

As far as SP is concerned all seems good. Maybe you can tweak it a bit to improve on performance.

1) You could store the getdate() in a variable and...

Try this

CREATE procedure proc1

@orderstatus VARCHAR(15),

@orderdate DATETIME,

@createdate...

I was wrong in answering the question. But to me it seems that Procedure name 'GO' is not the cause of concern. If I put something like this

CREATE PROC GOT...

correct me if I am wrong. The error which you are getting is

'Data source provider error: The conversion of a char data type to a datetime data type resulted...

Possibly it could be the date format which is causing the issue. When the data is in table it's taking the date format correctly.

I also feel that what steve has mentioned is correct. As lot of changes has happened between AS2K and AS2K5 it may not be possible to restore directly. If you...

When you say front end log does that mean your own log, if so then I would suggest to run the profiler and try inserting from front end & then...

Although I don't have a perfect answer to this but I would certainly try out the following things

1) Try to find the first job which hangs in your new env...