Oracle organizes certain free events. You might find some information in http://www.oracle.com/technetwork

Those include Oracle database, MySQL, Java and probably other Oracle products.

The max lotjob for the groups of [StockCode], [SalesOrder], [SalesOrderLine] might not be the same that the one in your filter.

In the first query, you're returning all the groups that...

You can use a CASE statement for that. Remember that a column can only have one type, so if you want to return an empty string, you need to return...

Just one comment on number 10

Elegant SQL often boils down to the same query plan as awkward-looking SQL. Don't be fooled into believing you can make SQL queries run faster...

jasona.work (2/17/2016)

---

SQLRNNR (2/16/2016)

---

Luis Cazares (2/16/2016)

---

SQLRNNR (2/16/2016)

---

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

I might have lost my composure in my last reply.

I wonder if Java developers go to...

I'm just curious to know what's wrong with the solution that I posted.

Alan.B (2/16/2016)

---

If there is a possibility that OccurrenceTypeName will contain any of what SQL Server considers XML characters (e.g. CHAR(1) through CHAR(32), CHAR(38), CHAR(60) or CHAR(62)) then you would make...

Maybe you haven't done the correct posts. I've just been...

SQLRNNR (2/16/2016)

---

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

I might have lost my composure in my last reply.

I wonder if Java developers go to C# forums and then...

Sean Lange (2/16/2016)

---

Luis Cazares (2/16/2016)

---

I might have lost my composure in my last reply.

I wonder if Java developers go to C# forums and then say that the provided code...

I might have lost my composure in my last reply.

I wonder if Java developers go to C# forums and then say that the provided code didn't work.

I'll give you some advice since you say that your new to this....

This article might be what you're looking for:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Here's an example based on that article:

SELECT

ot.Occurrence_ID,

ot.OccurrenceName,

STUFF( (SELECT ' '...

Chitown (2/16/2016)

---

We have a job which runs daily at 8 AM in the morning but sometimes, the job is disabled and for days I don't get notifications and I assume...

Nightwing