How about the following:

IF OBJECT_ID('tempdb..#RecsToPull') IS NOT NULL

DROP TABLE #RecsToPull;

CREATE TABLE #RecsToPull

(

DeptAbbr char(10),

CasePulls int

);

INSERT INTO #RecsToPull values('A', 1);

INSERT INTO #RecsToPull values('B', 2);

INSERT INTO #RecsToPull values('C', 3);

IF OBJECT_ID('tempdb..#DeptPurchases') IS NOT NULL

DROP...

C# Gnu (6/28/2012)

---

Yes Lynn that's...

Question, is the 2nd part of the UK Postal code always the last 3 characters and the 1st part 3 or 4 characters long?

Since you can't post the actual table DDL and sample (made up data) for the table that demonstrates your problem, not much we can do unless you can put together...

Also, Charmer, you have been around these forums long enough to know how to post DDL, sample data, and expected results. You really need to start putting more effort...

thadeushuck (6/28/2012)

---

Reboot is a pathetic solution answer for a routine situation that is nearly 100% resolvable without a reboot. I'd rather kill random spids until the shrinkfile command magically works...

Welsh Corgi (6/27/2012)

---

I did not find sys.syscomments until today.

Why is sys.sql_modules the preferred table?

That's funny that you mention NOLOCK's. I had someone tell me that the WITH (NOLOCK) was...

Not to hijack this thread, but I'm glad that the Cult of Mediocrity doesn't exist when evacuating citizens from areas of danger. The Colorado Springs Fire and Police Departments...

anush_tar (6/26/2012)

---

Sean Lange:

I have After Trigger on table, that's why I can't use SCOPE_IDENTITY() or @@IDENTITY. IDENT_CURRENT is not limited by scope and session.

That's why when 2 or more...

Just heard from my friend. They got out of the area with the fire right behind them. They are with family in Denver.

Mandatory evacuation area has expanded on the North West side of Colorado Springs. The area now includes the area where I currently work.

Waiting for email updates to know what...

Made a slight change to my code. I noticed I forgot to comment a closing paren.

Sounds good as I haven't had a chance to even look at it.

And we have another horror story, Already tried repair, rebuild, detach/attach, backup/restore (no backup prior to this error).

Do you have any way to recreate your data should you have to rebuild from scratch (which you may have to do in this case)?