Setting the format to text using the Excel "Format Cells" menu option does not always have the desired effect - no idea why...

That is because "Format Cells" only affects how...

The explanation on the question is not quite accurate, nor is it "Excel just does not handle nulls correctly".  This issue goes as far back as Excel 97 (that I...

It's not that it's more safer to start MSDE when needed (although I suppose it is safer, in the way that if it is not running, it cannot be hacked).

The...

WAIT!  I wouldn't necessary recommend that.  If the database is NOT going to be accessed from remote systems, it is better to disable the networking protocols to prevent access to...

You say these instances are MSDE?  Were they installed with "DisableNetworkingProtocol=0" (false)?

By default, MSDE installs without any networking protocols. SQL Manager will only browse and pick up SQL Server instances...

See this MS KB Article: How To Move a Database Diagram

http://support.microsoft.com/kb/320125/en-us

The Convert version from Phil will only work for seconds < 86400 (nbr second in a 24-hour day).  If it is possible to have a greater value, you will want...

You can pass in the table name only as a text string (varchar/char argument).  But you cannot use that table name in a query directly.  Your sproc would either have...

Steve;

The BEST approach would be to redesign your Procs table to eliminate the repeating DiagID field.

PROCS(ID, PATID, DATE, CPTCODE, DIAGID)

This is accepted best practice (normalization) and will make your...

But understand that the governor is for concurrent database QUERIES, not concurrent users.  Because most applications, web or desktop, spend most of their time working with data, not retrieving the...

There is not a maximum number of logons.  You might mean maximum number of connections.  By default, that should be 32,767.  Run SELECT @@MAX_CONNECTIONS to be sure.  If it is...

Or, if you want to do it in one expression, it's easy if you reverse the string:

REVERSE(SUBSTRING(REVERSE(@test),1,charindex('\',reverse(@test))-1))

How about:

dateadd(s,sum(datediff(ss,'0:0:0',CONTHIST.DURATION)) ,0)

I assume you are starting the cobol app using Process.Start method.  Are you using the overloaded version that uses the ProcessStartInfo class?  Have you tried to use this to capture...

Why not use that query and run it through Index Analyzer?  You don't have to accept the results, just see what it recommends.