I don't believe you can bulk insert multiple files at once.
Probably the easiest way to do it is with a simple SSIS package.

Here's an example: https://www.mssqltips.com/sqlservertip/2874/loop-through-flat-files-in-sql-server-integration-services/

Thanks Andrew.
I assume I solved the problem or managed it a different way. I can't even remember what it was I was working on! ha
Cheers,
Jim.

You can use the below code to search msdb for non SSIS catalog packages:

SELECT TOP 1000[name]
      ,[id]
      ,[description]
      ,[createdate]
      ,[folderid]
     ...

Hi,

Do you at least have a field that is common between the datasets you're trying to join? You can use LOOKUPSET to get a set of data if that's any...

Hi,

So the TallyERP database is SQL Server? Or are you trying to connect to some other database from SSRS to get the data you need?

If the TallyERP database is SQL...

Hi Again!

Open your report and go to Report > Report Properties > Code

Then paste in the below:

Function LastWorkingDay(StartDate As DateTime) As DateTime

Dim StartDateDOW = DatePart(DateInterval.Weekday, StartDate)

Dim DaysBack = 0

If (StartDateDOW)...

Ok, thought so. Unfortunately it's nearly half past 11 here so it's bed time. I'll shoot the formula over first thing tomorrow if you haven't solved it by then! Sorry...

For instance, the first day of this month (February 2015) was a Sunday. Do you want to return 28/Jan/2015 or 4/Feb/2015?

Also the last day of this month (February 2015) is...

I assume that if the first day of the month is a Sunday then the date you want to return is the previous Wednesday? Similarly, if the last day of...

Hi,

I believe the text you are seeing regarding the link will be set by the language of the server according to BOL here:

https://msdn.microsoft.com/en-us/library/ms156493.aspx

Specifically this line:

Errors, warnings, and informational messages that...

Hi David,

There are a number of ways to achieve what you're after. You could add the filter to the query your data set is based upon, this will send a...

Hi PWalter,

Yes you can create a query based on two different servers, here's some info on how to set it up:

https://msdn.microsoft.com/en-GB/library/ff772782.aspx

Your query would end up looking something like this:

SELECT a.Column1,...

Jeff Moden (2/20/2015)

Do you happen to have a working example of such a thing? I'd...

Hi,

It smells like SSRS is doing the SUM before the DIVIDE instead of doing the DIVIDE first and then the SUM.

So in the below there are product sales for 2...