I wonder if some of the confusion is from people transitioning from Oracle PL/SQL and other compiled languages where the language is much more sophisticated and clear.

CREATE/BEGIN/END have...

Nice advertisement.

You'll reference ORS5330-Prod as the Data Source in the linked server properties if you use the Microsoft OLE DB Provider for Oracle. We use the same string for the...

That post hints at another argument against putting integrity rules into the database... The integrity rules can be complex and cannot all be implemented in the database.

So, do...

What API are you using to generate the report?

I've done some extensive work with Crystal 9 in ASP.NET against Report Application Services (RAS) using the crystal RAS client...

It seems to me that the original XML is malformed by any definition and should have used CDATA or escaped the "content" in the first place.

It's been my experience in...

Jack,

I think you've touched on the sensitivity that most developers (me too) have regarding DRI, but I think some would argue that DRI is not complete without cascading deletes....

Does anyone think it is a little weird that if you specify a value it can be from 1 to 8000, but a varchar can hold upto 2^31-1 bytes if...

I agree with your point that the "permissions options" are valid issues especially when best practices were mentioned.

I think the point of the question was that best practices,...

On the other hand...

You can get the information that you need with COMPUTE BY but it won't come back in one result set. This is one reason I've had...

You'll need WITH ROLLUP in the GROUP BY clause.

Skipping the middle columns and getting the totals in the right place requires a complex solution. It is not...

This has been and will be a huge hole in the out-of-box experience for SQL Server, though Oracle doesn't have it either. Quest Software's TOAD (for Oracle) is great...

Oh! Here the parameter is mentioned only once. This seems rather trivial and rather unnecessary though!

SELECT DATEADD(dd, -DATEPART(dw, X.ONEDATE)-5, X.ONEDATE) AS Day1

FROM (SELECT @YYYYMM01 AS ONEDATE) X

What are...

Would a user defined function work for you and/or the programmer?

SELECT FIRST_FRIDAY(@YYYYMM01)

Having posted previously that I haven't seen FK relationships enforced in the database, I want to say that all the systems that I've worked on did have _logical_ FK relationships...