Sure the nested ISNULL(NULLIF()) works, I just find the Case statement easier to read. I'd run both in the same SSMS window and see which one is more efficient.

I'll be the third vote for having a page for posts with 0 replies. When there is nothing I want to answer in Active Threads I go through the...

Put me in the data is data, coding is coding group. As has been noted by others, sometimes "Industry Experience" is more of a hindrance than a help.

When I...

I also have to agree with Grant, but in my experience you will rarely be joining enough tables where the order will be important. Also, in my opinion, you...

With SQL Server 2005 your service accounts only need to be standard domain users. If you use the install process or SQL Server Configuration to set/change the service accounts...

I don't think you could use it in the XML, but you could do this in your insert:

SELECT

SCOPE_IDENTITY(),

...

I found this quote in this article at MSDN:

The following example returns an error due to the CONSTRAINED flag. While the set specification provided a valid MDX set expression, the...

What is the connection string being used to connect?

Are connections being left open by the application or is the application opening and closing the connection when it is done with...

This is my understanding as well.

Exec sp_helptext 'view name'

Are other users able to connect to this SQL Server? Usually this error means that you have not configured the SQL Server for remote connections or the user does...

Jay Sapani (12/31/2008)

You likely need to escape the single quotes in your where clause or you can use double quotes around Jay as at least the Foxpro ODBC and OLEDB...

Yeah, that would be great!

Glad you could find it useful.

The where clause is in the SQL statement defined in @sql and the parameters are defined in @parameters and then passed in the execute SQL. If you run this...

Sorry, it's 3:30 in the morning/night where I am and I couldn't sleep, so I thought I'd answer some questions.

The first part is building your select statement in...