I suspect that the OP has more than one "key" name! 😉

Hi,

I haven't used PIVOT because this can be solved with a CASE statement.

DECLARE @table TABLE

(

[Key] VARCHAR(50),

Value VARCHAR(50)

)

INSERT INTO @table

SELECT 'firstname', 'surya'

UNION ALL SELECT 'firstname', 'rakhi'

UNION ALL SELECT 'firstname', 'venkat'

UNION ALL...

Check here:

http://msdn.microsoft.com/en-us/library/ms143432(v=sql.105).aspx

That's exactly what I wanted. Nice one.

Hi,

I do this in my index rebuild job by having a variable that stores the start time of the job. Then a while loop that runs through my indexes, but...

To my knowledge you won't be able to do that using SSRS. You may be able to do it with a macro or some VB script though.

Great thanks for your help. That was the option i was leaning towards.

What does SELECT COUNT(*) FROM [msdb].dbo.[sysjobhistory] s return?

Hi,

If you have lots of jobs that run on that server you may need to update the history retention. If you right-click the sql agent and then go to History...

It's not huge, just inconvenient. I found out about the limitation of totalling and sets in Excel the other week. Frustrating to say the least.

Oh well, thanks for all your...

Hi,

I'm sort of with you. It might help if I give a bit more context to what i'm doing....

I'm creating a cube to duplicate a pro clarity solution. Essentially i'm...

Hi,

Thanks for your reply.

So, in SSDT (Bids for 2012) on my calculations tab I don't want a named set to achieve what i'm after?

Sorry if my question seems dim, but...

Hi,

I've handled Nulls in SSRS reports coming out of SSAS with this sort of expression.

=Iif(IsNothing(Fields!ANYFIELD.Value),"The Field Is Null",Fields!ANYFIELD.Value)

Found here:

http://www.mredkj.com/vbnet/RSNullCheck.html

Hope that helps.

Simon

That's great thanks!

Absolutely spot on. Nice one Sean.

Thanks,

Simon