nvm ended up using multiple columns... somehow my boss thought that parsing 16,21,12|.1,.11,.11^53,54,55,56,57|.68 was harder than using 4 extra columns *shrug*

(still cant delete messages)

I like your quote 🙂

thanks, worked! Need to add that snippet to my collection of very useful snippets.

the 2nd column can have any number of items in it, including just 1.

I hate when the seemingly simple tasks turn into muck.

*smacks head*

thanks 🙂

The end result is going to be populated directly into an PDF. The user just wants to see the data, not have to manipulate it. It's part of...

GilaMonster (12/5/2007)

---

I'll second the dislike of the top and order by. Ordering should only be done in the final select statement that reads from the view, not in the definition...

Ill try the recompile when I get in the office (stuck in traffic on blackberry atm). That would explain why the execution plan looks seriously different on the 2nd...

I removed the order by... that was a throwback to bad SQL2000 habits

I can't really post the other two views...

the script snipet returned 46k rows. It completed...

You're right of course, I ran out of time before I could do a proper post (should of just deleted it)

SELECT TOP (2147483647)

Portfolio= PortfolioCode

,[NAME]= TraderName

,[SECT]= CompType1

,CUSIP= SecurityIdentifier

,[TRD_DATE]= SystemTradeDate

,AMT= Quantity

,LONG_DESC=...

well I can't delete this so I might as well post my solution.

I had to cast some of the columns to varchar, not sure why it was coming back with...

Thanks for the replies!

I could only get part of it, dont know where to find the actual index names

SELECT DISTINCT

= OBJECT_NAME(OBJECT_ID), 'CLUSTERED'

FROM SYS.INDEXES

WHERE [TYPE]=1 and OBJECTPROPERTY(OBJECT_ID,'IsUserTable') = 1

UNION

SELECT...

WITH CATEGORY(TYPE_1, RATING, BVALUE) AS

(

SELECT TYPE_1

,CASE RATING

WHEN 'AAA' THEN 'AAA'

WHEN 'AA' THEN 'AA'

WHEN 'AA+' THEN 'AA'

WHEN 'AA-' THEN 'AA'

WHEN 'A' THEN 'A'

WHEN 'A+' THEN 'A'

WHEN 'A+ /*-' THEN 'A'

WHEN 'A-'...

cool, thanks 🙂

I just started a new job after being at my last one for 12 year.  I went from a small company that was barely scraping by with a staff of...