When I run

select Catalog_Name

from INFORMATION_SCHEMA.Schemata

alls it returns is DATABASE container names.....am I missing something here?

You can get the tables names like this.

select name as 'TableName' from sysobjects where type = 'u'

dump them into a temp table and use them to dynamically create a select...

I when an figured it out.

select top 0 * into #MonthlyStuff from MonthlyStuff. Works Great.

Thanks!! Is there a way to create the table without the data?

I want to CREATE a table from the existing table

if you are comparing datetime logged in with getdate from servers in other countrys, don't forget about timezones.

I have 182 dts jobs that run in a 2.5 hour time frame. some of the tables have 100s of thousands of records. I avoid using temp tables...

What do you mean I didn't need to include the master? I dont understand.

After a couple of hours I came up with this

UPDATE master SET om_note = SUBSTRING(nte.txt_notes,1,60)

from master master

inner join orderNotes nte on master.orderid = nte.orderid

where nte.type_cd = '9'...

no, orderid is the common key between both tables. I need the txt_notes from the orderNotes table with the noteid is the max number with the orderid.

Edited...

GuardData: I am getting

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is...

I have kids older that some people on this broad! Trying to get rid of the last 2 kids(12, and 15) I feel like I am going thru...

thank you! GLLJR, your solution made everything easier for me. I need to get a good t-sql book that has some good examples. I seem to...

Open the DTS package(design mode), select property's (right mouse) and choose which logging options you want.

I do it all the time. Just drop the table after you use it.