You seem to have a CROSS TABS or PIVOT problem that you're trying to solve using a CURSOR :sick: .

Reviewing your code, you're adding an integer to a varchar...

You can't chage that code to make it set based. You need to change the code from usp_make_record to accept several rows at a time.

Catch it before it...

You might want to take a look at the OVER Clause.

Here's an option that you could use. Be sure to understand what it does before implementing it. If you have any questions, feel free to ask.

SELECT e1.RISK_FACTOR,

CASE WHEN RISK_FACTOR =...

Congratulations!

sqldriver (2/21/2014)

---

Luis Cazares (2/19/2014)

---

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the...

That is usually solved like this:

WITH CTE AS(

SELECT id, id - ROW_NUMBER() OVER (ORDER BY id) grouper

FROM #test1

)

SELECT MIN(id) min_id, MAX(id) max_id

FROM CTE

GROUP BY grouper

ORDER BY min_id

I just noticed that...

To be fair, (s)he might be in a different time zone.

You're welcome.

Do you understand how and why it works?

I also missed the link in my previous post. Here it is: How to Make Scalar UDFs Run Faster (SQL Spackle)[/url]

Duplicate post answered in here: http://www.sqlservercentral.com/Forums/Topic1543925-391-1.aspx

Here are a couple of options that you could try.

SELECT t.id,

t.[FILE_NAME],

CASE WHEN NOT EXISTS( SELECT 1 FROM test1 x WHERE t.id = x.id + 1)

THEN 'D' ELSE 'F'...

It's great to read all that. If you need more help, don't hesitate on coming back. We're here to help and hopefully you'll end up helping once you get used...

jshahan (2/20/2014)

---

Yet another had her own form of on-line help: Turned out she was calling her boyfriend for technical assistance when we left her alone. At least she turned...

Thank you! It became clear after realizing it wasn't a running total.