When you say the others do you mean other databases, or the TempDB files?

TempDB generally starts with several small files (generally 1 per core, up to 8). These all have...

Depends on the OP's definition...

mokarem (11/29/2016)

---

Thanks for your effort. but it is not giving the expected result.

For quarter data '2014 quarter 1' , '2014 quarter 2', '2014 quarter 3', '2014 quarter 4'

the...

What is MAT, and where is it coming from? We don't have any informaiton on that. I've made a simple guess that you could do this with an CROSS APPLY,...

The SQL database engine is incredibly quick to install yes, but I'm not going to really complain about that. Considering that when installing SQl Server on Windows it can take...

We'll need a bit more information than that. Error messages, for example. What SQL are you running to create the backup?

As Kingston said, Lag/Lead, Analytic Functions (Transact-SQL), would be a much better choice.

Without knowing your full DDL or data sample, this is complete gueswork, but:

USE DevTestDB;

GO

CREATE TABLE #fueltran (ReadingID INT...

You can still configure datasources to use Windows Authentication (it's one of the options in the Web portal, just make sure you tick "Use Windows Credrentials when connected to the...

I sounds like you've configured your datasource incorrectly. Are you using a shared datasource or a datasource saved within the report?

If shgared, have you deployed the datasource? Either way you'll...

We can see them, but pictures don't help us with what the data looks like. If I...

You have your error there then. The password...

INNER JOINS (msdn) really are the basics on SQL. I would suggest reading on the matter, rather than asking for someone to write you SQL for what looks like a...

I don't have an answer right now but I HAD to fix that awful Word Wrapped SQL you'd pasted, so that someone else doesn't have to:

SELECT intras_annee,

...

If you're using an ETL tool, then the ETL tool will be making all the decisions, not SQL Server. The problem isn't SQL Server, it's your ETL tool.

You said earlier...

Considering that the error is "Login failed for user '<username>'" this implies that you login details are the problem, not the fact that it has a \ in it. You...