Can't help you there without debugging... specially since my .net courses are over 18 months old . Seems okay but I don't see...

If you say so.. will be waiting for that sample data script .

Thanx for the warning... first time anyone mentions this here (AFAIK).

I'll let you work on that... will become more usefull than you think in the future.

You can't... I just post this so that we don't have the same conversation twice with a different group of users .

Can you show me how you are concatenating the script back together?

HTH.

This is not a bug. The text column of syscomments is nVarChar (4000). If the text spills over, then a new row is inserted and identified with an...

Read this (WHOLE THING PLS).

Help us help you

Please provide the final solution required... you reall don't need to use excel for this.

What was it??? I'm figuring wrong indexation or an unexpected convert but I'd like to know for sure .

DECLARE @demo table (NO int not null, dt datetime null)

Insert into @demo (NO, dt) values (100, '2005/01/01')

Insert into @demo (NO, dt) values (100, '2005/01/02')

Insert into @demo (NO, dt) values (100,...

I don't have enough design experience to answer this one. I guess some things can be hard to do, but I don't see them being impossible.

Yes you need the group by in here, also notice the count(*) instead (faster).

SELECT PROGRAM, COUNT(*) AS #Call

FROM pdb_records

GROUP BY PROGRAM

ORDER BY PROGRAM

We need more information to solve the rest...

Can we have the specifics (table and views ddl (with indexes and keys, execution plans of each calls to the view and the queries themselves.)

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

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