Viewing 15 posts - 2,791 through 2,805 (of 26,488 total)
July 13, 2017 at 2:25 pm
john.eder - Friday, July 7, 2017 12:09 PMNice answer.Thanks for your help.
Best way to learn is to do it, not always rely...
July 7, 2017 at 12:45 pm
July 7, 2017 at 11:49 am
Of course, the one thing we haven't seen is the DDL for the view itself.
July 7, 2017 at 11:21 am
Here is the MS code modified to work:
IF OBJECT_ID ('dbo.EmployeeSales', 'U') IS NOT NULL
DROP TABLE dbo.EmployeeSales;
GO
CREATE TABLE dbo.EmployeeSales
July 7, 2017 at 11:15 am
And their code is wrong for the same reason. I get the same error running the code you posted from MS as your own code received. The problem is still...
July 7, 2017 at 11:10 am
July 7, 2017 at 8:46 am
Read this: https://docs.microsoft.com/en-us/sql/relational-databases/tables/specify-computed-columns-in-a-table
And it should look like this:
ISsystem AS
July 6, 2017 at 1:30 pm
Estimated number of rows drops to 126 from 67,000+, 53 sort operations, 30 clustered index scans, 12 hash match operations, 8 index scans, 86 nested loop operations, 15 table spool...
July 6, 2017 at 12:04 pm
I think I did find an oops looking at it again:EXEC sp_executesql @sql, N'@Max INT OUTPUT', @Max OUTPUT
July 6, 2017 at 11:53 am
Yes, if the target table existed in multiple schemas then you would have multiple column names returned in the cursor. I all the tables in the multiple schemas were identical,...
July 6, 2017 at 11:50 am
Just took a look at the query plan. The degree of parallelism is 10, 411 parallel operations, 70 sort operations, 22 hash match operations, 47 clustered index scans, 23 index...
July 6, 2017 at 11:27 am
Viewing 15 posts - 2,791 through 2,805 (of 26,488 total)