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

  1. lendbz

    sql inserting question

    thanks :)
  2. lendbz

    sql inserting question

    aww thank you :) that's simplier! Now for the reverse direction, from info2 to info1... I normally do: Insert into Info1 (Id, name, address,...) select ID, max(case when label = 'name' then info else NULL end), max(case when label = 'address' then info else NULL end)...
  3. lendbz

    sql inserting question

    Hello, I have a question: I have a Table with information: create table info1 ( ID, name, address, .... ); Now I want to import those data to another table, except in this format: create table info2 ( ID, label, data ); Say if i...
  4. lendbz

    tsql help colunn to rows

    That's ok :) How would i do this with cursors???
  5. lendbz

    TSQL help column to rows

    nevermind this thread. i posted on the wrong forum. sorry..
  6. lendbz

    tsql help colunn to rows

    Hello, I have a question: I have a Table of certain items create table item ( IdItem int, Item varchar(64), ... ); a lookuptable which defines some properties create table property ( IdProperty int, Property varchar(64) ); and...
  7. lendbz

    TSQL help column to rows

    Hello, I have a question: I have a Table of certain items create table item ( IdItem int, Item varchar(64), ... ); a lookuptable which defines some properties create table property ( IdProperty int, Property varchar(64) ); and...
  8. lendbz

    trigger blocking

    OH. well, in the DTS package i have a connection to the foxpro database, and it insert data from that sqlserver temp table to the foxpro table... can that be done with T/SQL inside the trigger???
  9. lendbz

    trigger blocking

    oh ok thanks. but is there any way to start the trigger(and thus the select statement) only after the insert has been committed?
  10. lendbz

    trigger blocking

    Hi, I am trying to implement a trigger that run a dts package when something is inserted. My trigger is like this "CREATE TRIGGER [RUNupdateDTS] ON [dbo].[temp] FOR INSERT AS exec master..xp_cmdshell 'DTSRUN /S (local) /e /n import_iqvc_inventory ' " In my dts package, one of the step is...
  11. lendbz

    form

    thanks :) it work
  12. lendbz

    form

    thanks! How do i bring up the file open dialog box? :) lenny
  13. lendbz

    dts run help

    thanks! i was setting up the odbc data connection to just the mapped drive, after i change it to "\\xerver\..." it work. thanks so much. lenny
  14. lendbz

    form

    Hi, This is a simple thing? I am a beginner and not sure how i would go about doing it.. What i want to do is, I want to create a form in access that would 1) let you browse thru the file directory to select the file that you want 2) have a button that, after you select the file, when you...
  15. lendbz

    dts run help

    I have a question, I have a dts package that connects to a foxpro table (iqvc.dbf) and insert data to it, the package is called "Import_iqvc_inventory" I generate this line from the dts run utility "DTSRun /S "(local)" /N "Import_iQVC_Inventory" /G "{59D31918-D2CC-438A-89A5-18E745E07905}" /W...
  16. lendbz

    Through DTS Package Records Not Deleted Permanently in Vis.FoxPro

    yeah. but somehow i can't get zap to work in DTS. so i delete first than "pack [tablename]" in my DTS package. using "zap [in tablename]" in DTS give me a "syntax error or access violation" error. If someone can help me get that to work it would be greatly appreciated, if not I will just use...
  17. lendbz

    Through DTS Package Records Not Deleted Permanently in Vis.FoxPro

    oh nevermind. it worked now. THanks for the advice :)
  18. lendbz

    Through DTS Package Records Not Deleted Permanently in Vis.FoxPro

    Can you give me more information on how i would create the foxpro delete/pack statement externally? Thanks in advance, lenny
  19. lendbz

    Through DTS Package Records Not Deleted Permanently in Vis.FoxPro

    I have created a DTS Package to Transfer Data from a SQL Server Table to Visual Foxpro Table. And every time data goes from SQL to Vis.FoxPro Table, it should first delete all the records permanently in Vis.FoxPro Table and it should append SQL Data. Everything is fine in designing and...

Part and Inventory Search

Back
Top