Try this out:

DECLARE @Table table (
    Col1 char(1),
    Col2 varchar(6),
    Col3 smallint
)
;
insert @Table
    values
        ('A','before',100),
        ('A','after',10),
        ('A','after',80),
        ('B','before',280),
        ('B','before',20),
        ('B','after',250),
        ('C','before',150),
        ('C','after',220)
;
With groups...

What version of SQL Server are you using?  SQL 2012 and above have the functions LEAD & LAG which you could use:
select
    *,
    DATEDIFF(MINUTE, LAG(LogDateTime, 1) OVER (PARTITION...

Have you considered using xp_dirtree instead of xp_cmdshell.  It carries less risk.  To your question/error, the length of the in column in your temp table (#Dir) is too small.

First, based on the code you've posted, data for the 10am hour will duplicated in both time frames you've defined.  There was another article posted by Bob Hovious today on...

Just a heads up; some of the techniques discussed can be skewed (in use) by maintenance jobs like re-indexing.

Doesn't really matter since you can have multiple replicas, but can a replica be clustered as well?

sjsubscribe (4/16/2010)

---

A company used to award free home computer until a couple of years later one employee refused. Then everyone caught on that the home computer put them on-call for...

I once worked for a company with a "forward thinking" executive who initiated a Halloween Costume Contest her first year with the company. The company was "supposed" to provide...

Mad Hacker (3/12/2010)

---

We periodically have a cookout or snack day at my present employer.

At one of my former employers we had a horse shoes tournament complete with brackets which wasn't...

My current employer has a workout facility which rivals any gym on the planet. Occasionally, I'll get to watch the K-9 officers practice or listen to the color guard...

Elliott W (9/15/2009)

---

Bert (9/15/2009)

---

Given that you must supply a unique Virtual SQL Server name with an associated unique IP address during a CLUSTERED SQL Server installation, why couldn't you create...

Retraining?...How about training? I haven't had any employer funded training since 1994.

Ergo Chairs?...I once worked for a company that would not provide an ergo key board when I had...

Dave (3/5/2009)

---

Bert (3/5/2009)

---

Do you pay taxes in the USA? Do...

dphillips (3/4/2009)

---

I find it hard to completely trust a conscienceless government to keep appropriate mistake-free records. All people as a whole must take some personal ownership and responsibility in a...