Viewing 15 posts - 2,791 through 2,805 (of 26,490 total)
July 17, 2017 at 10:48 am
July 17, 2017 at 8:34 am
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
Viewing 15 posts - 2,791 through 2,805 (of 26,490 total)