I assume the misleading column names were a deliberate attempt to distract from the problem? 🙂

("OrdersIn2000" for the orders in 2011 excluding 1st Jan, etc.)

SSRS has been completely neglected by the .NET team for years now.

For web applications, the only library available requires the ancient WebForms references, which aren't part of .NET Core or...

I think Randall said it best: https://xkcd.com/1319/

"... we can see that a decade has brought us multiple orders of magnitude of data growth"

Not sure I would agree with that. Based on the figures quoted, we only...

Corrected how?

You're still showing two invalid answers - CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET) and SELECT '20161015 08:15 2:00'.

The solution is also confusing - the "correct answer" is option 2,...

SQL-DBA-01 (3/18/2015)

---

Hi Steve

Sorry, if I am confused, but the below link says:

"https://technet.microsoft.com/en-us/library/bb895334(v=sql.110).aspx"

SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

So I selected...

The fact that it's almost identical to the question posted on 15th May helps! 🙂

http://www.sqlservercentral.com/questions/SQL+Server+2014/108889/[/url]

The date on that question...

I'm just hoping that, after last month's .NET updates broke SharePoint, they don't reintroduce the problem this month. It took them three weeks to release a patch for a single...

Your query using the CHECKSUM index is incorrect:

SELECT *

FROM dbo.PostalCode

WHERE PostalCheckSum = CHECKSUM(@PostalArea, @PostalCity, @PostalState);

As previously mentioned, the value returned from CHECKSUM will not be unique for the...

I'm still waiting for an explanation of why hundreds of perfectly valid bug reports were recently deleted. Even if they were closed as "won't fix", it was useful to know...

Also:

http://msdn.microsoft.com/en-us/library/ms175010.aspx

A perfect example of how not to write comments! 😛

Nice - a potential SQL injection vulnerability right inside your database! 😛

No wonder they've got so many LoC if they restrict the length of...

Another point to consider - what if the company hosting your data goes bankrupt? The receivers will likely turn off the servers abruptly, without giving you any time to extract...