Recent content by lendbz

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