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 TouchToneTommy 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: 19511950
  • Order by date
  1. 19511950

    How to create cursor?

    I have about 50 cat's and 500 id's. From each cat i need only the top 1. How to paste cat to each statement to get id?
  2. 19511950

    How to create cursor?

    I need pass cat in each statement update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='A') update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='B') update tbl1 Set num=1 where id in (select top 1 from tbl1 where cat='C')
  3. 19511950

    How to create cursor?

    Hi, I have a table that has id,cat & num fields. Each cat has multiple ids, Num is 0 I need to create sp that will pick top 1 in each category and update field Num to 1. id cat num -- --- --- 1 A 0 2 A 0 7 B 0 6 B 0 2 C 0 7 C 0 Regards, Mark
  4. 19511950

    Choose multiple value/name from drop down list.

    Tony, Thank you very much.It works. Mark
  5. 19511950

    Choose multiple value/name from drop down list.

    I need both. (1,15,17) and (ALABAMA,INDIANA,KANSAS)
  6. 19511950

    Choose multiple value/name from drop down list.

    How to do it?
  7. 19511950

    Using 'AS' in SQL statements

    it should be the same datatype. select convert(char(3),123)+'456'output:123456 select 123+456 output:579
  8. 19511950

    Choose multiple value/name from drop down list.

    Hi, I can choose multiple rows from drop down list and get value into the query. select * from table where StateID in (1,15,17). Also I need to pick the State Name in the same sequence: "You choose ALABAMA,INDIANA,KANSAS states." Can I get the value of ID? <select name=Date2 multiple>...
  9. 19511950

    DTS package via SQL agent trouble...

    Thanks jhall01, The problem still exist. The DTS package was created locally under my id and I have all rights as administrator. DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error Detail Records: Error:5...
  10. 19511950

    DTS package via SQL agent trouble...

    Hello, I've got the same problem. The DTS successfully execute from 'Data Transformation Services', but when DTS schedule to run in SQL Server Agent it gives the same error as above. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError...
  11. 19511950

    How to re-create Excel file from DTS.

    did I do something wrong? I place this code into Visual Basic ActiveX Script. Error:Microsoft VBScript Compilation error Error Description: Expected Identifier ------------------------------------------------------- Dim, FSO, fileloc, file set fso = CreateObject("Scripting.FileSystemObject")...
  12. 19511950

    How to re-create Excel file from DTS.

    Can you be more specific, please, I've never use ActiveX scripts in packages. How and where show I create this procedure?
  13. 19511950

    How to re-create Excel file from DTS.

    Hi, Everyday I need to create (or update) excel file (name.xls) that will contain fresh data from sql server db. When I try to run DTS second time it tells me that this file exist. How to delete existing file from the folder using same DTS? Thanks, Mark
  14. 19511950

    Help in formulating simple SQL select statement/Pivot

    select distinct A.Last_Name, A.First_Name From Member A, Member_Designations B Where A.Member_Number=B.Member_Number Order By A.Last_Name Asc
  15. 19511950

    Javascript doesn't work on MAC

    Any code doesn't work. Maybe problem with the Mac browser 5.1
  16. 19511950

    Javascript doesn't work on MAC

    If you put alert msg before and after button you will see that code executed, but button doesn't click. function DisSave() { document.all.Approval.disabled=true; alert("before button"); document.all.Save1.click(); alert("after button"); }
  17. 19511950

    Javascript doesn't work on MAC

    Unfortunately both codes don't work.
  18. 19511950

    Javascript doesn't work on MAC

    I have simple code that doesn't work on MAC,but does on PC. Please help. <% Action1 = LEFT(UCASE(REQUEST("SAVE1")),4) If Action1 = "SAVE" Then Response.Write "You are here ":Response.End End If%> <HTML><HEAD> <script language="javascript"> function DisSave() {...
  19. 19511950

    How to create chart from asp to excel

    Hi, I get information from SQL Server into asp and open it in Excel. <%'--This code open file in excel--- Response.Buffer=TRUE Response.ContentType = "application/vnd.ms-excel" %> <table border=1> <tr> <td>Name</td> <td>Count</td> </tr> <%do while not RS.EOF%> <tr>...
  20. 19511950

    How to add CC or BCC in email subroutine.

    I did with spaces and without. It doesn't help. Do you know other way to add CC?

Part and Inventory Search

Back
Top