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...

or

IF Object_id('##table') > 0

begin

...

end

[Edit]

I don't know what you're talking about Noeld.. this works perfectly on my pc .

BTW.. It's tag team not team tag...

Can you post the table definition, some sample data. And what you are trying to accomlish

col1, col2, col3

1,2,3 >>move to tableV

1,2,4 delete if

4,6,9 >>move to tableY

I just love that numbers table... so little things you can't do with it .