I've only been to 2 SQL Saturdays.

For the first one I had to travel 130 miles (209km) to Orlando on 2012. We went to Disney World on Sunday, so we...

TomThomson (7/28/2016)

---

jasona.work (7/27/2016)

---

Luis Cazares (7/27/2016)

---

It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not...

So, are you good now?

Why does record_id 2 ends up with value 'col1' for colname?

Have you tried using MAX() and MIN() to aggregate rows?

This is interesting. I'm not sure if that's a bug or a feature. I would be inclined to call it a bug.

Una de las formas más...

It's exhausting to write translated posts. I hope I'm not saying any nonsense as I'm a bit outside my common knowledge (referring to DBA tasks, not Spanish :-D).

Douglas Rosa

---

Hi I would like to go back to the traditional design of one mdf file and one ldf file, to be able to migrate my enterprise edition to a...

This is another option:

SELECTAPPLICANTS_ID,

APPL_CURRENT_STATUS,

APPL_CURRENT_STATUS_DATE

FROM APPLICANTS

OUTER APPLY( SELECT TOP 1 *

...

This is one option:

WITH CTE AS(

SELECTAPPLICANTS_ID,

APPLICATIONS_OCC.APPL_CURRENT_STATUS,

APPL_CURRENT_STATUS_DATE

...

The most important part. How do you define the file has junk data?

Or you could use a table with all possible values.

Here's an example on how to create it.

CREATE TABLE Weeks(

WeekCode int,

...

¿Por qué quieres poner una limitación al diseño de la base de datos? El tener distintos filegroups y archivos te permitirá tener un diseño físico más flexible y puede facilitar...

Your response is translated correctly. I was going to reply but I haven't reached my computer yet.

Or you could try SQL Search (free product): http://www.red-gate.com/products/sql-development/sql-search/