Search results for query: *

Terry!!! I went to your site, your tech article show me that you have a lot of experience, but I already knew it from your answers. Also the picture of you show me that you have a lot of experience (joking!!!) so I will blindly follow your reccomandations, cause in front of you I am just an...

congrats karluk it is not a sql server bug. at this point the source of my data where processed with a software using not Gregorian date thank you all!

Hey, thanks for your interest!!! Sorry, Terry but I am not agree with you. When you use string instead than number, you go in a lot of troubles, expecially if you need to use funcitons for date (ie. Day, Year, Month). If you need to manage tables from different countries you would get a lot of...

Guys, I think I discovered an incredible bug. I want to convert a numeric value rappresenting the number of days from 1-gen-1900 in a smalldatetime. I do this: select cast(0 as smalldatetime) select cast(37386 as smalldatetime) I get: 1900-01-01 00:00:00 2002-05-12 00:00:00 If you do...

well, mapfax, thanks for your help, but I solved. It was a permission issues, but not conerning xp_cmdShell. In DTS the destination is SQL Server, with login based on SQL Protection. I had it based on Windows protection. I thought when I call dtsrun, if i give username & password as parameter...

Hi guys something strange is happening, I can't understand why. If i launch my dts package from command promp, just like this: dtsrun /SmyServer /UmyAccount /PmyPwd /NmyDTSPack everything works fine. But if i try to launch this dts from a sp with: master..xp_cmdshell '/SmyServer /UmyAccount...

Thank you all, but I found the following even easier (and ANSI, not like TOP statment) SELECT DISTINCT(COD), max(NAME) FROM TableX

Hi, this may be very simple, but I don't know how to do: suppose I have the following TableX COD NAME 1 Tim 2 Jason 2 Paul 3 Mark I want a distinct on COD field. If I try this SELECT DISTINCT(COD), NAME FROM TableX then I will receive the whole table. How can I receive...

thank you! for ldandy: i made a sample without putting the code of the sp, of course in my sp the table name is a parameter best regards

IT DOESN'T WORK, I HAVE TRIED IT ALREADY. THANK YOU ANYWAY

Hi, this could be very stupid for almost all of you but actually not for me, as I am still a beginner with Transact. I want to write a stored procedure with several parameters. One of this parameters will be the name of a db's table. I can't manage doing it! My code would be something like...

I solved with something that already knew but I would'nt have thought is so effective. With ADO, update operations can be very slow, the best is to code them in stored procedure and call them from the ADO client. What impressed me is that this way the perfomance are now 15 times better! Now...

Thank you Terry for your excellent reply, You gave me precious suggestions and links. My VB process insert ONE record at a time. What I will do now in order to improve performance is (like you suggest me): 1) try with bytch update 2) eventually try DTS (unluckly I am quite new to it) Best regards

Hi All I have the following trouble: I wrote a procedure (VB6, ADO) to load a denormalized huge text file in a normalized SQL Server database. From over 1.5 million records in the text file needs to be created almost 25 millions records in SQL Server. Unluckly we exstimated that the procedure...