you need an end after the first case

CONVERT(CHAR(4), YEAR(EffectiveDate))+

CASE

WHEN LEN(MONTH(EffectiveDate)) = 1

THEN '0'+CONVERT(CHAR(1),MONTH(EffectiveDate))

ELSE CONVERT(CHAR(2),MONTH(EffectiveDate))

...

yep that would work, one thing I would try though is doing the count in the data set in one report and doing the runningtotal in another and see if...

SELECT

CONVERT(CHAR(4), YEAR(GetDate()))+

CASE WHEN LEN(MONTH(GetDate())) = 1

THEN '0'+CONVERT(CHAR(1),MONTH(GetDate()))

ELSE CONVERT(CHAR(2),MONTH(GetDate()))

END

the bottom part of the script which marcus provided does the memory utilisation checking

doh, sorry early morning, I thought you meant a SSC article.

I dont believe there is a way as the MSArticles table in the distribution database doesnt have a datetime or...

check the error log to see which database is being recovered and then run DBCC CHECKDB across all your databases to check for corruption

the error log should give a percentage...

Are you wanting the number of orders per day for a month and then passing that back into the report.

I would say you would want a type of count in...

i would format the parameter into an iso date standard

so when you pass it into the dataset use an expression like this

=CDate(Format(Parameters!StartDate.Value, "yyyy-MM-dd"))

One thing I learnt the hard way is...

yeah it can be a bit tricky SSRS in some places. luckily I had the joy of the 3 day SSRS admin course along with working along side a...

take a look in the write for us section

What edition of SQL is this on? Express? Std? Ent?

There is a tool called RSScriptor which will script out and restore them but you will need to modify the batch file it creates to restore to the right server.

Alternativly...

I've also seen this also happens when SQL starts before AD.

In an old job, the AD servers took ages to come up after testing a scheduled power outage, say they...

you might want to take a look at full text indexing and the contains function then, otherwise you will be wrapping the variable in a multiple of replace statements for...

you could wrap the variable in a replace function before passing it into the like clause