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 SkipVought 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: rajkum
  • Order by date
  1. rajkum

    Select question

    Hi, I have a dataset which looks like this: ID Seqnum Seqnum2 Date =========================== 1 0 0 1/1/2005 1 1 0 1/2/2005 1 1 1 1/3/2005 2 0 0 2/1/2005 3 0 0 1/1/2005 3 1 0 1/2/2005 4 0 0 1/2/2005...
  2. rajkum

    Calling a DTS package with SQL statement as parameter

    Hi skurpyun, From ASP: I could send an email using ActiveX script but it would not allow me to do anything with database. Thanks, Raj.
  3. rajkum

    Calling a DTS package with SQL statement as parameter

    Hi, I am trying to run DTS from ASP but to no avail. I can run from Enterprise manager though. Could you help me understand what the permissions in SQL Server and(or) IIS are that I have to set to access the package from ASP. Thanks
  4. rajkum

    DTS FROM ASP

    Hi, The problem has not been resolved yet. I have access to SQL server through the "Enterprise Manager". I can run the DTS package from the Enterprise Manager. The problem is when I try to access it throug ASP. Does any body know whah permissions to set and how? Thanks in advance.
  5. rajkum

    SELECT question

    Thnak you guys!
  6. rajkum

    SELECT question

    Hi, Table ---------------- Fld1 Fld2 ---------------- JOHN 2 JACK 1 PETER 2 JOHN 13 --------------- How do I query to return all the Names in Fld1 where Fld2 is 2 AND 13. I do not want to list PETER. Thanks in advance.
  7. rajkum

    Database Connection from ASP

    Thanks guys. It looks like that it was the DB admin issue. He Fixed it. Thanks again.
  8. rajkum

    Database Connection from ASP

    Hi, All of a sudden I get this message today when I try to access ASP pages with DB connections. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I have been running the pages for the past one year and it was working fine. I can access the SQL server...
  9. rajkum

    Display problem

    Netscape v6.2.1
  10. rajkum

    Display problem

    Thank you cLFlaVA, but the Netscape problem still persists.
  11. rajkum

    Display problem

    Hi, The HTML below works fine in IE and safari but NOT in Netscape. Netscape does not hide the scrolling panel of the Select box. Is there any way i can hide it? I am using Netscape 6.2.1. Thanks in advance. <html> <head> <title> TITLE </title> <script language="JavaScript">...
  12. rajkum

    DTS - UPDATE Record

    sorry for the dealyed response... Table 1 : [person_names] -------- some_id last_name first_name mid_name name_eff_dt --------- Table 2: [person_demographics] --------- ID last_name first_name mid_name sex dob --------- Let us try to Update last_name,first_name,mid_name in...
  13. rajkum

    JOIN Problem

    I am sorry .. but I missed a table here.. Let me re-write the requirement .. Also I am incorporating suggestions by Amorous. Table 1: -------- codeID -PK codeNum -PK title status_cd --------- Table 2:(History of Table 1) Note : CodeNum in Table 1 could change. It is when this...
  14. rajkum

    JOIN Problem

    Hi, I am not being able to figure out how to SQL my requirement. Any help would be greatly appreciated. Table 1: -------- codeID -PK codeNum -PK title dept_cd status_cd --------- Table 2:(History of Table 1) Note : CodeNum in Table 1 could change. It is when this change occurs...
  15. rajkum

    DTS - UPDATE Record

    Hi Devils, I used Data Driven Query Task in DTS and used the "Query Type- Update" in Queries. If you are interested I could post an example. Thanks, Rajkum.
  16. rajkum

    DTS FROM ASP

    It works when i run from Enterprise Manager. -Rajkum
  17. rajkum

    Permission problem running a DTS froma stored procedure

    Is it appropriate to ask here?? But I am trying to do it thru ASP? I have posted a question though?
  18. rajkum

    DTS FROM ASP

    Hi, When I try executing DTS package FROM ASP I received this error : Executing DTS_PACKG_1 from server_name 1 Step [DTSStep_DTSDataDrivenQueryTask_1] failed Task "Data Driven Query Task: UPDATE TABLE ..." Package [DTS_PACKG_1] failed Done The code I am using is as below ...
  19. rajkum

    DTS - UPDATE Record

    I figured it out!! Thanks!
  20. rajkum

    DTS - UPDATE Record

    Hi, REQUIREMENT : 1. Regularly update DATA FROM Database (DB1) to Database (DB2) say FROM TABLE1 to TABLE2 2. IF row in TABLE1 is new INSERT in TABLE2 3. IF row in TABLE2 says the row has to be overwritten (SQL UPDATED) THEN UPDATE the row. (TABLE2 has a flag which says whether the row has...

Part and Inventory Search

Back
Top