What do you get from my query?

My version is meant to be used as a UDF. It's much easier to use and versatile that way.

Select Dept, count(*) as UserPerDepartement, sum(case when Col = 'XP' THEN 1 ELSE 0 END) from dbo.YourTable group by Dept

Sorry I thaught that the split function was mentioned in that article...

Read this instead :

Arrays and Lists in SQL Server

won't work either... he's not using dynamic sql :

from today's newsletter :

http://www.sqlservercentral.com/columnists/aGrinberg/thearrayinsqlserver2000.asp

Basically, a Bookmark lookup is when sql server scans an index to satisfy a where condition, once the index is scanned, it starts retreving the data from the table using...

where Status = 0x80 and id = object_id('TableName')

First I would backup msdb as all the packages are saved there.

2nd you could use sqldmo to save all you dts to file just in case you can't transfer msdb...

Search the script section on this site for table size and you'll get a few exemples.

This is what he means :

Select O.Name as TableName, max(I.rowcnt) as Total from dbo.sysindexes I inner join dbo.SysObjects O on i.id = O.id and O.Status >=0 and O.XType =...

run this in query analyser :

SELECT DISTINCT Op.name AS ParentObject, Oc.name AS ChildObject

FROM dbo.sysdepends D INNER JOIN

...

Can you use the post method so that the parameters get hidden in the url?

set nocount on

create table #temp

(product_id int not null,

prod_desc char(1) null)

insert into #temp

select 1, 'A'

insert into #temp

select 1, 'B'

insert into #temp

select 1, 'C'

insert into #temp

select 2, 'D'

insert into #temp

select 2,...

SELECT @Output = @Output + CASE @Output

WHEN '' THEN prod_desc

ELSE @Output + ', ' + prod_desc

END

FROM #temp

WHERE Product_id = 1

ORDER BY...

That's the one thing that makes me like EM... you can read up the code it generates and learn new stuff.