Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. capooti

    AMAZING BUG WITH DATE???

    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...
  2. capooti

    AMAZING BUG WITH DATE???

    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!
  3. capooti

    AMAZING BUG WITH DATE???

    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...
  4. capooti

    AMAZING BUG WITH DATE???

    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...
  5. capooti

    DTSRun from xp_cmdshell

    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...
  6. capooti

    DTSRun from xp_cmdshell

    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...
  7. capooti

    select distinct and other fields: aggregate function for text?

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

    select distinct and other fields: aggregate function for text?

    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...
  9. capooti

    select * from @???

    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
  10. capooti

    select * from @???

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

    select * from @???

    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...
  12. capooti

    Huge load in SQL Server 2000

    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...
  13. capooti

    Huge load in SQL Server 2000

    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
  14. capooti

    Huge load in SQL Server 2000

    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...

Part and Inventory Search

Back
Top