That's not sad, it rather gives you total flexibility 😀

WayneS (11/22/2010)

Lutz - wouldn't the temp tables that I used handle that? Otherwise, you end up with 4 procs to...

I was about leaving a party-note since Steve's out until the 29th (got a out-of-office reply for a reported thread).

But given the latest news I don't think it's appropriate...

I wish...

Looks like a catch-all query issue.

See Gails blog[/url] for details.

I'd use a TallyTable based method:

DECLARE @day DATETIME, @interval INT

SET @interval = 15

SET @day = '2010-11-22'

;

WITH splitTimes AS

(

SELECT DATEADD(MINUTE, @interval * (N-1), @day) splitTime

FROM Tally

WHERE N<=(24*60/@interval)

)

SELECT

agent.Agent,

cast(sp.splitTime...

hmm.. let me quote from my previous post:

Is this your actual table design? :pinch:

You should really consider to normalize your table structure.

You'd need separate tables for Persons, Buildings and BuildingsOccupied.

Based on that, the query becomes rather simple.

Regarding...

How about adding a comma after the [TYPE] column?

Sounds like FOR XML PATH is the way to go:

SELECT

DATE,

STUFF((SELECT '|' + Symbol FROM #test t2 WHERE t2.date = t1.date AND UpDown = 1 ORDER BY symbol FOR XML PATH('')),1,1,'')

FROM...

Do have a TRY ... CATCH block inside your sproc [myprocedure], that would print any error message?

Please post the code and your expected result/output.

And please explain what you mean by "each and every error".

bitbucket-25253 (11/20/2010)

All this gibbering and jabbering about age -- Your are all youngsters.

I've got a GREAT GRAND DAUGHTER born on April 2nd, 2010. As Jeff Moden once said...

Sounds like homework to me...

Please remember: we don't know your table structure nor your business case. All we know is what you posted.

And based on that, I don't think we can really help you.

You...

duplicate post.

Please reply here