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...

nope >> UPDATE CASH_CHECK A is forbiden.. the alias must be set in the from clause.

It's like trying to tell whether it's better to be jewish or christian. Just go with what you believe is the best and experience will show you the rest...

Here's another one just for the fun of it :

Select SUBSTRING(@IDS, dtPositions.StartPos, dtPositions.Length) as IDS from

(

Select dtCommas.Commas + 1 as StartPos, MIN(dtCommas2.Commas) - (dtCommas.Commas + 1) as Length from...