>>just add the genre to the genres variable

Are you looking for the Genres variable to contain a list of space separated Genre's? or ???

Why do you want to do the Order By in a View?  If you want a different order than what the view presents, you would end up with 2 ORDER...

GETDATE() won't work inside an SS2000 function because of silly rules about being non-deterministic and all... you need to make a view for a simple GETDATE() ...

 CREATE VIEW...

Newline could also be just CHAR(10) or CHAR(13).  Have you tried replacing each one at a time?

Yes... but this looks like homework... would you mind showing us what you've tried?

If you are the DBA/Senior Developer, they should have no problem with with the memory on your desktop... all of our developers have at least 1 gig and most have...

I believe NUMERIC(10,0) will allow for 9,999,999,999, not just 1,000,000...

Heh... gotta love Microsoft... we're at SP2a and they still didn't get it right... thanks for the feedback and thanks for reporting it to MS.

I got no errors when running what you posted.

What do you get for this?

SELECT TOP 75 PERCENT intValue

  FROM #tmp

ORDER BY intValue ASC

If you can pack it in, 3 gig would be nice... if you get to the swap file, it's too late.

Dang!!! Spot on Michael... great minds think alike.

I'm trying to mello out in my old age... wasn't going to ask about why anyone would want to do something so insane......

Actually, it's a long but fairly simple crosstab.  The big performance killers are whereever you have the unqualified correlation of...

a.order_id <> b.order_id

That's IF it were to ever be executed......

One other thing... Centrino's aren't real good for 2005 (or even 2000).  There are a couple of other processors that pretty much suck, as well, but I can't remember their...

Heh... now you know why I always wait for a couple of service packs to come out before making a switch...

I'm thinking...