craig-404139 (10/7/2010)

---

I see you added columns to the table, Can this be done without adding columns? I can't modify my production table(s). Also explains why the are like that. It's...

craig-404139 (10/7/2010)

---

Wow, impressive. Can you explain what the code is doing? I've never seen things like :

@GroupNo = GroupNo = case....

@Prefix = Prefix = LEFT.....

Looks like you are setting the...

Here's some code.

Note that I kept in the prefix checking... I need to strip it out anyway, so I just kept it in.

-- need to add some columns to the...

It's actually post # 1000643. Also, if you click the post number, you will get a URL that you can...

CirquedeSQLeil (10/7/2010)

---

Alvin Ramard (10/7/2010)

---

CirquedeSQLeil (10/7/2010)

---

Sounds like a college exam to me. Or...

:w00t::hehe::-P

Here's an alternative way that doesn't require verifying if the table exist, and doesn't perform a count(*) against the table if it does:

IF OBJECT_ID('tempdb..#TEST') IS NOT NULL DROP TABLE #TEST;

CREATE...

try:

set @t1=IsNull((select sum(a) from order where type='1'),0) + IsNull((select sum(b) from order2 where code='3'),0)

Haven't heard back from the...

Andrew - I'll test out your modifications tonight. Interesting the large difference in time between our systems.

Thanks for making the change to use the same # of characters for a...

Okay, I am seeing the IO frozen/thawed messages in the sql log, so it does appear that NT backup is the culprit. Time to work with the SAs to fix...

IMO, it...

Craig Farrell (10/6/2010)

---

WayneS (10/6/2010)

---

craig-404139 (10/6/2010)

---

Question: when a prefix changes, do the numbers restart at 1? Or do they continue?

(I've got some real nifty, high-speed code (thanks to Jeff!) to quickly...

Craig Farrell (10/6/2010)

---

Edit: Sorry for the multi-edit. Something didn't play nicely with the code= statements when I tried to first post this.

The Test Harness:

SELECT TOP 1000000

IDENTITY(INT, 1,1) AS N

INTOTally

FROM

Master.dbo.SysColumns...

Craig Farrell (10/6/2010)

---

Well, in that case, Amit, try a MAXDOP 1 and see if...