How about this:

SELECT REPLACE(CustomerName,'*NA','')

That will remove all instances of '*NA' within CustomerName.

Would that work for you, or is there a chance that the string '*NA' will show up...

Hmm, I wonder if the confusion comes from the 'replacement' section:

I assume that indicates the state...

For one-off stuff I do for myself, I cheat and use sp_Send_DBMail to create a tab delimited file named like it is an Excel spreadsheet.

DECLARE @Delimiter Char(1)

SET @Delimiter...

I suppose you could change your procedure to have local variables, and then try to add logic that would guess which parameters get mapped to which local variables based on...

You can include Nulls for the two parameters not being used when you call it.

If that's not possible either, then I think you'll need to write another stored procedure as...

You can call the procedure like this:

exec [dbo].[GetPerson] @RecordNumber = '123', @ActiveOnly = 1, @ActiveDate = '10/10/2013'

If you are going to go to all the trouble of rewriting the logic to use a table, I'm not sure why you'd want to wrap it back up in...

It seems like your issue is that there is an additional 'test' condition, that overrides the other conditions?

You could forget the 'or' logic and include all iterations including the test...

You'll probably have to post actual sample tables/data/queries for anyone to help you with this, but try something like this:

SELECT *

FROM tables and joins

WHERE clauses, ...

AND Ssn IN

(

SELECT Ssn

FROM tables...

You could also set the database to single user mode (with immediate rollback).

This will kick everyone but you off of the database, and keep other people out until you set...

No problem, glad I could help. 🙂

The results returned over a linked server to Active Directory are limited to somewhere around 1000 if memory serves me. Anything more than that and you will get an...

If this is an error notification, you probably don't need anything particularly fancy for the html formatting.

I suggest ditching the temp table and the query in the sp_send_dbmail call, and...

Are you looking for a query that will list all of the scheduled jobs that contain an SSIS step?

SELECT

Job.Name AS Job_Name,

Step.Step_ID AS Step_Number,

Step.Step_Name,

Step.Command AS Step_Command

FROM

MSDB.dbo.SysJobs Job

JOIN

MSDB.dbo.SysJobSteps Step

ON...

Hmm, sorry I don't know then.

Can you confirm that the catch block is firing?