In the trigger code presented by segiy, any applications and users are inserted into their respective tables with every run, if they are found not to exist yet:

INSERT INTO dbo.Audit_User...

Jason A. Long (5/16/2016)

---

RV16 (5/13/2016)

---

Thanks.

You mean If I want to count number of students according to crs_cde then I should write like this

count(sch.id_num) OVER (PARTITION BY ss.CRS_CDE) "No of student"

I...

reported

reported

I have some idea of where you're probably going wrong, but indeed, having your tables in a test database on my machine would make it so much easier to show...

reported

reported

reported

and yet it is still lots better if you would get rid of the cursor. I know it is easy to stop now, but you should REALY do without that...

Hello b.grove,

Which of those tables are 'the 3 document tables' you refer to? And what are the column names that indicate their version?

Lynn Pettis (5/12/2016)

---

Thought I'd reformat your code some and replace the 3-part naming convention you used with 2-part naming using table aliases. This is important as Microsoft has deprecated...

The other replies about cursors being slow are all completely correct, so better steer away from them using almost any alternative given. But the original problem is probably rather easily...

J Livingston SQL (5/9/2016)

---

Sergiy (5/9/2016)

---

Sorry, did not...

Seriously, I see it was suggested before, did you have a look at CDC (Change Data Capture)? BOL: https://msdn.microsoft.com/en-us/library/cc645937.aspx. This technology provides -though only available in the enterprise and...

I know this doesn't answer your question, but why don't you just generate your statements as nvarchar(max)? You'll be giving the dynamic sql generated as a parameter into sp_executesql (bol)...