This code works fine for me:

IF OBJECT_ID('dbo.IndexRename') IS NOT NULL

DROP TABLE dbo.IndexRename

GO

CREATE TABLE dbo.IndexRename (

ID int NOT NULL

)

CREATE INDEX IDX_IndexRename_ID ON dbo.IndexRename(ID)

GO

sp_rename 'dbo.IndexRename.IDX_IndexRename_ID', 'IDX_IndexRename_ID_Renamed', 'INDEX'

This does not sound like a case of a special character. It sounds like the package is hung up on a step.

Can you describe the control flow...

You need to use the alias name that you've given dbo.Staff in the UNIONed queries. You've aliased all but the first query as Staff_3, Staff_2, etc. You're SELECT...

Agreed. I've seen Blind Side twice. It's a great movie!

Well, that's a given. How is the connection manager getting its information? Are you...

Purpose.

You know, that does give me an idea. I think I may have to create a user defined funtion in our DB and let some of our 'less informed'...

Whooo Hoooo!

It looks to me like you need a split function that works with a tally table. You shouldn't have to re-code your function every time the data chages. ...

This is a duplicate thread already being answered here:

http://www.sqlservercentral.com/Forums/Topic844735-391-1.aspx

Outside of what Todd is suggesting, I know of only one other way to do this. It's a bit out of the box, but I've built an entire automation...

This is a duplicate thread already being answered here:

http://www.sqlservercentral.com/Forums/Topic844735-391-1.aspx

This is a duplicate thread already being answered here:

http://www.sqlservercentral.com/Forums/Topic844735-391-1.aspx

Please don't double, or triple in this case, post. I know you want to get your question answered, but posting multiple...

Ray K (1/8/2010)

Ah, yes. I defer to those who have more SQL...

Here it is using STUFF.

DECLARE @Var varchar(10)

SET @Var = 'XXXXXXXX'

SELECT STUFF(@Var, LEN(@Var) - 2, 0, '.')