Perfect!!!

Thank you again...

Thank you.

As you see my level at this moment as you can imagine that this is not for a real live system,

only a practice system.

and you really sent me...

Thank you !

I didn't thought about it this way!!

Yessssss Thank You!!!

ohhh Sorry ok,

Msg 156, Level 15, State 1, Procedure Sp_SlotMachine, Line 61

Incorrect syntax near the keyword 'INSERT'.

Msg 102, Level 15, State 1, Procedure Sp_SlotMachine, Line 65

Incorrect syntax near ')'.

I'm trying...

!!

Thank you very much. I solved the case for Now.!! Great site !

ALTER PROCEDURE

CASINO.LoginTry

@Name VARCHAR(32),

@pass VARCHAR(32)

AS

BEGIN

IF

EXISTS

(

SELECT

1

FROM CASINO.Members

WHERE

Username = @Name

)

BEGIN

IF

EXISTS

(

SELECT

...

Thank you for you Response.

I'm trying it with the Exits but My Problem that I want to do in A way that for start he will check if username exists...

Hi,

ALTER PROCEDURE

Casino.Players_Logins

@UName NVARCHAR(10),

@pass NVARCHAR(10)

AS

BEGIN TRY

DECLARE @count VARCHAR(10)

SET @count = 0

SET

@count =

(

...

I Have Table That include User name And Password.

The Sp should check if the username password is correct .

If it's Wrong five time in A...

Oh sorry to post cut in middle .

I will rewrite and ask again

Thank you.

REATE VIEW

Operation.MemberSessionStatistics

(

GroupCategory ,

GroupValue ,

NumberOfSessions ,

AverageSessionDuration

)

AS

SELECT

GroupCategory=CASE

WHEN GROUPING (Countries.Name) = 0

THEN N'Country'

WHEN GROUPING (Genders.Name) = 0

THEN N'Gender'

WHEN GROUPING (MaritalStatuses.Name) = 0

THEN N'Marital Status'

END ,

GroupValue=CASE

WHEN GROUPING (Countries.Name) = 0

THEN Countries.Name

WHEN GROUPING (Genders.Name) =...

Sound's good. but I'm trying to count(logindatetime) the date column's and it doesn't works.