Hi Nicholas and bbdpres,

Thankyou for the info.  Thats interesting. 

I never taught of looking into the sp procedures. 

Best regards,

Atiq

Hi,

Yes you can do that, by querying the system tables to get the PK columns for the given table and buield a dynamic statement.

Regards,

Atiq Rahman

Hi,

The other way of doing it is as follows (without using the sub query):

create trigger <Trigger Name> on <Table Name>

Calvin Lawson,

Here is the example:

select top 5 * from dbo.authors Where au_id not in (select top 0 au_id from dbo.authors order by au_id)

select top 5 * from dbo.authors Where au_id...

Hi,

If you want to do it for one time do it from Generate SQL Script from Options tab under Files to Generate choose Create one file per Object.

But if you want...

Hi,

I am doing it like this:

select top 10 <columns list> from <table> where <condition> and <unique key> not in ( select top x <unique key> from <table> where <condition> )

When x is...

Hi,

Others may have the better way to work with Global Variables, but I do it like this:

First Create the Global Variables in your package.

In SQL Task write your query,

eg....

 Hi Andy,

Thanks for the reply.  Yes it worked.  I executed the cammand from the command line and it is working.  Then I searched the registery for Logread.exe and fonud...

Hi,

You can do that from the following statement.

update table1 set intcount = (select a.intcount +1 from table1 a where a.loc='A') where loc = 'A'

Enjoy!!

Hi,

Can some one please help, I am facing the following problem.

I am using SQL Server 2000 with SP3 on Windows 2003 server and Oracle 8i.

I am having a linked server...