G'day,

When used properly, these sorts of tables can be very beneficial.  Improved performance, simplified joins, simplified maintenance CAN be had.  The key phrase is "when used properly".  It sounds like someone...

G'Day,

I get this error about twice a week when moving objects from the development environment into QA.  It is usually one of two things - either the object is missing,...

G'day all,

I would like to offer an observation without claiming it is either good or bad - simply an observation.  The term DBA has came to mean a lot of...

G'day,

If I restate the requirements as a small set of distinct statement, I think I get the following.  First question: Am I understanding the requirements correctly?

Companies have zero or more...

G'Day all,

I have used ERwin, Embarcadero, Visio, and (believe it or not) Powerpoint over the last 25 years.  Oh, yes - lets not forget white boards and paper.  It is...

There may be other issues, but from a 5 second look, it appears that you are missing a comma:

update table2

set a= case x.cat when 'xyz' then x.value end,

b= case x.cat when...

G'day,

What you are suggesting is that the business change the way things are done.  Businesses change for one of two reasons: to increase the profitable revenue brought in the door;...

G'day all,

Goce's approach has a few advantages not pointed out above.  disclaimer: I am prejudiced in favor of this approach as I have used it successfully in multiple products.

Ease of loading...

Hello,

I have included two possible ways of building the query you are requesting.  There is a minor issue regarding the number of AreaCodes and therefore the length of the dynamic...

G'day,

The following is taken from books on line.  I *think* you could construct the readtext statement dynamically.  In other words, I think you need to use READTEXT instead of SELECT...

Hello,

Lets make sure you actually have an issue.  If you are using Query Analyzer to run a select statement, make sure that QA is configured to show the full width...

G'day all,

A word of caution might be in order.  Row Numbers are often requested so that the UI can attempt to update that particular row in the DB.  However, the...

There was indeed a contract between Microsoft and the esteemed Dr.  As was pointed out, interpreting and debating the syntax and semantics of that contract will take teams of lawyers...

G'day all,

I think the decision to discuss salary or not may also be affected by the nature of the relationship.  In my case, I am a very experienced independent consultant...

G'day,

Here is a simple example that shows one method to meet your needs.  There are several other ways to do the same thing.  Hope this helps

Wayne

create table #x

( id   int...