cool - thank you!

yeah i know that i coudl just select what i want using WHERE but depending on what i am looking for, sometiem the query will time out.

I suppose i coudl...

well the problem is that from october 04 to may 05 we have accumulated about 3.2 million records and when it will usually timeout when i try to query it...

well it looks like when i say:

Select *

FROM tablename

WHERE datefield > '1/1/2005'

it acts as if i said:

Select *

FROM tablename

WHERE datefield >= '1/1/2005'

because the results include everything on 1/1/2005...

so in the from clause where you say tblgroups g, that is what tells the server that g is an alias for tblgroups?

ron k -

when you say select g.name i assume g represents tblgroups?

and in the next line, the from clause you say from tblgroups g.  why the g after the...

wow that's weird - the second of my previous post didn't post.  here's what i meant to say:

thanks everyone for your replies - that helps a lot but i do...

thanks everyone for your replies - that helps a lot but i do have another question.

it will probably seem dumb but i am (sort of) new to the concept of...

hey thanks for your replies - Aaron - sorry i did nto mention that there is a PK field called UniqueID.

yeah i have been able to run the DTS import with no problems so i woudl imagine it shoudl be fine.

that seems to have done the trick - thanks!

now one last trick - I am running this DTS package from a ColdFusion Template in a CFQUERY tag and i would...

ok so i got an Execute SQL task runnign first which empties the staging table.

then it goes to a transform data task which inserts the text file contents into the...

thats a pretty cool trick.  although when i ran it in QA it gave the following message:

Warning: The table 'erehab_data_temp' has been created but its maximum row size (39851) exceeds...

great! i will give that a try.  one quick question though - is there a quick and easy way to dublicate a table structure into a new table with a...

that was it - i had the source file in the DTS set to a mapped drive on the server - i didnt realize it was specific to the machine...