CREATE PROCEDURE USP_UPDATESAL

@DPID INT

AS

UPDATE Humans

SET SAL = CASE deptid

WHEN 10 THEN 40000

WHEN 20 THEN 38000

WHEN 30 THEN 10000

WHEN 40 THEN 0

WHEN 50 THEN -1

END

WHERE deptid...

Continuously-variable transmission

There's a rumour circulating about a pole-dancing chipmunk

mbricker-600840 (5/13/2010)

---

My wife is quite the lover of cheese. I wonder if that was involved in her choice of me as a mate.

We...

There might be some mileage in this too:

SET DATEFORMAT DMY

DROP TABLE #Temp

CREATE TABLE #Temp (Art CHAR(1), [Status] VARCHAR(3), [Date] DATE)

INSERT INTO #Temp (Art, [Status], [Date])

SELECT 'A', 'In', '10/10/2009' UNION...

turkey-500673 (5/10/2010)

---

Thanks for the great solutions, but none of them worked. I'm going to take the numerator and make 1 field and the divisor another field in a temp table,...

mukherjee.subhro (5/10/2010)

---

...the orderyear field the O/P is coming like cnt2007,cnt2008.... like that;

I want to omit this cnt portion, if you have any suggestion then please sent me by tomorrow.

I think...

mukherjee.subhro (5/10/2010)

---

Yea !

I mean what you have understood i.e. stripping the first 3 alphabet and taking only the numeric portion (i.e. year) . The output is in...

Grimouse

mukherjee.subhro (5/10/2010)

---

Hello Sir

Please look at the image file that I have send with this reply,I have run as per your suggestion removing the typecast and it...

Try it without the CAST, change

SELECT empid,CAST(orderyear AS INT)AS orderyear,numorders

to

SELECT empid, orderyear, numorders

Tom.Thomson (5/10/2010)

---

RBarryYoung (5/9/2010)

---

(how Jeff talks...

The simplest way is to avoid the calculation altogether;

c_new_PP = CASE WHEN oe_line.unit_price = 0 OR inventory_supplier.cost = 0 THEN 0 ELSE

(

(

(100 * inventory_supplier.cost * 1.1)

/ (

100.00000001 - (oe_line.unit_price...

There may be some mileage in this:

;WITH EnrollmentRollup AS (

SELECT

StudentID,

Summary = SUM(CASE ActionClass WHEN 'E' THEN 1 WHEN 'W' THEN -1 ELSE 0 END),

Actions = COUNT(*)

FROM #Enrollment

WHERE...

Paul White NZ (5/7/2010)

---

I'm quite surprised no-one has challenged some of the very close results yet because...