Search results for query: *

thanks :)

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

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

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

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

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

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

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

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

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

thanks :) it work

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

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

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

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

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

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

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

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