Try this

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=528

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

If you put the reference to your external table in dynamic SQL then the SP will the compile, you can then check for existence before you try and use it

Simon...

Other options are to insert into a table variable with an identity column and return that.

Other is to join to a qub qeury similar to above

Simon Sabin

Co-author of SQL Server...

NOT IN in this case I believe won't be bad at all because the main filter is on the task, this will return only a few rows and thus NOT...

None of these allow the use of indexes

Use this

WHERE mydate >= CONVERT(VARCHAR,GETDATE(),101)

AND mydate < DATEADD(d,1,CONVERT(VARCHAR,GETDATE(),101))

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The best way is to return a table, have a look at

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=528

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Error handling is a funny thing in SQL Server. Some errors are not recoverable, and affect the context differently.

In your example the error is not recoverable in context and...

textcopy is the easiest way of inserting files.

Once in SQL you can just copy the data between servers using insert into statements, or bcp and bulk insert

Simon Sabin

Co-author of SQL...

Nice and simple.

I am not sure that you can use log shipping and replication in the manner that you describe. The reason being is that the subscriber will be subscribed...

Nice and simple.

I am not sure that you can use log shipping and replication in the manner that you describe. The reason being is that the subscriber will be subscribed...

Try this instead.

One word or warning, TSQL is very slow for operations such as this, so should only be done on a small sets of data

running

select dbo.function(column) from mytable

will...

FYI if you use text or ntext you have to use DATALENGTH (divide by 2 for ntext)

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Classic 3 tier problem, and maintaining connection pooling.

To allow connection pooling the connection string has to be identical.

Therefore the best way of doing this is to use the context_info. Every...

I have XP at home and 2000 at work. XP nicer stabler, has benefits like device rollback.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Good ETL tools are very costly. If your requirements are not large then using DTS is a good solution. The main difference is that a good ETL tool can allow...