Viewing 15 posts - 15,661 through 15,675 (of 18,923 total)
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.
July 6, 2005 at 8:47 am
You could just have copied the sql script that em generates ![]()
July 6, 2005 at 8:44 am
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 ...
July 6, 2005 at 8:11 am
Use results in text,
also go in tools/options/results/max number of characters per column = 2000 (instead of 255 default).
July 6, 2005 at 8:09 am
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?
July 6, 2005 at 7:42 am
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...
July 6, 2005 at 7:37 am
No you don't this is a dts question and it's gonna be posted in the dts section in tomorrow's newsletter.
July 6, 2005 at 7:21 am
Gonna wish you good luck, 300k and 500k are in no way small tables. I just hope that the indexing strategy is rock solid.
July 6, 2005 at 7:16 am
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
July 6, 2005 at 7:15 am
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...
July 6, 2005 at 7:12 am
How many users are we talking about?? I'd strongly consider msde msde/sql express for such a db (300k/500k).
July 6, 2005 at 7:03 am
Viewing 15 posts - 15,661 through 15,675 (of 18,923 total)