My USERID and BETTYPE are varchar?

Any problem with that??

Server: Msg 8152, Level 16, State 9, Line 7

String or binary data would be truncated.

The statement has been terminated.

Another error?

I created a new table just for this..Its permanenet

Im getting this error.

Server: Msg 2714, Level 16, State 6, Line 14

There is already an object named 'MatchingBets' in the database.

Anyone...Since i got to get this done asap...Thanks in advance..

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

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

INSERT INTO #MatchingBets

SELECT BetID, 0...

BET_ID DRAW_ID BET_NUMBER_1 BET_NUMBER_2 BET_NUMBER_3 BET_NUMBER_4 BET_NUMBER_5 BET_NUMBER_6 BET_NUMBER_7 BET_NUMBER_8

----------- ----------- ------------ ------------ ------------ ------------ ------------ ------------ ------------ ------------

6...

I changed the column for brevity...So its easier for you guys..Since my Column names are long...eg. BET_NUMBER_1. hate to write it that long, so i changed it to short form..

ITs in table format..So let me enter the records.

BETID DRAWID USERID NUM1 NUM2 NUM3 NUM4 NUM5 NUM6 NUM7 NUM8

1 1 ...

DECLARE @Winner_1 INT, @Winner_2 INT, @Winner_3 INT, @Winner_4 INT, @Winner_5 INT

SET @Winner_1 = 1

SET @Winner_2 = 2

SET @Winner_3 = 3

SET @Winner_4 = 4

SET @Winner_5 = 5

SELECT Bet_ID, 0 as MatchingBets

INTO...

There is already an object named '#TempBets' in the database.

Im getting another error??

Im getting an error here

Line 14: Incorrect syntax near ')'. on this line

THEN 1 ELSE 0 )

select * from TBETS

WHERE BET_12 in ('1', '2','25','32','44')

I get 1 row, with all my columns empty.

UPDATE TBETS

SET Score = Score + 1

WHERE BET_1 in ('1', '2','25','32','44')

UPDATE TBETS

SET Score = Score + 1

WHERE BET_2 in ('1', '2','25','32','44')

UPDATE TBETS

SET Score = Score + 1

WHERE BET_3 in ('1',...

I am getting All records that matches any of the numbers.