Viewing 15 posts - 9,211 through 9,225 (of 39,771 total)
It's a huge "it depends" issue. More and more I think there are domains where we are assuming that an RDBMS is the best fit. As I look to see...
September 4, 2015 at 9:42 am
Eric M Russell (9/3/2015)
Just curious what type of code changes would be needed for a MS Access application originally designed for SQL Server 2005 to support SQL Server 2014 ?
Connectivity...
September 3, 2015 at 4:25 pm
samot-dwarf (9/3/2015)
I think Microsoft would be better served by letting customers license the scale they need
You mean similar as Oracle where you have to multiply your real cores by a...
September 3, 2015 at 4:24 pm
Sean Redmond (9/3/2015)
Secondly, is this not a task for the sysadmins? They are responsible for security. If they are happy that the server...
September 3, 2015 at 4:23 pm
Ed Wagner (9/2/2015)
Agreed. So what is in a CTE? It contains a SELECT statement. You can do multiple things with it, one of which is SELECT.
I see...
September 2, 2015 at 11:49 am
Part of the issue is there are some items in the articles that don't render well on smaller screens. It is was just text, that's fine, but we saw some...
September 2, 2015 at 11:48 am
Sean Lange (9/2/2015)
Steve Jones - SSC Editor (9/2/2015)
September 2, 2015 at 9:49 am
Welcome and hope we can help you.
Or you can help others.
September 2, 2015 at 9:24 am
Post some code, DDL + the query you've tried.
I would start by just querying the date field and getting the results you need there, converted to the month and year....
September 2, 2015 at 9:23 am
We've tried various things, including a mock up for the QotD mobile. The problem for us, as Grant mentioned, is we have lots of other things to do. This site...
September 2, 2015 at 9:22 am
I use snippets in Prompt.
They've been in SSMS as Templates for a long time. You can drag/drop them into query windows. CTRL+Shift+M for parameters
September 2, 2015 at 9:20 am
I haven't seen a good way of diff'ing SSIS data. We started down the road with a DTS Compare at one point, but the mess of the file by MS...
September 2, 2015 at 9:13 am
You can use a CTE to get the max date from the table with the SH code along with the cartid and then join that to your other data.
with mycte...
September 2, 2015 at 9:07 am
I do agree with the = and try to use it, precisely because complex code becomes hard to read when the name is buried far to the right of...
September 2, 2015 at 8:49 am
The sixth one should have had brackets. That's been corrected. However, I missed a few since there could be no joiner (=/AS) in there, so it's probably more like 12....
September 2, 2015 at 8:47 am
Viewing 15 posts - 9,211 through 9,225 (of 39,771 total)