k... just making sure that the design wasn't flawed.

Select Min(dtMM.marks) as MinM, Max(dtMM.marks) as MaxM from

(

SELECT college_id,department_id,student_id,SUM(marks) as SUM

FROM student a INNER JOIN college

ON a.college_id=b.college_id

GROUP BY college_id,department_id

) dtMM

Select DISTINCT o.Name, O.XType from dbo.SysObjects O inner join dbo.SysComments C on O.id = C.id where text like '%UCN%'

Why would the id wouldn't be unique???

anyways :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items = @Items + C.Name...

Good news that I know how to use aggregates and how to create simple table .

Another oops on your list .

You don't, you make it fire from the trigger :

Create a custom alert, set up a job to start when that alert is triggered.

Put the code in that job.

Raise...

Here's a simple idea. For now make 2 version of the report (with/without header), then display/export as required. Then if you ever find a solution for the header,...

Why not just put that in a shared database that all apps can use, or simply in all needed databases... you wouldn't need that much permission to access it.

If there's nothing else updating that table I guess it's ok. But I wouldn't that operation there. I would raise an alert that would start a job that...

Welcome to the club .

I know.

I thaught for a moment that you were talking about my query then I got the reference to the older post...

I think you're gonna have to use the trick with a perm table that holds that view... then hope you can optmize it enough to go subsecond with it (harder...

Comming from Quebec... I sure do .

Just to explain... I thaught that removing all the concatenation part of the work might make this go somewhat faster but the cost of generating the unequal join+group by to...