Jeff Moden (2/20/2014)

---

cms9651 (2/20/2014)

---

I tried this:

SELECT

case when ([ENER1] + [ENER2]) / 1000000 > 1 then

cast(Cast(Round(( [ENER1] + [ENER2] ) / 1000000, 2) AS NUMERIC(9, 2)) AS VARCHAR(10))

else

'0' + cast(Cast(Round((...

Can you provide some insight as to what you want? Of...

cms9651 (2/20/2014)

---

I tried this:

SELECT

case when ([ENER1] + [ENER2]) / 1000000 > 1 then

cast(Cast(Round(( [ENER1] + [ENER2] ) / 1000000, 2) AS NUMERIC(9, 2)) AS VARCHAR(10))

else

'0' + cast(Cast(Round(( [ENER1] +...

What have you tried? Put some effort into this. Remember you are the one with the database where you can run this and you are the one collecting a...

What topic is that???

montecarlo2079 (2/20/2014)

---

That article gave me a start but I dont need to sum any data,

I just need to display it in the fashion above. no calculations

maybe i didnt read...

You really should be doing this type of stuff in the front end. SQL is...

montecarlo2079 (2/20/2014)

---

Hello I have a problem, well 2 problems.

I have a table that looks like this.

Product ID| Sequence #| Code

12345 | 01 ...

Probably just need to cast your calculation.

I used a formatter on this first so it was easier to read.

SELECT Cast(Round(( [ENER1] + [ENER2] ) / 1000000, 2) AS NUMERIC(9, 2))...

http://www.connectionstrings.com/%5B/url%5D

They have details about every possible connection string possibility you can come up with.

born2achieve (2/19/2014)

---

Hi Sean and Luis thanks for the reply

Hi Luis,

I am sorry, small mistake i made. i did correct on my first post.

for example if i pass "Cooking Waffles"...

Not sure what you mean that left join gives bad result.

This is not ideal because of the wildcard search but it does work.

declare @SearchVal varchar(50) = 'sugar';

with Cooking as

(

select...

N_Muller (2/19/2014)

---

Thanks for the answer.

What would be the benefit of creating a non-clustered PK on IndexID and a clustered index on ID1, ID2 and ID3 over the other two options?...

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the code without correlated...