the (+) operator in an Oracle join condition should be translated into an outer join

line 455 is missing:

$results5 |convertto-html -Title

it should read:

$results5 |convertto-html -Title "Backup Status" -Head $a -Body "<H2> ERRORSoutLIST </H2>" | out-file $workingdir\errors.html

glad you mentioned Relational, Inc. Otherwise one would get the impression that M$ invented everything that is in the current Sql standard. Especially now that Sql Server 2008...

broken link for the continuous partial attention article

http://www.sqlservercentral.com/links/604007/210733

can you try the same query on the db server machine? If it not slow there , then it is not the database 🙂

Joe,

I just don't see how to do the duplication with a value that varies by row.

chris,

my calendar shows april 15 2011 as the 3rd friday of the month, as april fools day is the 1st

Hi Andy,

Any chance that you can move your articles out of the future and into the present? The first article has a posting date of 2011/03/30 and...

Q from another noobie,

is there a way to escape the '<' and '>' so that it doesn't get converted to &gt and &lt?

I am using FOR XML PATH to...

If by career you mean moving up in the management ranks at a single company, that went out with the depression-era generation. If by career you mean continuous learning...

It depends....

If you are looping thru an OLTP system, then there is locking overhead with a cursor that you want to avoid.

If you are looping thru a reporting system that...

dead nuts on! gui tools are great only if you understand where the data is coming from and the limitations of the data. I know many developers who...