Please post DDL and sample data to be able to test different possibilities. Be sure to post the expected results based on that sample data.

WayneS (9/21/2015)

---

Anyone good...

Why did you open this other thread for the same problem?

http://www.sqlservercentral.com/Forums/Topic1721196-391-1.aspx

It only divides the answers and multiplies the efforts of people helping in here.

You overcomplicate things, Ben. It can all be done in a single query.

This won't solve the whole problem, but it can show how it could be done.

--

-- Create a table.

--

select...

WayneS (9/21/2015)

---

Kristen-173977 (9/20/2015)

---

GilaMonster (9/19/2015)

---

protecting against SQL Injection is done, in most cases, by ensuring that it is parameterised, except for the rare scenario where the user input can be...

That's easier, just remove the GROUP BY (and HAVING) clause as that's only needed if you want to exclude the job numbers that have both operation codes.

You could change your function to an iTVF (inline table valued function) which should be faster.

Something like this:

--Added an i as prefix to prevent code malfunctions where the original function...

Here's a simpler option to Scott's query that can be easily converted to the second report.

SELECT

J.DT_ID

,J.OperationCode

,J.EmployeeCode

,J.JobNumber

FROM...

You might expect that '090471' is equal to '90471' because they have the same numeric value. However, they're different strings.

Here's a code that removes leading zeros to solve this problem....

Alvin Ramard (9/18/2015)

---

Jack Corbett (9/18/2015)

---

Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is set-based and...

I completely understand, that's why I mention that it only complies with part of the requirements. However, I wanted to show a better option that will actually help in the...

Because T-SQL doesn't like to have flow control.

Don't forget to remove THEN, this isn't VB. 😛

Why do they keep teaching this kind of stuff? http://www.sqlservercentral.com/Forums/Topic1720978-169-1.aspx

Then people wonder why there's crappy code everywhere.

WHAAAAAAT????? :w00t:

That's actually the best way to return the values by using a cursor....

This is a slightly different way. But it will also give different results depending on the data.

Be sure to know what you want.

WITH BASE_DATA AS

(

SELECT

...