I agree with Clare - perhaps initialising the second subscription removed all trace of the first.

As for the Identity and BranchID - that is fine PROVIDED that you declare the...

A couple thoughts...perhaps the empty space string contains more (or less than one space) and also what happens when the souce column is null ?

Perhaps try....

civilianYears == "--" || TRIM(civilianYears)...

I assume that each site is responsible for the creation of the records in table1 and that all of the records in question (at both remote sites) are intended to...

Have a look at the topic "Using Tokens in Job Steps" in Books Online. SQL Server Agent has a number of tokens that can be used that give you...

I think that the chart is showing every other month because the default settings for the axis labels "Interval" property is "auto". Change this to 1 and you will...

I think that the following will give you what you are after

WITH MEMBER Measures.CurrentMonth AS 'SUM ( [Date].[Calendar].Currentmember.lag(11) : [Date].[Calendar].Currentmember, [Measures].[Internet Sales Amount])'

MEMBER Measures.PriorMonth AS 'SUM ( [Date].[Calendar].Currentmember.lag(12) :...

sqlrumble (8/8/2012)

---

Hello,

I need to setup SQL Replication (transactional) on a database thats over 200 GB. Replication is going to be setup over the WAN and so it would take...

You need to use either SET or SELECT to assign a value to a variable

e.g. SET @status = 1

or SET @status = @status + 1

What have you used for the category group expression

You will need something like

=iif(Parameters!DateSortOrder=DateInterval.Year, Datepart(DateInterval.Year, Fields!somedate), iif (Parameters!DateSortOrder=DateInterval.Month, Datepart(DateInterval.Month, Fields!somedate) etc

Or (a shorter form of the above

=Datepart (Parameters!DateSortOrder,...

Sounds like your category group value will be the the result of a calculation.

e.g. IIF (Parameters!Criteria.Value="Daily", Fields!DailyField.Value, (IIF (Parameters!Criteria.Value="Weekly", Fields!WeeklyField.Value, Fields!MonthlyField.Value))

As an alternative, you could include similar logic in...

To me, it looks like there are 2 issues that are effectively meaning the "LEFT OUTER JOIN" is really and "INNER JOIN".

1. The syntax used for the joins to dbo.FilteredTpl_accountexec,...

All you need is a simple select on table syscolumns such as

SELECT object_name(ID), * FROM syscolumns

Check out sp_tables_ex and sp_columns_ex - I think they will do what you are after

Howdy

I was experiencing this problem as well - from dev workstation to Server (both different versions of SQL 2008 r2). Whilst the ideal development environment is to have everything...

opc.three (6/15/2012)

---

akin.akinwumi (6/15/2012)

---

opc.three (6/15/2012)

---

In my opinion that is actually...