Viewing 15 posts - 13,096 through 13,110 (of 18,923 total)
There's a simple reason you don't get much help around here. TRY FOR YOURSELF first, then if all fails come back here. Check the access help for that...
September 20, 2005 at 7:59 am
Insert into tableName (col1, col2, col3) Select col1, col2, col3 from OtherTable. Looks like you can do something like that using the code you just presented.
September 20, 2005 at 7:26 am
You can't sue select into to get the data back, but you can do insert into select
September 20, 2005 at 7:17 am
I confirm that it runs in another process (checked using a waitfor delay in a job that I fired from an alert).
September 20, 2005 at 7:10 am
You can always execute the job right away. But I'm not sure that this is called as an external process... but that would be pretty easy for you to...
September 20, 2005 at 7:00 am
Can't you just link the tables?
Can't you also just copy that code on that db on do the reverse process... or code and insert into select...
September 20, 2005 at 6:57 am
This is what you need :
Select * from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where View_Name = 'vwFormsUsage'
September 20, 2005 at 6:56 am
And if it wasn't for the dynamic sql part, we'd all had been done 8 posts ago. Seriously, why do you HAVE TO use dynamic sql??????
September 20, 2005 at 6:49 am
Ya, that would work. But for the love of G*d, split this into 3 procs and let the app decide, AS IT MUST ANYWAYS.
September 20, 2005 at 6:46 am
Actually it'll be select * from dbo.MyFunction (@Param1,...) if you need to select from it.
September 20, 2005 at 6:42 am
I think you can run that into batch when using bulk insert but I can't help you much more than that, sorry.
September 20, 2005 at 6:41 am
In a stored proc.
Or in am inline table function if you need to use that in an inner join.
September 20, 2005 at 6:39 am
Viewing 15 posts - 13,096 through 13,110 (of 18,923 total)