I personally use a custom built ssms addin that flags up databases with changes that have not been committed to source control and can perform that commit.

I just need...

OLSONEJ (6/29/2015)

---

I have a data set (snippet below) and I need to count the number of consecutive years based on a date in time for each ID as represented below.

ID...

Well how about you post what you have tried and some test data (see the link in my signature), then we can help you?

another possibility is to join to a set of 8 rows, using a row number

create table #tblBOL(PONumber int);

insert #tblBOL(PONumber) values(100001),(100002),(100004),(100006);

select coalesce(tBrn.PONumber,0) as PONumber

from (values(1),(2),(3),(4),(5),(6),(7),(8)) Tally(N)

left outer join

(

...

Isn't that usually disabled when there is already some component installed in the shared directory?

Have you checked whether the specified folder already exists and has something in it? If it...

Yes, to be pedantic, but...

All these UNION queries will be scanning the table twice, yes?

Assuming you have a table GivenNames with a column Name.

select distinct CA.Name

from GivenNames GN

cross apply (

select left(GN.Name,1) as Name

union all

select GN.Name

) CA

order by CA.Name

You can't. The standard report template in report manager provides no control over layout of parameters.

No problem, glad you solved it.

Have you checked permissions on the folder that contains your data source?

karen.blake (6/17/2015)

---

Thanks both, the data source has its own id so that's fine.

It should be inheriting this from the parent folder but it's not. It's very odd as normally you...

Check whether the report is inheriting permissions from the parent, quite often people change individual permissions, which stops inheritance.

Just put the prefix np: in front of the server name.

Put the optional parts inside the isnull...

For example

ISNULL(N'( ' + column1 + N' )',N'')

Which will produce a value with parentheses or nothing if the value is null.

If you want to...