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 wOOdy-Soft 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: *

  • Users: capooti
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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