James

If unit,project and task is the unic combination per persom

Try

SELECT a.name, a.unit & a.project & a.task AS comb, Sum(a.Hours)/(select sum(hours) from test b where b.name=a.name) * 100 AS percentage

FROM...

There are at least two more methods.

You have to be more specific with your question.

Gosta

For better, quicker answers, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/

"VBA is no alternative"

Ok I understand your dilemma. But as VBScript is an integrated part of DTS you can develope

in VBA and migrate to VBScript. I can help you...

HI

Hopefully you are aware of the problems with format when you import data from Excel

with DTS or SSIS. I would do the pattern matching in VBA and save the file...

Shailesh

Google with

mysql sql server convert

I got 301 000 replyes.

I have not done it to SQL Server 2008 but

a long time ago to 2000 and at that time I used DTS.

Gosta:)

Thank you David J

It seems we are thinking at the same direction.

You can do it in VBA and VB script. In fact some time I development and tests

in VBA (testing...

🙂

I agree with Phil Factor. There is not just one method.

But what I miss sometimes is how is the customer of this application and

what are the needs etc.

I...

Phil

Thank you for pointing at your article. It was new for me.

But still why this labor in T-SQL when you can do all in VBA coding?

Best regards

Gosta

"Excel is a great tool for formatting data that you've extracted from tables or views. You can copy such data into an Excel spreadsheet straight from SQL Management Studio's output...

"In the past, I've typically done a "drop table", "create table" to handle things like this. The wizard is designed for the basics. If you need this to work more...

As I allready have stated I have abandoned Excel native format import because of the

problems.

But I became curios , will it work like described in the article which...

This is an interesting discussion. We are not alone with need to import data

from Excel.

At first look at the front Excel. Is the user permitted to key in any...

"Unfortunately "Microsoft.Jet.OLEDB.4.0" does not exist for IA-64..........unless you have heard otherwise"

If you keep to textfiles you don't need the Jet driver if you use bulk insert instead.//

//Gosta

"From what I've seen, importing data from excel can be very hazardous etc"

I agree on that.

But I have no experience with Excel2007 yet. Does it work as 2003 in...

a2zwd

Are you forced to use SSIS?

krayknot has a point. The procedure can be automated.

Maybe I am out on weak ice then I say I don't like SSIS for

tasks involving...