Oops I didn't realize I was in the SQL 2000 forum. I came her via Active Threads and thought it was the T-SQL 2005 forum.

I don't have access to a...

Glad I could help. If you want to improve it, replace the query on the system view by a persistent table. That may speed up things a little.

Peter

Edit: didn't saw...

Like this?

select

dateadd(dd, c.n - 1, t.StartDate) Date, t.EventID

from

#test t

cross apply

(

select top(t.Duration)

row_number() over (order by name) n

...

Thanks Bob. I just expected the pivot solution to require far less coding in the case of 30 column pairs. But even that doesn't seem to be the case, now...

A nice and surprising solution by Bob (it took me some time to see where c1 in left(c1, 7) was coming from). All I could come up with was:

select

...

I used the Profiler while refreshing the System Databases branch in the Object Explore of SSMS and the following (partial) statement came along:

SELECT

dtb.name AS [Database_Name]

/* More...

Try

SELECT

ID, Seq

FROM

Sequence

WHERE

Seq = REPLICATE('1', LEN(Seq))

Peter

You don't have to envy me. Based on the figures you posted, obviously this machine is making me producing very slow code, although I have not figured out yet what...

Would someone please doublecheck my results? For comparison, Peter's original code is shown in a slightly modified version below. It now takes the sequence string as...

You can set the hidden property of the Phone TableColum (select the entire column, not just the header or detail cell) to an expression:

=IIf(CountDistinct(Fields!Phone.Value) = 0, True, False)

Peter

Thanks Bob.

BTW, I figured out wat was wrong with using a CTE to generate the Tally table. It was the final SELECT ... FOR XML PATH('') which ruined the order.

Here's...

Indeed a challenging question, so I gave it a shot too. I'm also curious about the purpose of the output, because it seams at least as complicated to process in...

I don't think that just casting the UserID to varchar will work, because in this way UserID '2' will become before UserID '11', when sorted desc. You have to properly...

Use "Add Existing Item" instead of "Add Existing Package". It will not make a copy of the package.

Peter

If temp1 contains duplicates, you will get the error. Try using distinct

insert into emails(email) select distinct t.email from temp1 t

left outer join emails e on e.email = t.email...