Assuming that you really do need to do this, what about using a cursor?

CREATE PROCEDURE FinancialAidAwardReformat

AS SET NOCOUNT ON

DECLARE @StudentID  char(9)

DECLARE @Lastname varchar(50)

DECLARE @Firstname varchar(50)

DECLARE @FiscalYear char(9)

DECLARE @Field3 int

SELECT @Field3...

Set an output parameter and pass the identity value to it, as follows:

CREATE PROCEDURE upd_DLCourseOneStudent

 @SocialSecurityNumber char(9),

 @CourseNumber varchar(50),

 @Semester  varchar(50),

 @NoOfCredit tinyint, 

 @DLCourseID int OUTPUT

INSERT INTO tblDLCourses

 (SocialSecurityNumber,

 CourseNumber,

 Semester,

 NoOfCredit)

VALUES 

 (@SocialSecurityNumber,

 @CourseNumber,

 @Semester,

 @NoOfCredit)

 SET @DLCourseID = @@IDENTITY

 

For reference tables, I use a suffix of "Lookup".  Had I to do it over again, I would have used a special prefix instead so that the lookup tables would...

Regarding the post "A lot of places require the use of stored procedures for data access, and use prefixes of sps_, spi_, spu_ and spd_ which potentially clashes with system...

I agree with some of the ideas in the article, but I hate underscores in table field names.  Capitalizing each word within the name is just as readable and much easier...

We back up our transaction log every fifteen minutes during the business day and do a full backup every night when the system is quiet.  Admittedly our database is fairly...

If you have Enterprise Manager, you could script the SP's and then play back the script on the new server.

To script, right click on the database, select "All Tasks", then...

Why not keep copies of the transaction records in a permanent SQL table instead of destroying or discarding them once the Master table has been updated?  How did Access get...

What page?  Are you in Query Analyzer?  We need more information.

Is SQL Agent running?  If it is not running, your job won't start.

It would help if your subject heading gave a clue as to what your problem is.  "Serious Problem" could be anything from a coding error to a flat tire!

How about...

Make sure you set the user's default database to be a database OTHER THAN Master.  That way, Master will not show in Query Analyzer unless explicitly chosen.

Maybe it's time to upgrade your Microsoft Office to the Professional version of 2003, which does have XML capabilities.

If at all possible, try to avoid giving fields the same name as a "reserved" word like "datetime" - it makes for very confusing code.  Does the stored procedure even...

If your reporting product is Crystal, you can reset the data source at runtime from the front end.  If all you want to do is change the DSN, then you...