It's working. Thanks for your help !!

I ll try this and update the result. Thanks for your suggestion 🙂

Hi John,

The changes that I am making is to an existing system which is running for quite a time now and which is related to end users from several different...

Hi John,

The changes that I am making is to an existing system which is running for quite a time now and which is related to end users from several different...

Basically it's a Scalar Valued Function. Here is the code:

CREATE FUNCTION [PUser].[ZoneDate]

(

)

RETURNS DATETIME

AS

BEGIN

DECLARE @getdate-2DateTime

SET @getdate-2 = GETDATE()

...

Hi,

I did some work on this and could connect to the database. But i am unable to fetch the result and store it in a variable.

Here is the vbscript...