So the major drawback is that they are executed for every row?  Why wouldn't I want a Scaler Function to execute for every row

Stored Procs (in my opinion) are good for updating large sets of data or maintaining Business Logic while Saving / Deleting Records.  I find them very inefficient for returning data...

First off, I'd like to say that this was an "OK" example.  This is definately NOT how I would approach this issue of Proper Case.  Since most of the time...

Clay has a point.  This often comes up when designing an interface / presentation layer to my database objects.  Recently though, I've been taking advantage of .NET's DataSets & Relationships...

dcpeterson, I couldn't have said it better!

I use .NET and Stored Procs heavily.  Since I basically control the Business Logic and Database aspects of an application, I want to make sure that other programmers do NOT...

Well, there's comes a point and time when you'll be working all weekend trying to fix a client's data...and because it's so screwed up you don't really care anymore about integrity...

I guess it was more of a hypothetical question.  I know they are good to have.  Unfortunately, I cannot control the client's IS Dept.  However, I just wish SQL Server...

Well, I've discovered it's impossible to restore from T-Logs if you don't have every single one of them from begining to end.  So I ask...what good are they??

Anyway, I downloaded...

Well, I think I am doomed.  I did what you said, which worked...to a point.  However, my T-Logs are not in order.  I am missing one day's worth because the...

Why would you want to?  You'll already have that Key in your DataTable.  Unless you've got a Student who is logged into two machines at the same time, and somehow...

Since I hate Identity Columns (i.e. Autonumbers) I will suggest a new Key for your Tables... It sounds like you can get away with this.  However, you can always go...

What kind of table is this?  What is it used for or what data does it contain?

Well, @@IDENTITY is not always safe to use ...Read the BOL.  Instead you should use...

Select Ident_Current('TableName')

...which will give you the last inserted ID on that...

Of course you're having dificulty!  You need another Column Called "WordType" which would discern whether it's a Verb, Noun, etc.

Data:

ID     Word     Type

1      Dog       Noun

2      Cat       Noun

3      Bird       Noun

4      Good     Attribute?

5      Run       Verb

6      Mane     Attribute?

 

CrossTab:

ID     Noun     Verb    Attributes

1      Dog      ...