Kbear (8/29/2008)

---

If a company can't survive without anyone for a week or two, it's very bad practice. If you had a family emergency or were very sick (or worse), what...

Have you tried running the SSIS packages in scheduled jobs? Or are you just running them in Visual Studio?

The reason I ask is because Visual Studio (and Business Intelligence...

This is a duplicate thread. Please post replies to the copy in General Discussions. Please don't double-post.

I would do the benefits hours like an inventory system. Positive entries and negative entries in the same table, with a type and a time stamp. When an...

Are you looking for a list of every city in the world? I know where you can get a list of all US and Canadian cities (listed by postal...

It's a standard, recommended practice to have indexes on foreign keys. It's almost always a good idea.

Many-to-many in a separate table is the way to go on this. I've been through what you're proposing, and it works great for a few weeks, and then you...

I have a script that I use when switching from 2000 to 2005.

use [database] -- Please remember to fill this in!!

go

dbcc UPDATEUSAGE (0) WITH NO_INFOMSGS;

go

DBCC CHECKDB (0) with no_infomsgs;

go

--...

I run checkDB before I do backups. Can't see the point to backing up a corrupted file.

No reason to update stats before/after an index rebuild, since it does that...

I finally had time to test this, and I found something I hadn't noticed before. Your test data (first post) has duplicate IDs and all the dates and times...

Adam Bean (8/28/2008)

---

GSquared (8/27/2008)

---

I had a problem similar to this once when I forgot to tell the agent to use the DB Mail profile to send alerts. Is it...

I haven't ever taken an actual vacation, but if I did, I would probably remain compulsively connected.

I misunderstood your question about "Row". No, the ID column is the ID from the original table. You'll need to add that to the temp table.

In the first query, change:

and C1.Row = C3.Row+1

to:

and C1.Row = C3.Row-1

See if that gets you what you need.

On the second query, I often call the row_number column in a CTE...

Trigger could work, but make sure that it will work for multiple rows (the variables in your sample code will break it if multiple rows are added at the same...