GilaMonster (12/19/2012)

---

If I may suggest...

If this is just for experimentation, that's fine. If this is a design for an app, just don't do this. You're opening yourself to all sorts...

Bhuvnesh (12/19/2012)

---

xmozart.ryan (12/19/2012)

---

Bhuvnesh (12/18/2012)

---

What yiu actually need here...

Bhuvnesh (12/18/2012)

---

What yiu actually need here the query...

rhythm.varshney (12/17/2012)

---

xmozart.ryan (12/17/2012)

---

i knew it, those triggers is works until i added the Instead Of Update trigger on that table,,,

but b'coz i dont understand too much about instead of...

i knew it, those triggers is works until i added the Instead Of Update trigger on that table,,,

but b'coz i dont understand too much about instead of update function,...

CREATE TRIGGER tg_update_stok_dn_reject ON dbo.t_delivery_notes

FOR UPDATE

AS

/*

fungsi: update status stok '40'-Good Received from Customer, I0050=in from customer reject

author: erlansyah

*/

DECLARE @DNid bigint

DECLARE @DNno varchar(15)

DECLARE @mat_code varchar(15)

DECLARE @unit_conv...

but, i've created a lot of trigger that used for updated using INSERTED and take no effect..

:doze:

dwain.c (7/24/2012)

---

The code you posted is likely to perform better than any looping/dynamic script you can create.

If you just want to do it as an exercise, that's fine. But...

Kingston Dhasian (7/25/2012)

---

As Dwain has already said, the hard coding method, though tedious is the best for Production and quite readable

I have presented below the code to do it using...

yup..

here's the code..

SELECT purchase_id,mat_code,qty,require_by,require_desc,scheduled,

SUM(ISNULL((CASE WHEN datepart(day, require_date) = 1 THEN qty ELSE '0'...

dwain.c (7/24/2012)

---

I'm using the cross tab approach and it's quite easy to construct with copy and paste.

Read my mantra and avoid loops when they're not necessary. It is better...

dwain.c (7/24/2012)

---

Using only the stone knives and bear skins available in SS2K, I think this will run without error on that ancient platform, and may produce something somewhat close to...

dwain.c (7/23/2012)

---

OK I see the DDL now, sorry I missed it earlier.

Sample data can be done with an INSERT like as follows:

INSERT INTO dbo.Table

SELECT 1,2,3,4 -- As...

dwain.c (7/23/2012)

---

xmozart.ryan (7/23/2012)

---

dwain.c (7/23/2012)

---

Assuming you want one result set returned to your client, you should consider doing it something like this:

;WITH Tally (n) AS (

ROW_NUMBER() OVER...

dwain.c (7/23/2012)

---

Assuming you want one result set returned to your client, you should consider doing it something like this:

;WITH Tally (n) AS (

ROW_NUMBER() OVER (ORDER BY...