Alvin Ramard (11/16/2010)

---

GSquared (11/16/2010)

---

Chris Morris-439714 (11/16/2010)

---

No idea, Wayne.

That really freaked...

It means you lost the connection. Could be anything from a bad cat-5 cable to a faulty router, any number of things.

Chris Morris-439714 (11/16/2010)

---

No idea, Wayne.

That really freaked me out, it...

There's a sys.indexes system view you can select from. Use Object_Name() on the ParentObjectID column.

Ah. That makes sense then. Forgot about those.

Try something like this, see if it does what you need:

SELECT

Employeenumber,

Name,

CASE WHEN SUM(totalminutes) > 480 THEN 480

...

Learner1 (11/15/2010)

---

Here is the complete code with inserts... to find 3rd highest salary

try it..

CREATE TABLE [SAL](

[name] [varchar](12) NULL,

[salary] [int] NULL

)

select * from SAL

INSERT INTO sal ( ...

Same thing, just replace 'ABCD' in either one.

I'm curious as to why a loop is needed here at all.

It looks to me like what you're doing is taking all of the rows in one table, based on...

Paul White NZ (11/15/2010)

---

How do you know the target table does not have...

If you have a trace running that captures that kind of thing, it's pretty easy to find out.

If you have a DDL log, again, it's easy to find out.

If you...

A separate copy, like Gail mentioned, is what I've recommended in the past. If what the analysts are doing has value to the business, the RoI on hardware for...

The trigger fires as part of the insert, so the error value would be after the trigger, I think.

Test it. Put a trigger on a test table that has...

Honestly, this kind of thing becomes trivial to solve with a proper Calendar table. Anything else requires the kind of complex math you're looking at here.

If you can post actual table names and structures, this can be done in a single query pretty easily.