wilburb (12/28/2010)

---

While I appreciate your frustration and point of view, I must say that as a resource in a rapidly changing environment I use many forums to augment my knowledge....

Not sure who you mean by "Crazy 8", but I'm going to hazard a guess you mean me, since that's my current "title" for this page. (It says, "SSCrazy...

Parthi:

That will generate negative hours if it's after noon. For example, 2 PM will end up as -2 PM. Not sure that's what you want.

Also, that kind of...

A design that contains a simple table to define what types of work a person/entity can do will be very easy to build and manage. Then use that to...

I think for SQL 2000, I'd do it with a loop. This is pretty much what the ranking functions and Apply were added to SQL 2005 to solve.

I'm not sure what exactly you're looking for here. If you just want to replace the string with a column in a table, just do that.

If you want a...

You're welcome.

Database schema are similar to XML schemas, in that they define the data that will be held. The difference is, in a relational database, the "schema" IS the...

Please take a look at these articles on this subject: http://www.sqlservercentral.com/articles/Auditing/63247/ and http://www.sqlservercentral.com/articles/Auditing/63248/

There are examples there of efficient ways to log data changes. The discussions on them have a...

Keep in mind that CDC locks down table definitions the same way replication does. This means you cannot alter or remove columns without turning off CDC in some cases....

Are you building a dynamic SQL query? It looks like it. If so, then the datetime variable may not be properly enclosed in single-quotes.

If that's not the situation,...

You might be able to get what you want with Pivot/Unpivot.

It looks like you're heading down the "one true lookup table" path. Keep in mind that those always appear...

I wrote a couple of articles on that subject. They're here: http://www.sqlservercentral.com/articles/Auditing/63247/ and http://www.sqlservercentral.com/articles/Auditing/63248/.

If you read them, make sure to read the discussions as well. There's a lot...

That is a schema design for the database. Well, it's the outline of one (logical design).

schema

Definition

sche·ma[ sk?m? ]

sche·ma·ta Plural

NOUN

1. diagram: a diagram or plan showing the...

Richard Weissler (12/28/2010)

---

> "write it all down. Think of it as a ‘State of You’ letter. Write down what you’d like to do and why and how and when. "

I...

CirquedeSQLeil (12/28/2010)

---

Thanks Andy and Gus. I like the idea of resolving to enjoy something more. That is a better way of setting goals. Next step is to...