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 Chriss Miller 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: happyIndian100
  • Order by date
  1. happyIndian100

    Strange Issue- SQL Server

    Yes paul this table is Truncated every 30 mins. This table is like a Temporary physical table(tableA) where we pump the data into it ,clean the data and then transfer the data into another original production table. But the problem is with the tableA. according to your sugesstion if this...
  2. happyIndian100

    Strange Issue- SQL Server

    When i run the DBCC SHOWCONFIG (tableA) i get the below results and paul you are right the extent scan Fragmentation has a value which will increase slowley. What action should i take now? there is not PK on the tableA. pls advice. DBCC SHOWCONTIG scanning 'tableA' table... Table: 'tableA'...
  3. happyIndian100

    Strange Issue- SQL Server

    Thanks for Info. It helps me to investigate the problem further when it happens again. I will keep you posted what i find. Thanks
  4. happyIndian100

    Strange Issue- SQL Server

    It happens once in every six months. The tableA is truncated first, then insert the records(recCount:875000) into tableA. After that when i delete some records with the delete statement below: Delete From TableA Where IsNumeric(Price1) = 0 Or ISNumeric(Price2) = 0 Or ISNumeric(Price3) = 0 Or...
  5. happyIndian100

    Strange Issue- SQL Server

    Thanks Jbenson, that will fix my problem. but any one knows the reason why this happens?
  6. happyIndian100

    Strange Issue- SQL Server

    I dont get any error, The DTS runs forever, never finishes the process.
  7. happyIndian100

    Strange Issue- SQL Server

    Let me explain this strange issue first: In SQL Server 2000 we use DTS to insert data into a TableA. it worked fine for couple of months but recently the DTS was failing. when checked found out that it is taking forever to insert the data into TableA. for Temporary solution i do this: Drop...
  8. happyIndian100

    [b]howto execute a TCL script from with php script[/b]

    sorry for the vague information. here is what i am doing. test.tcl --------- #!/bin/sh # \ exec tclsh "$0" ${1+"$@"} set result 38 puts $result return $result ----------------------------------------------------- myFile.php --------- <?php global $res; $res = exec ("test.tcl") ; echo $res...
  9. happyIndian100

    [b]howto execute a TCL script from with php script[/b]

    Didnt Worl.
  10. happyIndian100

    [b]howto execute a TCL script from with php script[/b]

    How can i execute a TCL Script from PHP. and i want to use the Return value of TCL script in PHP. Please Advise.
  11. happyIndian100

    [b] How to Return a value from TCL to PHP [/b]

    How can i call a TCL script from PHP and return a value from TCL to php. Please Help!!!
  12. happyIndian100

    Expect for Windows

    1> Does ActiveState Expect needs a license. 2> Can i use ActiveSate Perl with Expect on windows. 3> what is the best language to use with expect. Thanks in advance
  13. happyIndian100

    Query Help!!!

    Thank You Mike it helped me a lot.
  14. happyIndian100

    Query Help!!!

    I have a TableA with the following data: ------------ Col1 Col2 ----------- A A1 A A1 A A1 B B1 B B2 C C1 C C2 C C3 D D1 i need to get this Query Result: A A1,A1,A1 B B1,B2 C C1,C2,C3 D D1 Thanks in Advance:)
  15. happyIndian100

    SQL Server Issue

    Hi all, Our sql server 2000 stops responding once a month. when we truncate our 3 log tables it start working fine. I want to know the reason whats causing SQL Server 2000 not to respond? thanks in advance
  16. happyIndian100

    Return a range of row results from a SQL query

    How to return the Nth to Mth row of a particular query? thanks in advance
  17. happyIndian100

    Decimal numbers

    a simple question, select cast(156/100 as numeric(13,3)) output i get is 1.000 but in actual it should be 1.560 please help...
  18. happyIndian100

    SQL Query

    Thank You
  19. happyIndian100

    SQL Query

    Please Help!!! Is there any better way to write this query to improve performance. Total Records are 5,00,000 records Select Distinct A.col1 ,Null Col2 ,A.Col3 ,Null Col4 ,A.Col5 From Table1 A Where Not Exists ( Select * From Table2 B Where A.Col1 = B.Col1 And A.Col5 = B.Col5 ) Thanks
  20. happyIndian100

    &lt;b&gt;Current Date Time in PHP mssql2000&lt;/b&gt;

    i want to insert datetime into mssql server2000 datetime field. thanks

Part and Inventory Search

Back
Top