I'm posting the function again with some comments. Hopefully those comments will help you understand how the query is working. I should strongly recommend that you read the following article...

flake

ninamahezi (10/25/2016)

---

Hello,

I want a sql function that will allow to make one update but with several replace on the same column.

For exemple

Replace the space by vacuum('')

...

Please post DDL, sample data and expected results. If you don't know how to do it, read the links in my signature.

.Patrick (10/24/2016)

---

Hi all,

Currently we are developing a new application for our company and I got a question related to the database architecture. We one database (DatabaseA) that is our main...

Book

Here are 2 options, depending on what you want. It's simulating a calendar table, but you might want to consider a full calendar table in your system to make some...

Do you need to include all dates? Or just the dates with bookings? The solution could be slightly different.

AIRWALKER-375999 (10/24/2016)

---

Thom A (10/24/2016)

---

If you are using your above logic, ensure you change your Current DOB logic as well. Otherwise, you'll notice that some other current ages will be wrong...

A different approach, just for the sake of having options.

WITH CTE AS(

SELECT *, RANK() OVER( PARTITION BY col1, col2 ORDER BY col3) rnk

...

Here's an option. It seems a bit odd this requirement. The ORDER BY in the ROW_NUMBER function should probably be changed.

SELECT

MAX( CASE WHEN rn...

If you have the logic for today's age, you have the problem solved. You just need to change the way you approach your solution. In six months, they'll be the...

There's no way to order the data as it is, so there's no way to ensure a consistent ordered result without hard coding values.

Jeff Moden (10/23/2016)

---

The correct answer is only a 1/4 correct. You also have to enable advanced options and RECONFIGURE twice (once for the advanced options and once to enable...

Chris Harshman (10/21/2016)

---

Maybe I'm missing something, I'd...