System views can give you this information without having to roll your own pattern matching.

sys.procedures has all the procs listed in it.

sys.all_parameters has the parameters.

sys.types has the data types.

select procs.name...

Is the job something you can change the isolation level on? Or change the sequence in which it locks resources?

Gail (4/25/2008)

---

GSquared (4/24/2008)

---

How accurate do you need this to be?

Let's say you're starting with latitude 47.61, longitude -122.34 (which happens to be in Seattle, WA), and you want to find...

One way to do this is liberal use of IsNull/Coalesce in the Where clause. For example:

Where MonthToDate_Total >= Coalesce(@MTDGreaterThan, -1) -- Assumes can't validly be negative

and MonthToDate_Total <= Coalesce(@MTDLessThan,...

Jeff Moden (4/25/2008)

---

Try...

This one will handle the data even if one or more of the rows is incomplete:

create table #Raw (

ID int identity primary key,

RawData varchar(100))

insert into #Raw (rawdata)

select parsed

from common.dbo.stringparserxml('"S9000+"

"UV+...

I don't think he actually posted the code for this one.

SQL 2000 has it in syscomments, 2005 has it in sys.sql_modules.

Syscomments breaks it up into 4000 character chunks (if I remember correctly), so it can take more than 1 row.

Sys.sql_modules...

I'm not completely clear on what you're asking. But if what you're looking for is something that lists out the system tables in SQL 2000 or SQL 2005, they...

Now, can that be added into Matt's regex easily, to deal with removing all other non-numeric symbols, but leaving complex numbers intact?

Missing data but non-null parameter. I didn't think of that and should have. Clever solution, you guys.

Try adding an Else statement to each of your cases. See what's in that column.

Yes, they do have that advantage. It is easier.

But, since a missing delete will raise an error if you have your foriegn keys set up correctly, adequate testing should...

If you use DateName instead of DatePart, for the year part of your calculation, it will be a string already, and you won't need to convert it to varchar.

If you're happy with your current function, look up Apply in Books Online. It tells you how to "join" to a UDF with input parameters based on the columns...