Gazareth (1/26/2013)

---

Move the conditions on ACTION_TYPE_ID and GROUP_ID out of the WHERE clause and into the LEFT JOIN - they're excluding the 0 rows from the results.

That should do it,...

Unfortunately you haven't provided enough information to really help you. Please read the first article I reference below in my signature block. Follow the advice in that article...

And I have to disagree with you. Software can be engineered, just like any other project. Whether or not it actually is happens to be another people problem,...

Sean Lange (1/25/2013)

---

Lynn Pettis (1/25/2013)

---

Sean,

@BatchID should have been @BranchID in the sp_executesql statement. That was a type.

Regarding @params = @Params, quite legal. From MSDN (emphasis is mine, and...

Sean Lange (1/25/2013)

---

momba (1/25/2013)

---

Lynn Pettis (1/25/2013)

---

Sean Lange (1/25/2013)

---

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will...

bitbucket-25253 (1/25/2013)

---

Here is another method .... not efficient .... not recommended ... but it does what you seem to need to do.

DECLARE @BegYr INT = 2013

...

momba (1/25/2013)

---

Lynn Pettis (1/25/2013)

---

Sean Lange (1/25/2013)

---

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will cache your...

momba (1/25/2013)

---

... I came across one last issue. How can I make the " While @loopYrbeg < year ( getdate() )" statement conditional?

More specifically IF month ( getdate() )...

Sean Lange (1/25/2013)

---

Depending on how often you will be running this query you might consider using sp_executesql instead of the more generic exec. It will cache your execution plan and...

This:

declare @StartYear int = 2007,

@SQLCmd nvarchar(max);

with quickTally(n) as (select top(year(dateadd(mm,6,getdate())) - @StartYear - 1) n from (values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10))dt(n))

select

@SQLCmd...

10e5x (1/24/2013)

---

Hi lynn,

Not sure if u will see this. I deployed my system using your solution to the UAT. Everything works great. The solution was efficient. However after some round...

Okay, I took the time to do what you should have done. Take a close look at the code below and see how I set things up to work...

FYI:

SET DATEFORMAT YDM

SELECT ISDATE('2012-25-12') --> true

SELECT CAST('2012-25-12' AS DATE) ...

Steven Willis (1/24/2013)

---

ISDATE isn't quite in sync with all of the date datatypes. I just think it's prudent to prevent an unexpected failure of a procedure to check an alleged...

Good. Now, if you would please post the code you are are using, not just refer me to my old code, we...