OLSONEJ (6/29/2015)

---

I have a data set (snippet below) and I need to count the number of consecutive years based on a date in time for each ID as represented below.

ID...

I have a hard time believing that any business could afford...

dandenise316 (6/28/2015)

---

SELECT

SUM(((CASE WHEN

o.date>= a.activity_date, other filter condition, other filter condition

THEN

(select d.balance from drawtable d where d.date < a.activity_date order by d.date desc limit 1) - ( select d.balance from...

sayedkhalid99 (6/28/2015)

---

how to round the nearest value after round of decimal and return integer. thanks.

declare @data decimal(18,2)

set @data = 5.55

-- output

select '5'

set @data = 5.58

-- output

select...

There are a couple of things about the original script that bring up questions. The primary one is that the values that will end up creating the column...

Time for me...

Jacob Wilkins (6/26/2015)

---

In 2012 you still have to enable 2371 to get the new auto update behavior. It's easy to confirm following the same methodology as used here: http://www.sqlskills.com/blogs/erin/understanding-when-statistics-will-automatically-update/.

I just...

djj (6/23/2015)

---

sgmunson (6/22/2015)

---

It's always good to understand what code does before...

nick.johnson 39251 (6/26/2015)

---

Hello all,

new to the forum so if this is the incorrect place, I apologize. New to SQL and having issues with getting my data the way I...

Right now, my code groups...

taseedorf (6/26/2015)

---

THis is my code.. how do I get the variables in the cursor, set statement, to NOT update the temp table with the value of the variable ? I...

I'm quite sure a cursor...

Could be disk drive corruption, affecting that DLL.... Without anything else to go on, this is totally a SWAG (scientific wild-a$$ guess).

JKSQL (6/26/2015)

---

I see where you are going with that. This was a simple example. We are inserting many rows and have an identity field. We use the...

Reported as SPAM.