Thanks,

It's as simple as that then.

I've used the select ... union all method too

I did have to change the code to

declare @sql nchar(1000)

select @sql = 'select * from sdfad'

but creating and running dynamic SQL is a good...

The first example worked fine, Sean. it will be inconvient to create another stored procedure to handle the error, but that's the best you can get.

BTW, I'm passing a database...

Well, reading is under rated as a skill. I had missed that sentence (and the solution below). Many thanks, it all makes sense to me now. Catch blocks can't catch...

Thank you Jack.

I have got the up_Error procedure working, but have decided that logging errors to a table fits what I actual want to happen.

To get up_Error working I created...

While the solution worked (using a table of dates) it was very slow when used on large tables so has been scrapped.

I have found a method that does what I...

Argh, trick question. You answer what you thing the question is not what it really is!

Thank you for your thoughts. It seems that there isn't an easy way to validate a date within a function (if ISDATE doesn't work for you). The CLR solution is...

select *

from tbl

where ISNULL(fromDate,GETDATE())<= GETDATE()

and ISNULL(toDate,GETDATE())>= GETDATE()

would work?

I accept that the function boils down to a CONVERT, but the problem is really about validating the string passed before calling CONVERT.

Eg

DECLARE @val CHAR(19)

SET

By coincidence I am getting the same error on 2005. The server share I was getting a text file from has been migrated to a new server and now it's...

I was looking at this and although I've decided on the OPENROWSET method, I have got the table structure returned by sp_help_job if that helps anyone.

CREATE TABLE #JobInfo(

[job_id] [uniqueidentifier] NULL,

[originating_server]...

I have tried to avoid NOT IN clauses, I couldn't remember why but here it is.

I usually use outer joins eg

select * from #Employees e

left outer join #NullOperation n

on e.EmployeeID...

What does SARG mean?

I'll go and look it up now, but I like to think of these articles as stand alone so would like an explanation the article itself.

Whether the...