When I've run into this situation, I've split the string and then used a case statement:

DECLARE @NAME varchar(50)

DECLARE @FNAMESTUB varchar(50)

SET @NAME = 'MOUSE, MICKEY X'

SET @FNAMESTUB = LTRIM(SUBSTRING (@NAME,CHARINDEX(',',@name)+1,LEN(@NAME) -...

This is not a particularly elegant solution, but it should work.

Define the variable to hold the row count at the control flow level.

Add an extra data...

All of my SQL Server 2008 work has been in Enterprise Edition, so I've not not needed to investigate it, but there is a bolt-on product for enabling CDC in...

I've found there to be no shortage of demand for SQL Server work in my location. I politely fend off several recruitment attempts per month, either via LinkedIn or...

I think that one should also not be afraid to question why things are the way they are in a given work environment. I was at my prior position...

I've found a solution for this issue today, so I thought I would pass it along. Cumulative update package 3 for SQL Server 2008 Service Pack 1 addresses SQL...

JN, did you ever find a satisfactory solution to this issue? I'm facing the same problem. The process of simple parametrization by the query optimizer is confounding my...

I needed similar functionality, to remove files older than 14 days old. I wound up using the following, based on the DOS ForFiles command:

Forfiles -p E:\backups\test /m *.bak -d...

>> The multi-part identifier "functionParent.functionid" could not be bound.

How is the 'DelayValidation' property on the component that is causing this error set? I've seen situations where late binding of...

In our shop, developers have sysadmin on development, but only myself, the migration manager, and the ETL specialist have it on test and prod. Whenever I receive an authorized...

In my case, that project was put on the back burner. Rather than forging ahead in SSIS though, I downloaded a C# port (NHAPI) of an open source Java...

I count myself to be truely fortunate. After doing contract programming and database work in the public health field, I found that knowing that my work was doing something...

When I went looking for tips on X12 processing last year, I wasn't able to find any resources out there. In my case, I was able to get the...

blandry (4/20/2010)

At Troy, a great battle was fought with great heroics and yet not one single person bothered to ask, "Why are they giving us this giant horse?" as they...

My actual title is Senior Analyst/Programmer. I design and build SQL Server 2005 and 2008 databases, tune them, monitor them, back them up, and write all ETL processes in...