I'm assuming that my answer will work because the commas will actually make 4 records instead of 1... hence that might very well be the cause of the too many...

BTW this is only the tip of the iceberg. Once you understand how powerful and dangerous sql injection can be, you go out of your way to avoid it...

Sorry carpal tunnel... I'll try to find an harder solution next time .

BTW Antares had already pointed in the direction of the ms proc......

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'.