hlsc1983 (2/23/2016)

---

k here is my SUBJETCS table so far.

subject_id(pk) int ,

subject_name varchar(),

subjectTHET bit,

subjectTHPA bit,

subjectPRET bit,

subjectPRPA bit,

Each subject may have four types of grades associated with it.(subjectTHET, subjectTHPA, practicalET, practicalPA)

the four...

Ed Wagner (2/23/2016)

---

That is interesting, isn't it?...

I am shocked at how many people (9% at time of this post) said there would be 4 rows. :w00t:

Excellent question Steve.

Is this procedure using transactions? They can seriously bloat your logs if they are large. Kind of grasping for straws here. Are you able to get an actual execution plan...

marin-231997 (2/22/2016)

---

Hello Sean,

many thanks for the quick reply.

It is a 3rd party software (interface engine) that processes the CSV file and sets the value in the placeholders before running...

Can you explain "doesn't work"? What doesn't work? The code posted by LinksUp looks like...

marin-231997 (2/22/2016)

---

Hello all,

I have encountered following problem lately:

when an insertion script is done via

INSERT INTO myTable (col1,col2,col3) VALUES ('TEST1','TEST2',NULL)

the value NULL will be somehow automatically embedded in square...

Luis Cazares (2/22/2016)

---

Sean Lange (2/22/2016)

---

TSQL Tryer (2/22/2016)

---

ALTER PROCEDURE [dbo].[usp_test_Arrears_BrokenArrangement]

@PolicyId INT, @AccountId INT, @PolicyNodeId INT, @output BIT OUT

AS

BEGIN

SET NOCOUNT ON;

SET @AccountId = 1

DECLARE @CurrentArrangement as bit

DECLARE @LastSystemActionId...

BL0B_EATER (2/22/2016)

---

Sean Lange (2/22/2016)

---

My wife has one as her work...

I do think your logic could be greatly simplified into a single select statement instead of all these variables though. A simple case expression could make this a lot simpler.

TSQL Tryer (2/22/2016)

---

ALTER PROCEDURE [dbo].[usp_test_Arrears_BrokenArrangement]

@PolicyId INT, @AccountId INT, @PolicyNodeId INT, @output BIT OUT

AS

BEGIN

SET NOCOUNT ON;

SET @AccountId = 1

DECLARE @CurrentArrangement as bit

DECLARE @LastSystemActionId as int

DECLARE @ActionDate as...

Perhaps if you share what you tried or even the error...

Of course you can. Did you try it?

Ed Wagner (2/22/2016)

---

Sean Lange (2/22/2016)

---

My wife has one as her...

My wife has one as her work laptop now. She...