Well, in that case, here's another one. Only works on INT's >= 0.

SELECT

N,

LEFT(CAST(N % 10 AS CHAR(1)) +

...

It looks like the SET ROWCOUNT setting is reset when you start debugging (ALT-F5, with or without breakpoints). When just running (F5) the script the SET ROWCOUNT setting is not...

I know this is an old thread, but just in case someone is still interested, here's a solution without explicitly referencing all columns and no dynamic SQL.

CREATE TABLE #Test

(

...

DECLARE @dynamic TABLE (id INT PRIMARY KEY, type INT, dynamic_name VARCHAR(100), dynamic_table_id VARCHAR(100))

DECLARE @tables TABLE (table_id INT PRIMARY KEY, table_name VARCHAR(100))

INSERT INTO

@dynamic

VALUES

...

As an alternative, you could use NOT EXISTS (SELECT [@Stag].* INTERSECT SELECT [@Prod].*) to compare rows. Some code to play with:

DECLARE @Stag TABLE (Column1 VARCHAR(100), Column2 VARCHAR(100), Column3 VARCHAR(100))

DECLARE @Prod...

That's a good thing to...

Paul, thank you very much. I'm really honoured by such a compliment from the master of T-SQL & query optimization. However, I still feel a little bit uncomfortable about the...

I'm sorry I have to disappoint you, but I don't know DB2 either, so I can't help you on this.

Not necessarily.

select

GETDATE() - CASE WHEN cast(GETDATE() as time) > '12:00:00' THEN 0 ELSE 0.5 END [SomeDate]

into

...

What's the data type of Column1 one in DB2? It looks like a structure containing 6 columns:

Pos 1: CHAR(1) - 'B' = 0xC2 (EBCDIC) = 0x42 (ASCII)

Pos 2-7: NUMERIC(11) Packed...

DECLARE @Table1 TABLE (Account INT, Amount DECIMAL(10, 0))

DECLARE @Table2 TABLE (CostCenter VARCHAR(10), Account INT, Amount DECIMAL(10, 0))

INSERT INTO @Table1 VALUES

(1, 1000), (2, 500), (3, 1000)

INSERT INTO @Table2 VALUES

('a', 1, 100),...

Jeff Moden (1/7/2012)

---

So what is the conclusion here? That you shouldn't try to do "enterprise-scale" quirky updates on a box that has less memory than most of today's handheld...

SQL Kiwi (1/6/2012)

---

The way I read your comments makes it sound like this mysterious self-blocking only occurs when...

Paul,

I don't think the TF 652 has something to do with it but I'm still trying to figure it out. I'll let you know when I've some better results. Taking...

SQL Kiwi (1/6/2012)

---

Certainly. I ran the tests on 2005, 2008, R2, and 2012 64-bit because I wanted to see if...