problme?

"The 4ms timing difference came about, I imagine, from the query plan executing the functions first, then the explicit call to GetDate(). "

In any case the getDate() function will return...

hey, 1st of all, sorry for the incomplete information....

here is go..

select getDAte() 'GetDate', dbo._fnFlo('GMT::5:30') 'Sln by Flo', dbo.fnPaul(5.3) 'Sln by Paul'

and as seen, i got above result in single query......

Hi Flo/Paul,

Thanks a lot for helping me..

here is the output of both functions.

GetDate(): 2009-04-06 13:06:29.197

Solution by Flo: 2009-04-06 12:54:29.193

Solution by Paul: 2009-04-06 12:54:29.193

Cant you use DTS wizard?

Hi Flo,

According to your suggestion, if replace input value @TimeZone varchar(50) with @TimeDiff Decimal(2,2) then i can omit the string routine; but the below statement is still there.

SET @TimeDiff =...

Hey!!!

i have checked it on other servers too.. it is heavily dependent on float value.. yeah.. i admit here that it is not fully working and easily implementable.. :ermm:

Actually, i...

It may be because in sql server 'float' value inconsistent behavior.

Try some other value in place of '0.01' in above line.

---- Convert the time difference into differnce for caculation.

SET...

check what is your user's authentication, windows or sql server. below links may be helpful to you.

http://technet.microsoft.com/en-us/library/aa337562.aspx

http://msdn.microsoft.com/en-us/library/ms173463.aspx

Hello,

can anybody tell me how 1 can get PRINT statments from SP execution at client side?

I found it really useful in some cases when we need to log the actual...

XML in sql server is not at all difficult part. Have some googling on 'XML in sql server'.

R u using SS 2k5? there is a xml data type to...

-connect to your server by SSMS.

-go to 'Databases'.

-right click on that and select 'Attach'

-in open window, find the .mdf file location for your previous database.

-Click 'OK'

--Repeat above steps for all...

If you have any confusion regarding domain, i prefer to suggest you to go with option-1 as you did earlier... dont go for domain user a/c, install it with built...

Okey...

so, ball is now in my cort... let me download it...

and will come with the result...

hey, thnks for the link... it's huge in size...

but though, in description, it doesn't mention about DTSWizard.exe.. what the content is 1) SSMS Express & 2) BIDS (for reporting)..

R...