As I understand it:

Students get marks

Marks are approved

Different universities have different approvals

It looks like you need:

Student table

Student Mark table

Student Mark Approval table

University table

University Approval table

I'm sorry, maybe I missed something.

You are inserting a row, and then are calling a trigger to update that same row?

Why doesn't the initial insert simply insert the values you...

I chose to insert the value of @cmd into the table instead of @DataSourceJobRevenue because I knew for a fact that @cmd would have a string value, seeing as how...

deekadelic (10/19/2016)

---

Sure. This is the entire code block in question:

USE [17-oct-2016_MainReport]

GO

/****** Object: StoredProcedure [dbo].[ImportJobRevenue] Script Date: 10/19/2016 11:26:06 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[ImportJobRevenue]

...

deekadelic (10/19/2016)

---

I gave this a shot, of course changing the database reference to match my DB name; but I got this error message:

Msg 137, Level 15, State 2, Line 4

Must...

deekadelic (10/19/2016)

---

I had another idea that I really thought would work; but it isn't working, and I'm not sure why.

My idea was to simply add the code "Print @cmd" on...

Also, you aren't really doing work on a production system, are you??

If this is being called from application code, and you do not have the source code, then that's going to be difficult.

If you simply want to know what value is...

djj (10/18/2016)

---

What nothing about MS SQL...

Do you really want to send an email from a trigger?

This may work well with one person performing an update, but as the number of users increase, this may very...

45 hours a day for me!

One suggestion, import then into an Access database first, then pull the data from there.

The ACE connection issues go away, and Access does a better job pulling spread...

Phil Parkin (9/27/2016)

---

Brandie Tarvin (9/27/2016)

---

SET RANT Brandie ON;

I just spent the past week working on a bug fix to get into our production systems before month end. Last night, after...

You do not have to stop it prior to shutting down your computer.

It's smart enough!

You could create a link to Services.

You could create a batch file that will start the services, and another to stop the services.