THANK YOU AND HOW TO TRANSFER LOGINS AND USERS.

i got it thanks to all...:)

I tried the above format but i didnt get what i want to be.

Yup i tried to rewrite this from another way, but i got many errors than this code. and i will check with dateadd function and reply you soon. And i...

thank you all i resolved it.

How can i change the recovery model properties like simple to full.

Thank you all.

I tried like below

USE [NXNV1]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SP_CONSULTATION_DETAILS1]

@age SMALLINT,

@date DATE ,

@time TIME,

@gender CHAR(1),

@amount varchar(20)

AS

BEGIN

SELECT @amount=

(CASE

WHEN DATENAME(DW, @date) = 'Sunday' THEN

CASE

WHEN @Age...

can u explain it briefly please i couldnt understand this.

Thank you so much JOHN i solved it.

could u please write that.

HI I UPDATED MY QUESTION PLEASE CHECK IT ONCE.

I HOPE NOW U CAN UNDERSTAND.