"CASE" doesn't quite work that way.

It can have one of two formats. The first is a "simple case".

CASE [Value or Column]

When [Value or Column] Then [Value or Column]

......

Just me trying to bring Chlorine Trifluoride to an Amonium Nitrate fight. 🙂

The reason it has to work on "boundaries" instead of day multiples or something like that is simple to demonstrate:

How many months are there between Feb 5 and Mar 5,...

You might get what you need if you include column 48 in the trace event.

http://msdn.microsoft.com/en-us/library/ms186265.aspx has the data on what events can be traced, and what columns are available for...

Here's where your trigger is breaking:

select @pk = column_name

from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

where TABLE_NAME = 'demo'

select @pkey = @pk from inserted

What that does is assign the column name to the @pk...

Just splitting them up will usually give some performance increase, since it will reduce locks and contention. Maybe not enough, though.

Even in that scenario, the design of the main...

I'm not clear on what you need.

Can you provide the table definition you are querying?

Why does this look like class homework to me?

With the values you've given, LEFT() would do what you ask for.

Lowell (3/22/2011)

---

homework question:

Auto commit has been turned off.

1- William logs into the database

2- Julianna logs into the database

3- William sees 12 rows in the TOYS table...

The problem is that you have this in your Anchor:

WHERE ManagerID IS NULL

That means it will only get people who don't have a manager. Then, your recursive portion tries...

42

What's the question?

Bah! I'll see your Amonium Nitrate and...

Hey, Mr. Taggart, how about some more beans!

Use the "inserted" table in the trigger.

I'd have to actually see what you have for your trigger to suggest anything more concrete than that.