Check out the section under Limitation and Restrictions. https://msdn.microsoft.com/en-us/library/ms191320.aspx 
I have to ask what are you trying to get out of a UDF that you are not getting...

With this single column the only thing you could specify is alphabetical order (or reverse). Does the table have any other columns? Identity? Timestamp?

EDIT: Here is an example of...

Eirikur Eiriksson (12/7/2016)

---

Eric M Russell (12/7/2016)

---

Think of a database table as a library shelf containing books. When you pull a book from the shelf, the self doesn't get smaller. It...

Weak

Is this against a production database? Sounds like you need a Data Warehouse solution (OLAP).

halifaxdal (11/25/2016)

---

Thank you very much.

Your script use MAX instead of SUM, is it a typo or is there any consideration?

New testing result:

1. The new script (MAX or SUM) returns incorrect...

halifaxdal (11/25/2016)

---

Thank you very much for the revised script which is amazing, the result returns lots of NULL for WeekNo fields, how can the script be modified to get that?

I...

Unless you were using the WeekTable to filter weeks then you technically don't need it. Either way since the values didn't line up I didn't end up using it.

Here...

Thank you, that is much better. Notice though your second script has a syntax error.

It should 'VALUES' NOT 'VALUE'

Unfortunately, because of the delay I won't be able to look...

While I do appreciate the effort that is not what I mean. You should post code that will allow me to query the data directly.

If you need an example...

You can do this using Dynamic SQL with a Crosstab. If you'd be willing to provide consumable data I could give you an example on how to do that.

The following code has two purposes.

1. It demonstrates an example on how to post code so that we can help you. (Please read previously provided link for more info)

2....

Yeah, they had to let go of the sommelier a...

Damn....we have a water dispenser. LOL :w00t:

Luis Cazares (11/18/2016)

---

Dear Santa,

I know you won't be able to bring me a new laptop this year, but could you just bring more RAM (and a new HDD) for my...