Good God man,, What did you just send me?

i am not sure what you are telling me here.

Can you  please explain a little better?

thanks!

erik

perfect...

thanks!

erik

please show example.

thanks!

erik..

He is what i have so far.

my quesion is that if i get to this point and i DO NOT EXISTS.

Does that transsql stop here?

IF EXISTS

(

add this part corrently

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

Where Email = @Admin_Email 

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

ALTER PROCEDURE AdminSystem_SelectConsumerInformation

@Admin_Email Varchar (200),    /*Admin Check */

@Admin_FName Varchar (30),     /*Admin Check */

@Admin_UserType Varchar  (20),  /*Admin Check */

@user-id INT,

@UserEmail as Varchar (200)

AS

  Select Email,...

i'll have to remember that one...

Thanks!

I hate to ask a dumb question, but what is dekko?

erik...

Thanks for the help!

I will not hear back from my help again untill tonight, but i am not sure why he did not receive the data...

I did go ahead and...

got any suggestion for me Sushila?

Let me try zipping it up.

What about the IF?  Do i need a END for any of the IF?

Keep receiving this error message,, can someone please tell me where i need the Begin?

And is it...

Also for the END,,,, Should i have an END for every IF,,, AND Begin Transaction???

Thanks,

Erik,.,..

Let me reach for my asprin

Thanks alot for the help!

   Could someone please tell me what the 1,1, is for in this raised error?

               RAISERROR( 'AUDIOT OF EMPLOYEE FAILED.', 1, 1)

For this one there is...