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

as a next step in the product lifecycle is our service in a box which comes with a set of reports specific to that client.

we have a current user base...

something like this

create table #temp (id int, number int, value int)

insert into #temp (id, number, value) values (1,1,0),(2,1,1),(3,1,0),(4,2,0),(5,2,0)

with cte1 as

(

select

number

from

#temp

where

value > 0

group by

number

)

select

#temp.*

from

#temp

join

cte1

on

#temp.number = cte1.number

Thanks Basit, I'm diving deeper into this when I get a moment aside from the other things I'm working on.

One thing I would like to know is say I have...

the only gripe i have with SSIS is when you change the destination to a different column length or type as the meta data references the old type until you...