You might also be able to use something like OPENDATASOURCE...

I'm thinking that if inheritance did exist in SQL Server, it would create a "work" table in TempDB, anyway... what's so terrible about using INSERT/EXEC to populate a temp table...

I'd start a new thread with a new subject... will probably get more attention that way...

Probably easiest to write a pass-through query (maybe to a view) in Excel and print from Excel.

Ok, thanks for the feedback... does that mean that you're all set?

Assuming that "TimeElapsed" is of the DateTime datatype...

SELECT currDt = GETDATE()-TimeElapsed

3 pages starting at...

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

Incomplete sentence... "Which scripting language does..."

What's the rest of that?

Heh... "google it" !

And then there's the subject of primary keys... especially if they're based on IDENTITY.

OIDK... WFM! 😛

Heh... deletes make me nervous, anyway... constitutes some form of lost data. I don't use cascade deletes because I want people to have to work at doing deletes. ...

If memory serves correctly, I believe that form of index hint is "deprecated". Try this, instead...

select ACCT_NUM, OPERATOR_NUM, BRANCH_NUM

from TRANS_J_DATA_FULL WITH (INDEX(IX_TRAN_FULL))

where TRANS_DATE >= @dStartDate and TRANS_DATE <= @dEndDate...

Don't use either... use the functions built for this...

1. Check if temp table exists...

IF OBJECT_ID('TempDB..#temptablename','U') IS NOT NULL

PRINT 'Table Exists'

...

Heh... in other words, there's no such thing as a Julian date of "107999"... can only go up to 107365... next day would be 108001.

With that in mind, the following...