smfiber,

If you join it as you, for each record in one table you'll get all the records in the other table. Although the where clause will cut it down...

Although I prefer using COALESCE as it is far more explicit when reading the sql you can also SET ANSI_NULLS OFF which and the system will happily compare Nulls.

cheers,

Mike

jraha,

Whilst creating an index with IGNORE_DUP_KEY will work I'm wondering how you go about identifying the lines that failed on the import and hence why you don't just fix them...

I've only ever imported csv files so haven't had the problem, and I assume that if you specify a format file you can't specify a row delimiter or you would...

Greg,

You can't alter a text column.

From the alter table help file...

<<<<<<<<<<<<<<<<<<<<<

ALTER COLUMN

Specifies that the given column is to be changed or altered. ALTER COLUMN is not allowed if the compatibility...

I agree with JBoals.

The data should be stored as an integer. Following normalised database structure you can then create another table - Units - with all the different possible...

doh - I should've found that given it's next to db_name in the help index.

Incidently - If you leave out the name it'll return the current database id.

cheers,

Mike

this'll work

select dbid from master.dbo.sysdatabases

where name = db_name()

Not sure if there's an sp that does the same

cheers,

Mike

But at least you can get Query analyser to help you with listing the columns (if you're using 2000) by right clicking and scripting to knew window the insert. ...

Instead of deleting and recreating it why don't you just disable and reenable.

ALTER TABLE <tablename> DISABLE TRIGGER <triggername>

ALTER TABLE <tablename> ENABLE TRIGGER <triggername>

cheers,

Mike

I'm assuming the Session("Ethnicity") is being set with a zero length string when no value is entered. This will fail. A Null will work and a valid integer...

Hey Mike,

is this table being used a lot? If so any reason why you're not creating and maintaining an ADO recordset and doing a .addnew and a .update.

Cheers,

mike

Carl,

This seems more an excel/ADO question than T-SQL. There are a few ways of referencing it. If you can run the query from excel then just...

Steve,

> Like dynamic sql, this is asking for an injection attack.

Can you explain what that means?

Cheers,

Mike.

A bit late but here's the same I picked up somewhere that was wrapped in a stored proc ...

/* CREATE PROCEDURE sp_FindStringInCode

-- Input variables, default null for custom...