Just reread the whole thing...

Can you post the table DDL and some sample data so I can figure it out?

You forgot that the db is already case sensitive. Here's how to do it when it's not case sensitive >>

Select name, id from dbo.SysObjects where name = 'sysobjects'

--seek

Select name,...

Also the TOP 100 Percent is useless without an order by. You either add the order by if required or drop the TOP 100 PERCENT.

SELECT TOP 100 PERCENT dbo.customer.username, SUM(dbo.iheader.total) - SUM(dbo.iheader.paid) AS balance

FROM dbo.customer INNER JOIN

dbo.iheader ON dbo.customer.id = dbo.iheader.guarantor

WHERE (dbo.customer.storeid = 1) AND (dbo.customer.active = 'n')

GROUP BY dbo.customer.username

having SUM(dbo.iheader.total) - SUM(dbo.iheader.paid) =...

I can't help you much there as I've never done it...

Can you consider using a dts package for this?

You might also consider normalizing this table .

Declare @demo table (Ratio varchar(7) not null primary key clustered)

Insert into @demo (Ratio) values ('4/7')

Insert into @demo (Ratio) values ('1/6')

Insert into @demo (Ratio) values ('1/7')

Insert into @demo (Ratio) values ('1/8')

Insert...

So true... I guess he started learning in .NET .

Define duplicates and what you need to do with them.

Can you post more information >

- Table definition

- Sample data

- Required results

Create a linked server that points to that file.

Then select * into NewTableName from LinkedServer.?.?.?

This is assuming that it is a one time deal.

You can also use DTS to do...

If you say so ...

Select right(CitationID, 1) as CitationIDLast from...

Yes there are. Steve has 6600+ posts and antares is in the high 6K too.

Well I guess I can't really hide in here anymore

Yes, but it'll have to complete at the next server startup so you're pretty much screwed... unless you have a full backup of the db that can be restored faster...