That will do it... won't be fast but it won't cost you any data :

Use Master

GO

CREATE TABLE dbo.TABLE1

(

PkTest char(10) NULL

) ON [PRIMARY]

GO

Select name, XType, Status from dbo.SysObjects where...

well one way that almost looks like what you are wanting to do is to debug the SP. In QA select your stored proc in the object browser and...

I've never heard of a user creating a system table. How did he do that?

Also I don't think it's possible to do this (because you could also remove other...

This is a shot in the dark.. but have you tried this :

CHAR(13) + 'Comment 1' + ': ' + rtrim(so.comments_1) + CHAR(13) + 'Comment 2' + ': '...

Please try to avoid using dynamic sql. It's a bad coding habit and it exposes you to sql injection (hacker could take control of your whoole domain (not just...

Just using bummed in it's real context...

I don't think it can be done... But maybe you could check for the rows that don't fit in the table and delete those (or send them to another...

I got 2 ideas.

1 - you can make another field that keeps lets say the 8 last numbers of the card and do a search on those number.. however you...

Neat trick AJ. It works faster than my version and is much easier to understand.

One less thing to learn today

Yes we can all see that... hopefully you'll make it work in a set based operation someday.

Good luck.

This isn't bullduzer but I'm not sure it's the fastest approach, but that works so :

Select cast(dtName.Name as varchar(100)) as Name from

(Select distinct(cast(name as varbinary)) as Name from dbo.ObjSQL...

You can't do that

Where HorseID = @LstHrse

end

means

Where HorseID = 'what ever you typed here but in varchar format'.

This works for me.

Declare @Names as varchar(8000)

set @Names = 'SysObjects, SysIndexes'

--this is in your stored proc :

set @Names = ',' + Replace(@Names, ' ', '') + ','

Select Id, Name,...

What's the matter Frank... you seem a little bummed out???

Are the lines added at the top or the bottom of the code??

Also one thing to might solve the problem is to use GO and the beginning and the end...