Try this...simply referencing a column from the target table in the APPLY, using OUTER instead of CROSS and updating the referenced column as well forces the randomisation to work on...

You are most welcome - glad it is of use.

You have more problems than I spotted at first.

ActualDuration doesn't exist anywhere in the source sub query "temp", so you can't SELECT it.

You can't have aggregate functions or aliases in...

You can't have aliases in a GROUP BY clause.

My guess is you copied the group by from the SELECT...

I have to agree with Lowell, that if the column datatype is a date, then the insert will succeed and be correct and should not cause you...

...and on my SQL 2014 test machine, these are all identical:

WITH Strings AS

(

SELECT ID, AString

FROM dbo.StringsTest

WHERE AString IS...

Nice write up Dwain.

As with anything like this, whether this technique benefits you or not will depend on so many factors.

On my laptop, for instance, I see no difference between...

If you have to do it, then I would also recommend Michael's code, but with an additional range check suitable to your needs, just to prevent valid but unreasonable dates.

e.g.

ALTER...

You need a parent report, you cannot do it just with report 1 and report 2.

The sample I gave works just like that - did you try it?

You have set yourself some unreasonable conditions.

The parent report will do what you want, displaying one and only one report at a time.

Is there a good reason why you...

PSB (3/31/2014)

AS mentioned before, the requirement is to show reports (two reports)one after the other like a slide show as two different reports (not in the main report).

Report A...

Those expressions decide whether to show Report 1 or Report 2 by checking the current...

I would say from experience of how these things can go wrong that I would actually go for a mix of the two...

Have a Cancelled column (Y/N) (and potentially...

=Iif(Fields!loan_count.Value=0 OR Fields!loan_count.Value>=1,"NO","P1")

As it is a one off, I will recommend this, which is dirty but works and is simple:

select 'hello world'; -- just here to "prime" @@rowcount

while @@rowcount>0

update mf

set formula =...