While these are valid arguments about nit-picking of questions, one vital piece of information was overlooked. This question was only worth 1 point.

Bitbucket, your question was worth more points....

GSquared (11/19/2009)

Paul White (11/19/2009)

You're probably right - it's just...

Says he who is in two minds :hehe:.

I am only Committed right now, not quite to the Crazy level:-D

Tiz the season...

heffalumps

Ok - it's not prose or rhyme but it is set to Jingle bells

/*

Pouring through the code

of a cursor based stored proc

Making it set-based

Eating a Pork Chop

Set-based procs we write

Making...

I don't get the same problem. When that date pops up, it could be due to an invalid date that has been input.

declare @issuedate varchar(8)

Set @issuedate = '20091118'

select Convert(DateTime,...

That was going to be my next post after he responded with what had been tried already.

Quetzco, as Elliott outlined - it can be done through the use of either...

Are these buckets strictly posts or are the QOD points included?

Colander? - Check

Still unable to understand the brash quips about us Lynn and Bru being rude.

Might have to switch the colander to psychic mode.

Is that Karma Chameleon?

In the meantime, maybe...

Right there with Bru on this one.

I think I have a grasp of what you want but could be jumping at conclusions that may be wrong without more information.

However, based...

What have you tried so far?

SSC is not a Braindump site. Posting any exam questions in braindump format to this site is ill-advised.

And to reiterate the point...

Applying Service Packs and patches can cause undesirable effects. Thus it is necessary to test the patches in non-production environments before rolling them to production....

Hmmm. Verified on my default installation that the ServiceName is indeed MSOLAP, and that concurs with the documentation.

ForumDog and his curses are long gone. Took flight with the rest of the pack - they are somewhere in Minnesota now.