Why not just use

Case WHen Address2 like '%PO Box%' Then '' Else Address2

?

This is set based and will perform much better than a UDF which will have to be...

It Depends on the servers, the network, and activity. I'd be more inclined to use bcp/bulk insert or SSIS to do something like this.

Lowell,

That script is 2005/2008 specific and this is a 2000 forum. You'd have to modify the script to use Scott's solution to get the path.

I would say that it is normalized, although I would have FirstName and LastName columns instead of just a StudentName.

I would also echo SteveB's response about the identity columns. ...

The last query returns the results you want, I think. I added some more data to the sample and you should notice that your second solution that provides your...

Duplicate post. Please post answers here

They can use Express this way as long as they can live with the limitations (1 CPU, 1GB RAM, 4GB database size).

There are a couple of articles here on SSC about this, one of which I wrote. They both also show you how to log the error to a table....

I'll echo what Lowell said. The Like is not the problem it is the Functions that cause the problem. If you have no white space then get rid...

This is just a guess, but I would think the fact that the updates are running in a cursor may be causing some locking/blocking issues, possibly in tempdb. Are...

You can just go to the location you have the report RDL files saved and copy report_1.rdl and paste it back into the location then rename it report_15.rdl. Then...

GSquared (7/29/2009)

---

Jack Corbett (7/28/2009)

---

Dave, nothing scheduled until September now. If I'd have known a couple weeks ago we could have maybe gotten something done in August. Our group...

I recommend reading this article[/url].

I still think that there is some misunderstanding about Steve's intent in the editorial. I think his premise is that many times we, as developers, are continually thinking about...

I'm pretty sure dbase has a CAST function so you could CAST you date columns to string.