You may want to give this blog post a quick perusal.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/05/07/comparing-hardcoded-functions-in-line-tvf-s-and-scalar-functions/

Eirikur Eiriksson (8/22/2014)

---

Nice to see that you are having a friendly chat with your...

Looks like a combination of upivot and pivot may work. Just don't have time to play with it at the moment.

rxm119528 (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

One, please make sure to test your code in an empty database prior to posting.

Two, the following works:

--===== If the test table already exists, drop it

IF...

But I understand what my query is doing easier than Chris's Q4. The parens make the order of the joins visually apparent. The other...

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the count of insertion...

And Mr. Celko is back with his baseball bat. :Whistling:

In more than one thread. :Whistling:

One, please make sure to test your code in an empty database prior to posting.

Two, the following works:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#Table1') IS NOT...

ChrisM@Work (8/22/2014)

---

Here's something I wrote some time ago (inspired by something Jack Corbett wrote years ago) which explains why you have two joins followed by two ON clauses:

The order of...

Eirikur Eiriksson (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Even if you use a natural key as the primary key, I would still consider adding a synthetic id to the tables and making it a...

Even if you use a natural key as the primary key, I would still consider adding a synthetic id to the tables and making it a non nullable unique index...

Not a lot of info from which to work. Your best bet is to use your latest backup to recover your database.

Ryan Keast (8/21/2014)

---

Thanks guys for the help so far.

I've discovered that what I thought was a potential link actually isn't so after all your advice it's not going to help...

Eirikur Eiriksson (8/21/2014)

---

Lynn Pettis (8/21/2014)

---

It may be...

It may be but it isn't necessarily...