Looks like I've got imbedding a variable into the script on the brain.  Here is a different example with a more complex selection logic, but no variables.

use Northwind

declare @i int,@sql...

Someone mentioned using a temp table, but didn't give an example.

use Northwind

declare @i int,@sql nvarchar(2000)

create table #tmp (i int)

set @i=-1

set @sql = 'declare @i int

SELECT @i=MAX(CategoryID) FROM dbo.Categories

where CategoryID...

1.  It helps if you have valid XML.  I parsed yours into an XML file and found several errors.  Searching for & should find several occurances of bad attempts to...

That length of variable bug is sometimes hard to find.  I had a varchar(8000) field truncating to 4000 characters.  As soon as I cast all of my nvarchar variables I was...

"COUNT(*), on the other hand, does not eliminate NULLs."

Actually, COUNT(val) will always eliminate nulls, but * includes all fields in the table and by definition is not null and will not be...

Another place to watch out for

... WHERE field NOT IN (SELECT field2 FROM tbl)

If field2 ever has a null value, this will always result in no selections.  It's funny, if...

FYI sql like 'customerid = ' & sCustomerID

Can be 'isnull(customerid) = isnull(' & sCustomerID & ')'

or it can be '(customerid is null and ' & sCustomerID & ' is null)...

1. The master database that ships with sql2000, why is it there and what is the main purpose of it?

Believe it or not, SQL existed for years before MicoSoft was...

A "one to many to ONE seperation table" is what I call a bridge table, others call it a link or linking table.  This bridge table will have keys from...

if NOT exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_DisplayTableRelation]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

 exec sp_executesql N'CREATE procedure usp_DisplayTableRelation AS print 1'

if NOT exists (select * from dbo.sysobjects where...

Sorry about the double spacing.  That's this posting routine getting involved.

if NOT exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_DisplayTableRelation]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

exec sp_executesql N'CREATE procedure usp_DisplayTableRelation AS print 1'

if NOT exists (select * from dbo.sysobjects...

 I immediately blew up on a recursive loop count error, basically because your code can put the table references in an infinite loop.  Here's an extract of the output after...

1. If two products have the same max width/height, you can't store them both with the primary key given in the example.  It may be better to create a new...

If you are going to use custom types, while you are at it, make your date part an int field to save 4 bytes of storage there as well.

I have...