because i have to, if i dont want to rebuild the table, and the dts package that is allready there.

bottom line if you enter the select sin(1) in Query Analyzer it does not return 0.9999.... rad, or degrees, or meters, or kilometers!...

i believe SQL central should give us a 100 points worth of question points for the physcological mess we have been through, this whole sin(1) matter!

what? well i put select sin(1) into the query analyzer and it returned 0.8414709848078965!

the number 09999... is the cosine of 1. New math rules from SQLservercentral?

Dear Joe,

indeed you gave me some grounds to think about it further.

I will log in tomorow to let you know of my thoughts. Please keep this forum under mind.

Kind Regards,

Dionisis

LOL . You got me covered mate! 🙂 Cheers

I aggree with both of you, and i much appreciate your help.. However, when i asked the MIS supervisor why the code is written within the DTS package he said...

Jonathan Thank you 🙂

That did it for me as well Guys! 🙂 Cheers! 🙂

The script (activeX vbscript in a DTS package), in case someone is interested is as follows..

Function Main()

if Left(...

i meant with active x (within a DTS package)... 🙂

I have used formatdatetime (vb) but it depends on the server's regional settings... anything better than that?

sorry for not mentioning...

Guys thank you very much for your help so far,

i really appreciate it...

ok let me clarify 2 things...

First of all, from all this i have learned that i will try...

Yes, the table is used for keeping names and addresses of different language (i.e bulgarian). The table is used in a software application for a bank and currently has over...

Thank you, thank you, thank you!

🙂

Your Help is much appreciated! 🙂 One more question please Remi.

Have you any other idea apart from cutting the lentghs (we are...

Please explain abit more.

if nvarchar is 2 bytes per character then the 17 fields nvarchar [255] come to 20.000 alone! plus the 4000 length of the address_concat field (whgich you...

Ajit,

sorry for the delayed reply, i was on vacations.

Thank you for your concern. My supervisor is currently dealing with the deployment of the portfolio cubes, and he...