If you are going to do searches within an ASP page then my approach would be to :

• create a VIEW for the SELECT and FROM part of your query
• Build up...

Well try changing the WHERE clause to

WHERE Name LIKE 'View[0-9]%'

The firewall admins asked me what I would recommend.

The CEO in my last place was also the owner of the company and he observed that there is a difference in attitude between the US and the UK.

Failure is...

Can we assume that the web server can use THEFORCE?

Have your tried replacing Data Source=THEFORCE with Server=THEFORCE?

SELECT * from dbo.tblInventory

WHERE intInvItemTypeID = ISNULL(NULLIF( @strTypeScopeX,0),fk_intInvItemTypeID )

IF @strTypeScopeX is zero the the NULLIF function returns NULL

The ISNULL statement therefore returns the value of fk_intInvItemTypeID

In effect you...

SELECT @viewname= 'View'+CAST(MAX(dt.value)+1 AS VARCHAR(50))

FROM (

SELECT CAST(SUBSTRING(Name,5,len(Name)) AS Integer) as value

FROM Views

WHERE Name LIKE 'View%'

) as dt

Steve,

If you had stepped up into the CTO chair you would have just burnt out faster. May be you would have made a difference, probably you wouldn't have.

For ages...

I have found that NVARCHAR, NCHAR, and NTEXT are rarely useful even in multi-lingual applications.

The Welsh use CHRW(333) but will tollerate the standard ASCII equivalent.

The Indic languages Urdu, Bengali, Punjabi,...

So if I have a temp table with id IDENTITY, field1....field n

and I write

INSERT mytemptable(field1...fieldn)

SELECT field1....fieldn

FROM dbo.mysourcetable

ORDER BY field2, field4

The IDENTITY values won't be in order of field2 and 4?

Strangely enough you can achieve quite a bit with just SQL Query Analyser and the template functions.

Right-clicking on an option and choosing "Script to new window as..." allows the rapid...

Well the APEX stuff isn't free but it is very good. If you start with a shrink wrapped ApexSQL Doc and a cup of coffee it will pay for...

Do I have to go through the all the CreateObject("ADODB.Command") stuff to execute a query to get the count back or is there a quicker way of doing this?

In the UK estate agents have their own dialect of English.

Agent: A property with a sea view.

English: Its on a crumbling cliff top that recedes at 6ft per...

The row size limit comes into play if the DATA exceeds 8096 bytes not if the STRUCUTRE exceeds 8096 bytes.

I seem to recall that for TEXT and NTEXT only 16...