Yep, caught out by the 0 too.

Oh well, at least I'm good company!

You could always write some standard select statements for regularly-accessed data, to 'prime' the cache after deployment.

Even execute some of those procs if they don't do any DML.

So parameter abc is a multi-valued parameter? Try these, which test the first selected value of abc:

=iif(Parameters!abc.Value(0) =1,False, True)

=iif(Parameters!abc.Value(0) =2, False, True)

I don't know if there's any guarantee on the...

Cool, good stuff.

Ha, they look fairly similar!

Your linked method does have the advantage of taking care of other localisation issues like date and number formats; which mine doesn't.

Ok, how about this:

Table containing location ID's (en-GB, es, es-MX etc) as PK, columns Header1, Header2.. HeaderN.., Label1 etc (obviously with better names - more on design in a bit)

and...

Hi Anthony,

Will this be for a set limited number of languages, or does it need to handle pretty much any language?

Cheers

Hi, remove the quotes from your expressions, so:

=iif(Parameters!abc.Value =1,False, True)

=iif(Parameters!abc.Value =2, False, True)

Does that work?

Thanks

To a point, yes. But I'd be impressed if you were hitting the dev server hard...

In fairness to them, it is Monday morning... 😀

$10,000? Crikey! I'll do it for $4k 😀

Indianrock (8/17/2012)

---

I did read that the Netapp approach makes getting copies ( "backups" "clones" whatever you want to call it ) of the...

Guessed & got it right - although I only answered so I could see the actual answer!

Like the question for making me think about it, the right/wrong was irrelevant...

No problem 🙂

Just that, as...

This bit: ON CONVERT(VARCHAR(10), DateList.CreateDateTime, 112) = Temp.ShipWeek

ShipWeek generated from DATEADD(WEEK, DATEDIFF(WEEK, '19000101',CreatedDateTime),'19000101') will always generate the same dates.

DATEADD(WEEK, 0, CONVERT(DATETIME, @CurrentDate)) from your CTE will generate dates 7 days...