If REPLICATE ('x', LEN(<columnname>)) is returning 'x' repeated to the field's maximum length, I'd check your data doesn't have trailing or leading spaces, and the data type is actually...

You'll need to either group by all of the items you don't want summed (added together) or run a separate subquery to get the summed values as required, which would...

I would set the row filter property on your table (or the row hidden property) to the expression

=TimeSpan.Parse("23:59:59.990") = CDate(Fields!item.Value).TimeOfDay

That is easy to read, and shouldn't be too bad...

Unless there's reason behind the code you've used, for readability I would change

=IIF(First(Fields!FirmID.Value, "dsDataset1") = 1, "Logo1", "Logo2") .

to

Parameters!FirmID.Value

To answer your question, I suggest adding another parameter for selecting...

That error message doesn't give enough information about the issue. It does suggest you're using Microsoft SQL Server 2012. Try running SQL Profiler on the server, re-attempt the backup, get...

GonnaCatchIT (8/9/2015)

This is the code

System.Diagnostics.Process objProcess = new System.Diagnostics.Process();

objProcess.StartInfo.FileName = "abc.rdl";

...

You haven't posted enough information about how you connect to the report server. Are you using URL parameters, the Reporting Services Web Service, or some feature in the Report Viewer...

I don't think you need that COALESCE call. NULL > 0 is not true, so [ID] > 0 should be equivalent. My memory is a little rusty on this, so...

The wiki your link points to can be viewed here, and the file itself is downloadable here (Source)[/url].

For some companies, for example those dealing in health, I'd need to know how old a client is on a certain date, to identify that I would need to store...

Brilliant - thanks for the replies. I've investigated using Azure Data Factory and Data Sync, but decided to implement a SSIS solution due to the service costs of Azure Data...

That basically means it can't see the SQL Server. Can you ping the server?

Is the SQL Server service running on the WIN-4K server? To check this, log in to the...

Thanks Thomas - I appreciate the offer, but not at the moment. I've had a read through the TimeXtender 2014 user guide and have somewhat of an idea of what...

That information is stored in the columns starting with "notify_level_" in the msdb.dbo.sysjobs system database, and the text that is displayed in the drop-down box does not show up in...

This is another question that is perhaps too generic for a good answer. A basic method of analyzing the data in an employee table would be a statement like below,...