Deprecated means that Microsoft has announced that the feature "will be removed in a future version".

(And based on my experience with some deprecated features, the actual description should probably read...

Scripts are loaded and executed by the application code, not by SQL Server. The only thing SQL Server sees is batches of statements being submitted.

So no, there is no way...

Note of warning to ramachandran narayanan:

The solution posted by chalam87 (which is about equal to a solution posted to one of the other locations where you asked this question) will...

First two hits on Google:

https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model

http://programmers.stackexchange.com/questions/93124/eav-is-it-really-bad-in-all-scenarios

If you want more help to get...

Based on the title I am going to assume that you actually want to update data in a table.

You already got some very clever solutions based on smart calculations using...

Here is a post that (a.o.) explains the risks of using SET TRUSTWORTHY ON: http://sqlity.net/en/1701/the-trustworthy-database-property-explained-part-2/%5B/url%5D.

It also explains that in most cases, using the TRUSTWORTHY property is not required. Just easier.

Ed Wagner (2/1/2016)

---

All these questions on different forums and no clear definition of how to build the output. Posting how to...

(deleted - had not read the post well enough so my response made no sense)

movvap (2/1/2016)

---

Thanks Hugo!

So, if I understand using N in front of the single quotes like N' ' is recommended as oppose to just the single quotes with...

Orlando Colamatteo (2/1/2016)

---

sqlinterset (2/1/2016)

---

I have a transnational table which every time dropped and created in a job to get updated data.

Earlier there was no index, but now one non-unique, non-clustered...

(Emphasis mine)

And there's the rub. A NULL is not data. A NULL...

You were not rude, just incomplete.

And you still are. Please check out the link J Livingstone posted. Then post sample data (CREATE TABLE and INSERT statements) and expected results.

Make sure...

Have you tried Right(Expression, 20)?

movvap (2/1/2016)

---

Thanks John and Ed!

I just ran the below query with out the N in the country + ' ' + coalesce(region, N' ') + ' '+ city...

Yes, this can be done. Based on my understanding of your requirements, you would need the following ingredients:

* Two CTEs. One for the code 1 rows, one for the code...