This shows how to avoid repeating the expression code withing the case statement by using a derived table in a subquery. This will work for any arbitrary complex expression.

select

a.*,

MyResult...

CH&HU (4/17/2009)

---

Dear Lowell,

I will definitely try the procedure and will keep the improvements posted.

One more question : can't we stop a user account or login account deleting the data from...

GSquared (4/17/2009)

---

Michael Valentine Jones (4/17/2009)

---

OK, as long as we are doing useless SQL, I want to add numbers together without using any Arithmetic, Logical, Assignment, String, Bitwise, or Unary Operators...

There is no problem. SQL Server is working as designed and as documented.

When you cast a zero length string to datatype of datetime, it casts it to the SQL...

OK, as long as we are doing useless SQL, I want to add numbers together without using any Arithmetic, Logical, Assignment, String, Bitwise, or Unary Operators or any Mathematical or...

select

Material,

sum(case Status when 1 then Qty else 0 end)-

sum(case Status when 0 then Qty else 0 end) as Qty

from

MyTable

group by

Material

order by

Material

Bob Abernethy (4/15/2009)

...I'm sure that the vast majority of the decision-makers in these thousands of companies are intelligent profesisonals who went through a valid decision-making process that took into account...

Maybe you should learn to use what is available in SQL Server, like REVERSE, instead of spending time duplicating what is already available.

pshvets (4/14/2009)

---

Hello all.

I am trying to write a function which reverses passed string WITHOUT using any built-in functions

So if 'abc' is passed, it returns 'cba'

I want to use recursion. Here...

RBarryYoung (4/10/2009)

---

Unfortunately Flo, the INFORMATION_SCHEMA views do not...

Theunis Viljoen (4/10/2009)...We are currently looking at encryption tools such as SQL Shield 4 as an effective encryption tool for SQL 2005. I would be interested to read any feedback...

The only time I have seen SQL Server procedure encryption used was for a vendor product.

I decrypted and looked at a few of the procedures. They appeared to have...

If you want to show a special status for a poster, you might consider some kind of SSC MVP status (Most Valuable Poster?) that you setup, instead of using Microsoft’s...

The quality of a response depends on what you say, not who you are.

This is a discussion board, not a place to receive pronouncements from on high. The value...

Lowell (4/8/2009)

---

i left them out on purpose; the format of 0 = format of 100,1=101 etc; just duplicates of the same formats; I thought it's easier to just stick with...