Gratzy

Gratzy has asked 4 questions and find answers to 33 problems.

Stats

About

Gratzy questions

Improve Sql Query with select max() function in where clause
Nlog Target Database set connection information at runtime
SQL 2005 CTE vs TEMP table Performance when used in joins of other tables
SQL Filter criteria in join criteria or where clause which is more efficient

Gratzy answers

oNode being Set to Nothing, but why, and how do I fix it?
Store an image name and extension in DB?
Is there an easy way to verify that a server exists on a network with VBScript?
Excel and IE7 - Prevent IE from opening Excel files
How to make MySQL MAX() consider NULL the smallest possible value?
SQL - selecting the first record found before a given date
SQL Server : How to treat nulls as zeros
PV Function and Porting VB6 to C#
SQL Query across two connections?
How to write event log using vbscript