check the filter, there must be a convert hidden in the user defined type version while there won't be any in the other version.

A promess is a promess .

You could just have copied the sql script that em generates

Is this still the simplified version or the actual code?

/* Retrieve data for collection - SIMPLIFIED FOR THIS EXAMPLE */

INSERT INTO @EventOpsList(Event_ID, Course_ID)

SELECT A.Event_ID, A.Course_ID

FROM dbo.Event A ...

Use results in text,

also go in tools/options/results/max number of characters per column = 2000 (instead of 255 default).

Works on my pc. Have you tried dropping the proc and recreating it?.

What version of sql server do you have, what's the compatibility level?

I'm sure untill he corrects me .

I can't help you if you don't show me the whole thing. The only information I can give you is that it would probabely be faster to switch the...

Anyways his question has already been answered .

I can imagine the face .

No you don't this is a dts question and it's gonna be posted in the dts section in tomorrow's newsletter.

Gonna wish you good luck, 300k and 500k are in no way small tables. I just hope that the indexing strategy is rock solid.

Please do not triple-cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=197371

That code is correct, you'll have to post the actual code so that we can find the error.

Also why do you do select into #temp from @A

exec dbo.sp --that...

How many users are we talking about?? I'd strongly consider msde msde/sql express for such a db (300k/500k).