Did anyone else notice what he called "CURSE"

:w00t:

ooops closed browser before sending , strange saw your nickname on another website on custom code , funny that lol

thanks for that, I was about to dismiss that idea but...

Maybe I got too stuck on my train of thought and just wanted to focus on this one idea.

What i could also do is add the column names manually, into...

that isn't really what I need , as i said I could use another sp to tell me the number of Columns,

But what I need is for the Number of...

Nice Script!!!

was thinking about writing something similar a few days ago, then I saw this (no reason just yet) . although I'll work on something from within Excel where...

I think I understand your issue but without being able to see the code behind your Dataset and Also how you have laid out your data in your RDL this...

Our DBAs seem to have got there before you guys,

we tried looking at all sorts of things to find out what might have caused / remedy this.

and we are not...

There is infact a real answer and that was becuase it would slow the ball down as it travelled through the air during play making the game longer.

But the idea...

The Strangest question I've ever asked someone at an interview was "Why is there fuzz on a tennis ball?". (this was for a report writer position for a financial

Anyone got...

Thanks Jeff Sorry i didnt Reply was doing some testing on soemthing else the daty before tand then had a crazy day off!

Works beautifully althought Ive never used select distinct...

CREATE TABLE #DIARY (

MYUSER nvarchar(50),

STARTDATE Datetime,

ACTIVITY nvarchar(255)

)

INSERT INTO #DIARY VALUES('RBOTT','11 Jan 2006 10:00','Meet Mum')

INSERT  INTO #DIARY VALUES('RBOTT','11 Jan 2006 14:00','Meet Nan')

INSERT INTO #DIARY VALUES('MCOLL','13 Jan 2006 10:00','Change Washer')

INSERT  INTO #DIARY...

Yes bledu Very similar to

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=379131

Essentially What Ive done is actually try and simplify things in my question:

what im trying to do is concatenate rows together where the date is the same.

and then the appointments...

It would be intresting to find out whether conditional formatting works in 2007 as it hasnt in previous versions of Excel when exporting reports from reporting services

if you right click on the row, of the categories can you not just use subtotal or have I missed something here?

Tris