Ever so slightly better:

SELECT C.Name

FROM @Colors C

WHERE NOT EXISTS

(

...

Nice problem.

SELECT C.Name

FROM @Colors C

WHERE NOT EXISTS

(

--...

Indexed views can be created in any edition of SQL Server. (reference)

You have to use the NOEXPAND hint to access them in non-Enterprise-equivalents though. This is not necessarily a...

On the whole approximate data type thing...compare the following table of data type, storage size, largest number that can be stored, and precision:

REAL 4 bytes. 3.4E+38 precision...

Use SELECT instead of PRINT as Lutz mentioned.

Use FLOAT instead of REAL here. REAL is limited...

It is problematic in 2005 for the reasons you describe. Big arrays = lots of memory usage = poor scalability. On 32-bit SQL Server you are also likely...

Phil,

Yes, I think I understand. But how about just one example of sample output? Do you want one row per detected change per product, all changes on one...

john.campbell-1020429 (3/9/2010)

---

If you use defaults for these new columns and they do not change...

dias.nanda (3/4/2010)

---

I need to store an URL in my SQL Server 2005 database... which data type should I use? I was thinking in use nvarchar, but I'm not sure...

I like to help where I can 😛

GilaMonster (3/8/2010)

---

I 'complained' about people repeating my posts word for...

Scary. Get him to run this on a TEST* instance:

-- Using tempdb for demo purposes only

USE tempdb;

GO

-- Test table

CREATE TABLE dbo.IdentityTest

...

Those table sizes are only moderate - not too scary at all. Correct design is key, as mentioned in the previous comments. With a relatively small number of...

Isn't 30 seconds the default time out interval for a Command object execution in .NET languages?

Just a thought.

2Tall,

Could you confirm the expected output based on the sample data please?

If it is not obvious from the sample, please also explain the rules for producing the output.

Thanks

Paul