Is there any advantage of doing so ?

- The avatar is my ntv650 easy riding with a bit of curves-fun.

The blade is like a wet dream with all these speedtraps they are implementing in Belgium(Flanders-part)

Books Online (BOL)

You can also search this site (sqlservercentral.com) for usefull scripts

Don't know where I got it from, but I 've modified it a bit to be suitable for virtual servers.

-- This script will get the listening port of the

--...

Maybe you should take locking into consideration.

Your methode will do fine, but when used with big volumes, the delete might lockout the table. You could avoid this by using...

the double quotes should be single quotes in this query. Then it should work just fine.

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...