ChrisM@Work (12/15/2016)

---

Luis Cazares (12/15/2016)

---

I've never written an iTVF using parenthesis around the query. However, the other answers were completely wrong and the correct answer states that it can not that...

I've never written an iTVF using parenthesis around the query. However, the other answers were completely wrong and the correct answer states that it can not that it must.

After answering,...

That would...

Lynn Pettis (12/14/2016)

---

Luis Cazares (12/14/2016)

---

Just a word of caution.

Handle the quotes correctly on Scott's and Lynn's examples. You might end with strings with the value 'NULL' instead of NULLs for...

Just a word of caution.

Handle the quotes correctly on Scott's and Lynn's examples. You might end with strings with the value 'NULL' instead of NULLs for the columns. Or you...

Search for CROSS TABS and Pivots.

Here's an article that might help: http://www.sqlservercentral.com/articles/T-SQL/63681/

Also search read about EAV and why this design is a bad idea. Then change it if possible.

I would just handle everything with ISNULLs and forget about CASE.

CREATE TABLE POS_CODEVALUE(

code char(3),

...

This is one of the cases when the performance problem comes from the DDL. You could create computed columns and lookup tables to improve this query. However, that's a suggestion...

Goldmember

You could use a cross tabs approach. It's simple and should give you what you need.

CREATE TABLE dbo.Zusatzfeld(

Bold_ID int,

WertDatum datetime,

...

Those are not the expected results. Actually, there are no results. Be sure to run the code.

Are you sure that you're using SQL Server 2005?

What happens if you run the following?

SELECT @@VERSION

Apparently, Eirikur has the crystal ball.

It took me a couple of harsh posts to make the OP confess and demonstrate Eirikur's statement.

It means that data sets are not ordered.

If you want to be able to compare them, you'll have to sort them.

If you need them to have a certain order for...

Here's a basic process I wrote for encrypting other values. However, you shouldn't decrypt your passwords, you should just compare the hashes. Otherwise, it's a security vulnerability.

Process:

1)Create the Master Key

•CREATE...