ok - then try this: (assuming status is ALWAYS 'N' & only Amount changes based on betType....)

insert into Winner(UserID, Amount, Status)

select UserID,

Amount = case

when betType = 'OD' then 20

when...

raj - i just threw in the other stuff IN CASE you had more conditions...

where are you getting the V_ID (is this an identity column ?!) & USERID from ?!

try tweaking this around...I don't have time to test:

insert into Winner(Amount, Status)

select Amount = case

when betType = 'OD' then 20

when betType = 'OC' then 10 etc....

end,

Status =...

okay - can't test this right now - but I think Merrill had your answer ?!?! - is this what you want ?!

SELECT A.* FROM tblTest A

INNER JOIN

(SELECT TOP...

how do you assign the coupon codes now?! do you just look for any that are "not assigned" and assign one to a new user ?!

how does your CouponCodes table...

that's weird! do you have any triggers set on this table ?! I think it maybe something in a trigger that just inserts the deleted row back!

- darn but this t-sql stuff is so addictive!

raj - not sure if this is what you're looking for since I'm not sure what the schema of your Draw table is...but this should at least get you started...

CREATE...

brain strain is right - here's one solution that I learned from a member called Vladan loooong ago...

SELECT Shipper, Dest, SUM(Weight)

FROM @Table1 A

WHERE...

Quoi ?!?!

My big discovery was 2 days ago...and how come you always know which forums call out your name remi ?! do you actually get email notification everytime someone says...

do you mean that they might enter something like "32 laurel lane"; "laurel ln 32" etc..?! just making sure I understand the question!!

also in ken henderson's book - & probably a lot of other places...but the point is that you know and retain these facts and many of us don't...

WOW! Who'd have thought?!?! I always thought you were french (your name

Habla Español then ?! am still reeling under the shock of this...

He's our resident genius - Phil - that's how!

something new you learn everyday...

as for "objective and media resource " being used in the same sentence...not to be rude or anything - but...