any other approach which will resolve this issue by using only one function or without using any functions?

y

expected output:

sorry..as i was rush from the office to reach home, i didn't use " " to the string.

But I don't want to hardcode the maximum length.

How to design the first table?

Do I need to follow the same approach which you designed for both the tables?

Gsquard,

#1 --> Curiosity to get the diffrent answer...

I need a nice trick to do this 🙂

I don't want to use

select currencypair, ccy1, ccy2

from currency_test , off_currency_pair

where (currency_test.currencypair = off_currency_pair.ccy2 + off_currency_pair.ccy1

or currency_test.currencypair = off_currency_pair.ccy1 + off_currency_pair.ccy2)

SQL Aarchitecture diagram only. As you aid, I saw different images. Thats why i confused and tired and don't know which one is officially accepted model.

In short, I need officially...

I want to achieve this without disabling FK.

is there any other way to do this?

Phil method looks ok.

Beside this, is it a good practice to design a table...

Grant Fritchey,

I don't see any topics specific to SQL 2012 in the book. I could be wrong. Can you tell where you have covered the SHOWPLAN Enhancement for SQL 2012...

But you would't necessarily find out that some of the new functions are slower than some of the tricks people had to pull to get the same job done in...

say for example,

I have a procedure in SQL 2008 & 2012.

If I fine tune the procedure in SQL 2012, I would know what are all the new "Optimiztion Techniques...

ok. got the link.

http://www.sqlservercentral.com/articles/books/65831/

Where I can find the book?

any major problems ? If so, is it not fixed in the latest version by Microsoft SQL Team?

+1.

select id,1*part1 from #cars where part1 > 0

union

select id,2*part2 from #cars where part2 > 0

union

select id,3*part3 from #cars where part3 > 0