Works like a charm. Thanks!

CY

Thanks for the reply...I wish I could. I'm running a query that is emailed. I would like to format that number column into standard form. The column is an integer...

I would try:

IF EXISTS (select c.name from dbo.syscolumns c, dbo.sysobjects o

where c.id=o.id

and c.name='MY_COLUMN'

and o.id = object_id(N'[dbo].[MY_TABLE]')

and OBJECTPROPERTY(o.id, N'IsUserTable') = 1)

BEGIN

SELECT PRIMARY_KEY_COLUMN, MY_COLUMN +...

Prior to truncating the table why not just export the data to the archived table with an additional date column for your archived date? like.... Insert into Archive Select column1,column2,getdate()...

Excellent Thanks!

CY

Thanks for all the input. I wish I had control over the design however I do not. I was tasked to build a report writer that would show all the...

Works like a champ - Thanks - CY

Has the attachment location been moved?

At some point in time I can envision someone asking me to show in a spreadsheet only those values in a table that have been updated. This table in question...

I guess my question has not been properly formatted for that, my apologies.

All I’m trying to do is query the table in such a way that the Values for...

The drives are just column values. I have imported a text file that has that following properties

Table 1

Col1,Col2

A,1

B,2

C,3

D,4

What I need is a format like

Table2

A,B,C,D

1,2,3,4

Sorry the table format is like:

Col1 COl2

System MYPC

OS Name ...

Are you trying to execute code via a scheduled task?

Sorry I was not following your logic - Why not just write an Update trigger to Update table B.comments when an insert is made to Table A.comments and then...

Why not use a IF Exists statement to do your updating\checking?

Then if your criteria is met, Do your listing - If not update the other table....