dwain.c (1/21/2014)

---

mickyT (1/21/2014)

---

dwain.c (1/21/2014)

---

mickyT (1/21/2014)

---

gcresse (1/21/2014)

---

One more small request 🙂 The Balance returned from the cte is the Ending balance. Is there a way I can also get...

MickyT - Using only your query that returns ending balance against mine that does the same, our two queries return a different number of rows Here's my modification of...

Or you could put this convoluted Gender computation into a computed column.

mickyT (1/21/2014)

---

dwain.c (1/21/2014)

---

mickyT (1/21/2014)

---

gcresse (1/21/2014)

---

One more small request 🙂 The Balance returned from the cte is the Ending balance. Is there a way I can also get the...

TheSQLGuru (1/21/2014)

---

dwain.c (1/21/2014)

---

TheSQLGuru (1/21/2014)

---

I think it has to be a Gaps & Islands problem, based on this statement if for no other reason:

An assignment is defined as a continual period...

mickyT (1/21/2014)

---

gcresse (1/21/2014)

---

One more small request 🙂 The Balance returned from the cte is the Ending balance. Is there a way I can also get the Beginning balance...

Ooops! I didn't see the second page of posts! Guess I got too into the fun problem.

Here's how to use LAG to get the Beginning Balance (from my...

Since the ROWS (window frame) facility added in SQL 2012 supports doing the running totals you need, many would suggest that you use it instead of a Quirky Update (QU),...

TheSQLGuru (1/21/2014)

---

I think it has to be a Gaps & Islands problem, based on this statement if for no other reason:

An assignment is defined as a continual period of employment...

I've taken the liberty of putting your sample data into a consumable form, which if you read up on forum posting etiquette (links abound for this) you'll find will be...

From my perspective, the answer is quite simple: Don't use a VIEW!

Just keep your code in-line and use the parameter passed in through whatever means you've designed (presumably from the...

I think you just need to alter your first code snippet as follows (forget about timestamp) and use a CASE:

UPDATE @TEMP

SET TheStatus = CASE TheStatus WHEN 1 THEN 2 WHEN...

allarmi and sneumersky:

I hope you found my ramblings useful. In the future, one can hope that error handling capabilities will be improved upon but for now it is what...

Symptom name is just the column name right?

Focus on the code I've embedded in the (SQL) string creation to...

MickyT's FUNCTION should work like this with your table replacing SampleData:

WITH SampleData AS

(

SELECT code=CAST('12333345566689333' AS NVARCHAR(4000))

UNION ALL SELECT '12333345566689'

)

SELECT *

FROM SampleData

CROSS APPLY...