Search results for query: *

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

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

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

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

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:)

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

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

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

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

How to get current date time to insert into mssql server 2000 database? like from back end getdate() function, i want the current date time in PHP. thanks in advance

I have an executable. i need to call from php page. then environment we are using is php4,linux,apache. any suggesstions are appretiated. thanks -mike

Please Help, The below query is taking me 1 min 30 secs to execute. can any body help me to optimise the below query... INSERT INTO dbo.Table1 SELECT * FROM Table2 WHERE AccNo NOT IN (select distinct AccNo from dbo.Table1 OR Location NOT IN (select distinct Location from dbo.Table1...

hi, I am completely new to crystal reports. We are using crystal reports version 10. we developed some reports using the crystal reports professional edition. now we want to integrate the crystal reports with ASP pages, and view the reports in the ASP page. Please help me or advice me what i...

Hi, <i>I have a requirement like this. User will input DateFrom and DateTo dates and i need to generate a datelist. eg., user input </i> DateFrom=21/11/2004 <i>and </i> DateTo=15/03/2005 <i>then i need to get </i>DateList='21/11/2004,01/12/2004,01/01/2005,01/02/2005,15/03/2005' <i> Please...

Hi All, i have a crystal report out put like this: Code Total Rcvd Total Outstanding ----------------------------------------- ADD 100 10 ADC 50 5 ADC_CD 12 10 ADC_AB 100 15 CSF 30 5...

Dear All, i want to write a custom stored procedure to get the total records count by passing the table name to the stored procedure. Please help me to correct this stored procedure below... CREATE procedure getrecordCount_SP @TableName as varchar(30) @TotalRecords as numeric output as begin...

Please Help! I have two tables named category and Products which has the following data:- category : ----------- catid ParentCode CatCode ----------------------------- 1 IT CATIT 2 IT ABCIT 3 IT HPIT 4 PRN COMPRN 5 CDD...

I have a Table Product with the following data: ID productCode Productname ------------------------------ 1 sdk/mini/011 AAAA 2 ngs/kitt/2134 BBB 3 smd/ti/022 CCC now i need to increment all the ProductCodes by one. the result should be ID ProductCode ProductName...

at our development site we are using win2k server and thirdparty email component "dundas mailer" works fine here. but on production server we are using windows server 2003, but we face problem in sending out the emails... any sugesstion is appretiated.

Hi Every one, can any one help me to write this query. I have a Database table called "User" and it have UserID(Int(4)) and Roles(varchar(50)) Feilds. Sample data is like this: UserID Roles ---------------------------------- A 2 B 3 C 2,3,4 D 3,4 E NULL F...