Has the snapshot agent for the publication run yet ? Until it does, you won't get anything coming through to your subscriber. In replication monitor, you will see...

With SQL 2005, you are out of luck. You are really only able to show text or images.

The error is because you have included aliases for the field in the GROUP BY clause. Try the following instead

SELECT a.WS_Job_Number,

a.Year1,

a.PERIODID,

CASE

WHEN a.PeriodID = 1 THEN 'July'

WHEN a.PeriodID = 2...

I suspect that the report is not associated with a data source (any more). Perhaps the report RDL was updated but the data source reference was not correct.

Try going...

I suspect that the report is not associated with a data source (any more). Perhaps the report RDL was updated but the data source reference was not correct.

Try going...

IF EXISTS is potentially quicker because once any record has been found SQL Server has finished what is needed.

Using COUNT(1) requires SQL Server to return all records that meet the...

You could use

SSIS with the FOR EACH container

or possibly something like xp_cmdshell 'DIR c:'.

or maybe the FileSystemObject

or perhaps a small .net application

The can all give you a list...

You could use

SSIS with the FOR EACH container

or possibly something like xp_cmdshell 'DIR c:'.

or maybe the FileSystemObject

or perhaps a small .net application

The can all give you a list...

You could use

SSIS with the FOR EACH container

or possibly something like xp_cmdshell 'DIR c:'.

or maybe the FileSystemObject

or perhaps a small .net application

The can all give you a list...

You can definitely read data from an OLAP database using DTS. All you need to do is create a connection using an OLAP OLE/DB provider and in your datapump...

If a file that is being updated by the service pack is in use, a restart will be required. Hence, stop the service and it is unlikely that files...

Thankfully, the optimizer is pretty good at sorting out exactly what you mean regardless of how you structure your query. However, I would be wary of using the syntax...

I kinda suspect that you have not add a scription for the 4th table. The record count you saw is probably the bulk copy of the data from the...

Again, Gift Peddie needs to understand the technology before answering.

Reporting Services is not aware of the location of the files used for any database including ReportServer and ReportServerTEMPDB. All...

You know, the first thing that I thought when I started reading this post was that it is probably because you do not have the relevant bits of Excel installed...