Theories (on search on this site will get you the info you need in case it's urgent) :

Parameter sniffing (if slow only in the proc for the exact same...

Never getting tired.

dtDemo is the name of the derived table (dt). I think you can use Select top 100 percent in this case to make it work... or order...

NP... I'll check it out on Monday when I have access to a server.

Thanx. But my question was reffering to what versions to buy when they come out.

insert statement for me to insert data in the table I'll be creating with your script(s).

Well you could do that client side, but if yo must know ::

Select *, 1.0 * Lcount/Total as PCount, 1.0 * Scount / Total as SCount from (

select facility,

Lcount =...

There's no insert statements for the test data.

Search in the articles for change management... time to implement it .

Can you (re)post :

- Table DDL

- Insert script (statements) for sample data

- Current select query

- Needed output

If you don't know how to do all that :

Ask them... unless they dropped it instead of altering it, there's no information available in the system tables.

I thaught I had to be a member of msdn or something like that!!.

Any suggestion of what versions to buy when they come out?

I need a server version (15 users)...

Forgot you didn't know that one .

EXEC sp_MSForeachDB 'if ''?'' in (''master'',''model'',''msdb'',''pubs'') begin Select O.Name as ObjectName, C.name as ColName from ?.dbo.SysObjects O...

Might I suggest you try the solution on a test server first???

Or at the very least on another db on the same server??

I meant a real pic... but thanx for the link .

Still no clue... I'll have to wait for the final reveal.