The problem isn't your Excel source. The problem is that you are trying to join unequal values. You have Excel, which has only dates. Those get converted...

I'm not sure I understand you're problem. The query you have doesn't seem to relate to the actual problem. Are you trying to join this data against data...

.SQL files are generally plain-text files that contain SQL scripts. They are intended to be run against a database. When they are that large, it most likely means...

Resize the files all you want, but unless you find the root of the problem, it's just going to grow back to the same size. And now every time...

The reason for this limitation is because no two instances of SQL Server can reference the same data files at the same time.

--J

I suspect you're looking at the BOL for the wrong version of SQL Server. I found the BOL you are referencing, but it is for SQL Server Compact: http://msdn.microsoft.com/en-us/library/ms174123(SQL.100).aspx....

If the maintenance plans meet your needs, use them. They work just fine and save you a great deal of time, but there are a few limitations. Until...

Glad to help. I remember having all these same questions when I first started working with SSRS. It took me some time to sort it all out. ...

Weird. I've never seen it do that for me. Try wrapping the formatdatetime(<date>,2) around the dateserial function:

=formatdatetime(dateserial(year(now),month(now),1),2)

Interesting. Is the data type for the parameter DateTime or String? It should be DateTime, because it gives you a great calendar control.

Where are you seeing dates in this format? In the parameters at the top or in the actual report? If you're using dateserial for the parameters, the parameters...

The most performant way to get the data your trying to get is by inserting into a table or temp table with an IDENTITY column. Since you needed a...

I'm sorry, I failed to notice that.

You can emulate ROW_NUMBER() with a subquery:

SELECT

(SELECT COUNT(*) FROM BRIDGE_SCORE BS2 WHERE BS2.Score > BS.Score)+1 AS Rank,

Bridge_ID, Score

FROM BRIDGE_SCORE BS

ORDER...

SELECT

ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, Bridge_ID, Score

FROM BRIDGE_SCORE

ORDER BY Score DESC

You can't really apply set-based logic at the database level because they're not rows in a table, they are full databases. Even if you could, the engine would still...