All are in integers in my DB.

Anyone there???

Anyone....

DRAW RESULT from Draw Table

7,2005-07-28,8,9,22,29,43,45(Mystery_number)

My Input (ID=7,@1 = 2,@2 = 8,@3 = 9,@4 = 21,@5 = 45)

CREATE TABLE [DRAW] (

[DRAWID] [int] IDENTITY (1, 1) NOT NULL ,

[DRAWDATE] [smalldatetime] NOT NULL ,

[NUM1] [smallint] NULL ,

[NUM2] [smallint] NULL ,

[NUM3] [smallint] NULL ,

[NUM4] [smallint] NULL ,

[NUM5] [smallint] NULL ,

[NUM6]...

What I want my SP to return is 2 Values. Which are my @Match and @Mystery. There values are the Number of Matches found.

I have 5inputs, which are my...

its not returning me with any values if I use this???

@1 = NUM1 AND

@2 = NUM2 AND

@3 = NUM3 AND

@4 = NUM4 AND

this checks my @1 with Num1 only. I want to check my @1-5 with Every...

I got 5 Numbers...These are my inputs.

I want to check with my DB that whether these Numbers are winning Numbers.

That is why I have a variable Match that returns...

Bro I find that there is a conflict now.

2 Latest Records with Winning Numbers in it.

Now I add in a new Record with No winning Number. This now will...

If you do not mind could you explain to me how this particular query works.. Thanks

I need them to be seperate queries.

SELECT TOP 2 DrawID,DrawDate,WinningNumbers FROM [Result Table] ORDER BY DrawID desc - retunrs me 2 Rows.

I need 2 seperate queries. To give me the...

I have done this...Is this right..

SET ARITHABORT OFF

SET ARITHIGNORE ON

SET ANSI_WARNINGS OFF

How to i tackle Divide by Zero errors.

Since sometimes my value of @Share is Zero.

And I get a Divide By Zero error that affects by SQL query. How do i...

IF Statement in SQL.

Im doing something like this in SQL.

SET @Share = @Share1 + @Share2

IF NOT (@Share = 0) THEN

@Amount = @Pool / @Share

ELSE

@Share = 0

END

Is my query...