Might be a better idea... after all .

In case you didn't notice I was KIDDING about the shrine. All I need as a temple .

SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.*

FROM dbo.sysobjects INNER JOIN

...

God!!! I just realized how much of bunch of Geeks we are....

2 things come to mind :

1 - Is it possible to merge the 3 lookup tables into one (if it makes sens)?

2 - You can make 3 derieved table...

I can't talk for USA, but here in canada, the standard when you start is 2 weeks, then 3 after 2 years, then 4 after 5 years. I know...

Well he knows you .

insert into record0

select * from record001

where

left(FirstCol, 2) = '00' AND

(

agency is null

or trans_id is null

or ISNUMERIC(trans_id)=0

or isnumeric(accounts_trans)=0

or...

Thanx David... Always something else to learn .

I have no table worthy of that term... The biggest table I have only has 20k rows... nothing near the million..

I just like to help... I don't need no shrine.

Basically it means that you install 1 server with the cd. Somewhere in the install you'll have an option to save the install to a script. Once the...

Hey Frank.. you don't like to use a numbers table for something like this?

NP = No problems

HTH = Happy to help

I just retested my idea and found a few gotchas :

use NorthWind

GO

Select object_id('##temp')

--null

GO

create table ##temp

(

a varchar(10) not null

)

GO

Select* from ##temp

--empty set

Select object_id('##temp')

--null

USE tempdb

Select object_id('##temp')

--1222255034

GO

drop table ##temp

go

It seems you must...