You can use DDQ (Data Driven Query) task in DTS (SQL 2000).  If you do not want to use data flow transformation, then :

a) If the source is a flat...

And change the id = ? to id in (1, 2, 3)

Use bcp or DTS.

set nocount on

declare @tableA table (colA int, colB int, colG int)

declare @tableB table (colA int, colC varchar(10))

insert into @tableA values (1, 10, 100)

insert into @tableA values (2, 20, 200)

insert into...

In SQL Server, you can use savepoints to rollback to that savepoint and then just have the logging functionality based on the error code.

Oracle provides something called as "pragma autonoumous...

Aswani: For pre-defined table structure, it cannot be done since that is the physical definition of the table and doing so would require a DDL change.  For actual temporary tables,...

Works great.  I added an order by on SKU_ID in the function in order to make sure that the SKU_STRING gets generated the same way for the cases.

Thanks Jesper

Thanks Jesper...but the problem is that the max number of SKUs is not fixed...it can be as big as 200.

Change SQL Server authentication to be "SQL Server and Windows" instead of just "Windows only" and re-start services.

SELECT *

FROM @Obs O

WHERE EXISTS

  (SELECT 1

 FROM @ObPrefs A

  INNER JOIN @PREFS B

   ON A.PREFID = B.PREFID

   WHERE A.ObID = O.ObID

   AND B.PrefName IN ('nodogs', 'waterside')

  ...

There are couple of different ways...if you know the value in the REF column i.e. if those are static values that you will be aware of, you can do this:

SET...

Use the NOT EXISTS clause.

Yes, it does..we use it in a lot of places.

You have not posted the query, the table structures and their relationship or the sub-set of data so this answer is based on just the post from above.

If you have a...

For filegrowth, Yes - it won't effect the existing work till the next time when the filegrowth actually occurs.  I would recommend though to avoid file-growth and to size your...