Viewing 15 posts - 751 through 765 (of 3,232 total)
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'
January 11, 2010 at 4:49 pm
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...
January 11, 2010 at 4:15 pm
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...
January 11, 2010 at 3:42 pm
Agreed. I've seen Blind Side twice. It's a great movie!
January 11, 2010 at 2:12 pm
MrsPost (1/11/2010)
The location would change based on the connection manager information at the job step.
Well, that's a given. How is the connection manager getting its information? Are you...
January 11, 2010 at 9:56 am
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'...
January 10, 2010 at 3:54 pm
Phil Parkin (1/8/2010)
Gkhadka (1/8/2010)
... and use JOHN command in ur update SQL code.Wow, did Mr Rowan get his own command? 😎
Whooo Hoooo!
January 10, 2010 at 3:51 pm
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. ...
January 8, 2010 at 5:01 pm
This is a duplicate thread already being answered here:
http://www.sqlservercentral.com/Forums/Topic844735-391-1.aspx
January 8, 2010 at 4:50 pm
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...
January 8, 2010 at 4:49 pm
This is a duplicate thread already being answered here:
http://www.sqlservercentral.com/Forums/Topic844735-391-1.aspx
January 8, 2010 at 4:29 pm
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...
January 8, 2010 at 4:28 pm
Ray K (1/8/2010)
John Rowan (1/8/2010)
Here it is using STUFF.
DECLARE @Var varchar(10)
SET @Var = 'XXXXXXXX'
SELECT STUFF(@Var, LEN(@Var) - 2, 0, '.')
Ah, yes. I defer to those who have more SQL...
January 8, 2010 at 4:07 pm
Here it is using STUFF.
DECLARE @Var varchar(10)
SET @Var = 'XXXXXXXX'
SELECT STUFF(@Var, LEN(@Var) - 2, 0, '.')
January 8, 2010 at 3:44 pm
Viewing 15 posts - 751 through 765 (of 3,232 total)