Lynn,

Thank you for those kind words.

Sergiy: "db2l, I believe it's not "SQL syntax" question anymore. It's "I don't want to think" issue."

Sergiy: "How many seconds of thinking effort it takes?"

Sergiy: "And don't tell you are...

Is that what all the hostility was about?  Because I had the temerity to offer up a solution that was different from yours?  Sorry, if I is bein' uppity, massa!  I...

Wow.  What prompted all of that hostility?

What you are saying would be true IF I were doing the Convert() on a column (meaning it would have to do the Convert()...

Select * From Table

Where Date(timestamp_column) >= DateAdd(Day, 1, DateAdd(Month, -1, Convert(Char(10), GetDate(), 120)))

If today is Nov 14, 12:07pm, for example, then...

GetDate() returns 2006-11-14 12:07:00.000

Convert() returns 2006-11-14

The inner DateAdd() returns 2006-10-14...

You could query the system table sysobjects (SQL Server 2K) or sys.objects (SQL Server 2K5):

If Exists(Select * From sysobjects Where type = 'U' and name = 'table')

  ...

Johann,

Have you considered using an insert trigger in the headers table?

What is the error message you are getting?

Deepti,

When you run a DTS package manually, the package is running under the context of your login on the computer you are running it from.

When you schedule a DTS package, the package...

net,

As to why you are getting the error:

Are the rows in your table more than 4,047 bytes wide?  If they are the combination of the two rows in the cartesian product...

isa,

You're pretty vague about where the data you are inserting is coming from.  This example assume you are inserting data from another table.

Insert

   DestTable

      (

       group_id,

       section_value,

       aro_id

     ...

jp...

Use a File System Object in an ActiveX Script task in your DTS package and look for the passed-in file name.

pcq0125:

Select

   srab1.TAGID,

   rab.TAGID

From

   s_RAB srab1

   Inner Join RAB rab

     on rab.RABID = srab1.RABID

Where

   srab1.ChangedDate =

      (

       Select

          Max(srab2.ChangedDate)

       From

          s_RAB srab2

          Inner Join RBL rbl

            on rbl.RABID...

jp...

It looks like you already have the DTS task which will run if the file is found.

Why don't you just set up an ActiveX script task with a File System...

I take that back.

A clustered index physically arranges the records on the hard drive.  This may improve retrieval times.