It does not return any record.

Thanks. I solve the problem by using regular sp.

Declare

@CNT int

DECLARE autorun_cursor CURSOR FOR select...

I did exec msdb..sp_start_job @job_name='ABC' but ActiveX script does not like it. Only I can run this code in transact-SQL script.

I have code:

SQL= "select count(*)CNT from...

thanks. It helps.

Thanks I got it

Thanks. But its import data between dbs.

How to import data from table to local C: drive in csv format?

I use it a lot to execute multiple sps from 1 click

CREATE  PROCEDURE D

@DTE datetime,

@ID varchar(6)

AS 

 execute A  @DTE,@ID

 execute B  @DTE,@ID

 execute C  @DTE,@ID

Select distinct Track_no, duplicate * From duplicate does not work.

Select * from T1 where Track_no in (select Track_no from T1 group by Track_no having count(*)=1)

select ID from Emp1 where ID not in (select ID from Emp2)     UNION         select ID from Emp2 where ID not in (select ID from Emp1)

select * from (select top 1 * from AAA where loaded_unloaded ='U' order by scale_dt desc)A

UNION

select * from (select top 1 * from AAA...

select * from (select top 1 * from AAA where loaded_unloaded ='U' order by scale_dt desc)A

UNION

select * from (select top 1 * from AAA where loaded_unloaded ='L' order by scale_dt...

Link Oracle db to the link servers in SQL 2K2 and use openrowset function.

select into [tableSQL2k5] from openrowset(ORACLE_DB, select * from

);

It can be done from the view or table.

Open excel>data>import external data>import data>new sourse>login to the server and choose from views or tables.

May be it will help!

USE pubs

GO

DECLARE @title_ids varchar(8000), @delimiter char

SET @delimiter = ','

SELECT @title_ids = COALESCE(@title_ids + @delimiter, '') + title_id FROM titles

SELECT @title_ids AS [List of Title IDs]

Would not be easy to cheating union operator?

select * from (select * from Table_A where loaded_unloaded ='U' order by scale_dt desc)A

UNION

select * from...