the

) a

seems to be missing from your post.

In your case, I would do it in the app. SQL has no parsing ability, only string slicing. To get SQL to do you would have to write udf or...

Can the app split each line and then insert the 10 columns. How is the app inserting the data?

If you use a GROUP BY clause then any column not part of an aggregate statement needs to be specified in the GROUP BY as per the error message. Either...

How are you 'pulling in the data' DTS / BCP ?

If you have SQL2K then you write a udf to extract the data, I believe there are examples on this site, try a search. There may be other solutions too.

If...

I have never heard of Solid, but...

Since you have the ODBC driver and DSN setup then use DTS to transfer the data, it will be the most efficient. You can create...

Firstly, whatever works.

However using money or smallmoney your output will always be to 4 decimal places, that is the nature of the data type.

Personally I would use numeric (aka decimal)...

I rewrote the query like this

SELECT department,

  [Date],

  SUM(CASE [Product] WHEN 'E-Tech' THEN [output] else 0 END) as 'E-TECH',

  SUM(CASE [Product] WHEN 'E-9' THEN THEN [output] else 0...

Why not create a single proc and pass isClosed as a parameter, it is what is recommended in BOL and sql will likely cache both procs with a single plan...

If you are mapping a local account then you must login with sql security using the mapped local account specified, for the link to work otherwise you will get the error message.

If...

what's wrong with you? ASKING a question, instead of answering?

Thanks Frank ...

If you are trying to output the contents of your temp table using BCP, you will not be able to unless you use a global temp table.

for example to output...

Just because 71.8% got it right does not make the question too easy. Would this mean if 71.8% got it wrong then the question was too hard?

The question seemed OK...

You have put a single quote around the command, change the 3 single quotes at the beginning and end of the line like this

SET @MyCmd = 'bcp "SELECT * from...