Oh, i didnt realise, that we can group by UserID

Guys another query...Im working on a Stored procedure.

What I want to do, Im going to search my Winner Table, and calculate the Sum of the Winnings for Each User and...

My friend needs some help. He wants his query to display records after a certain date.

@Date = '7/7/2005'

SELECT * FROM USER WHERE DATE = AFTER @DATE

Something like that, he was...

Thanks to everyone whom have helped me..

Thanks Sushila, I solved the prbs.

I forgot to add a DRAWID = @DRAWID. Thats why the extra records

Thank you so much..

2 Records only.

I have other inserts too.

CREATE PROCEDURE CalculatePrize @DrawID int AS

DECLARE @Grp1 bigint, @Grp2 bigint, @Grp3 bigint, @Grp4 bigint, @Grp5 bigint,@Grp6 bigint, @Amt bigint

SELECT @Grp1 = SHARE1, @Grp2 = SHARE2, @Grp3 = SHARE3,...

V_ID is a uniqueindentifier column - which will increment on its own.

USERID - getting that from TempBets

i think u got it wrong...I need to add in USERID,AMOUNT,STATUS.

Amount will vary based on condition. STATUS is only 'N'.

I need help on another Stored Procedure.

SELECT BETTYPE FROM TempBets WHERE Matches = '3' and Mystery = '1'

Now there are a few Conditons(if statements)

IF BETTYPE = 'OD' THEN

@AMOUNT =...

Yes, finally manage to get it working..

CREATE PROCEDURE GetWinners (@DRAWID int, @Group1 int output, @Group2 int output, @Group3 int output, @Group4 int output, @Group5 int output

as

SELECT @Group1 = (SELECT COUNT (*) AS "Grp1" FROM...

Thanks sushila, i had solved that problem earlier...

DECLARE @Win1 int, @Win2 int, @Win3 int, @Win4 int, @Win5 int

SELECT @Win1 = 1, @Win2 = 4, @Win3 = 7, @Win4 = 19, @Win5 = 33

INSERT INTO INTO MatchingBets

(BetID,DRAWIDmUSERID,BETTYPE,Matches,Mystery)

SELECT BetID,DRAWID,USERID,BETTYPE,0,0

FROM...

Thanks alot...Its working..Woohoo...

I do not how to thank you guys for all the help you have put. I have definitely learned alot from this, having Select Case statements in SQL....