select [id], [desc], convert(float,Sum_Total) / convert(float,Sum_GTotal)

from (

SELECT [id], [desc], SUM(case flag when "Total" then [count] else 0 end ) as Sum_Total, SUM(case flag when "GTotal" then [count] else 0 end...

1 - not yet my domain

2 - t-sql your full query with "show execution plan" / "show estimated execution plan"

3 - no...

from BOL :

-h headers

Specifies the number of rows to print between column headings. The default is to print headings one time for each set of query results. Use -1...

C:\>isql /?

isql: unknown option ?

usage: isql              [-U login id]          [-P password]

  [-S server]            [-H hostname]          [-E trusted connection]

  [-d use database name] [-l login timeout]     [-t query timeout]

  [-h headers]          ...

That's a T-sql option :

Tools\Options\Results uncheck the checkbox and apply.

Your applications will not have this by default.

- aparently I can only "reply with quotes". Normal reply does not have an accessable textbox.

- can you provide the toppic's subject in the reply-notifications-email  ?

sqldmo script database-properties ?

Functionality should be the same. Physical implementation might not be. I'd stick to aht ANSI standard. cfr isnull and coalesce.

Very nice !

Seems to me the "edit post" does not always give an editable inputbox. + the "old" text is not in...

Very nice !

Make sa jobowner.

Your sql-agent-service-account needs to be able to access all needed files, db, ...

You could also open the commandline setting a proxy-account (check BOL), but I don't know if...

Can you open the DTS-package with EM on the server itself ?

If not, MDAC is your problem.

Only create an maintain DTS-packages at the server itself, not using a client...

Check http://support.microsoft.com/default.aspx?scid=kb;en-us;272318 (sql2000)

http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD (SQL7.0)

mdac-components are stored in the dts-package, that is the problem !

ALWAYS (shout is out as loud as you can) edit packages on the server itself ! Not from a client!...

quote:

---

select distinct p.product, c.currency, c.customer

from ...

where ...

...

---

You may even get advantage by...