Viewing 15 posts - 1,381 through 1,395 (of 5,111 total)
Only where you have used enterprise features of 2008 that aren't in Standard Edition of 2016 and the breaking changes for SQL Server 2012-2016. And, of course, the cardinality estimator...
November 29, 2018 at 10:03 am
That picture suggest you have a really old version, considering it uses SSC branding and not Regdate. I just downloaded a copy from here, and the version was...
November 29, 2018 at 9:30 am
Maybe the DISTINCT, which just gets more expensive the more rows and columns you have? More than likely the lack of indexes which we have no details on. I can't...
November 29, 2018 at 2:21 am
Im executing SSIS package by using Batchfile and scheduled batch using SQL job agent.
Now...
November 29, 2018 at 2:07 am
I'm afraid, however, at this stage I'm out of ideas. Without sample data to test against I have no way to replicate the issue, and I'm out "educated" guesses at...
November 28, 2018 at 11:06 am
Why are your other 2 expressions always in single quotes? That's not a valid expression as is. This isn't dynamic SQL is it and you're just not giving us the...
November 28, 2018 at 11:03 am
EasyBoy - Wednesday, November 28, 2018 9:23 AMThis will most probably won't allow by organization due to some security concern.
If you can't...
November 28, 2018 at 9:55 am
You can configure SMTP with free mail services as well, such as gmail and live. Have you considered using those instead? Otherwise, you'll need a local SMTP service to connect...
November 28, 2018 at 9:19 am
I guess my issue is that these two linesCAST(COALESCE(LEFT(o.Part_Family_Code,2),0) *.9 AS decimal...
November 28, 2018 at 8:56 am
November 28, 2018 at 8:30 am
Sue_H - Tuesday, November 27, 2018 2:51 PMFor data driven subscriptions, I believe they would also need Manage Reports permissions.
Sue
Sue...
November 28, 2018 at 8:26 am
The error is telling you the problem here. One of the following expressions is returning a value greater than 99999999.99 or less than -99999999.99:LEFT(o.Part_Family_Code,2),0) *.9LEFT(o.Part_Family_Code,2),0) *1.1
We can't...
November 28, 2018 at 8:22 am
Have you considering using OPENROWSET or OPENDATASOURCE?
November 27, 2018 at 5:17 am
Viewing 15 posts - 1,381 through 1,395 (of 5,111 total)