Viewing 15 posts - 1 through 15 (of 90 total)
We will try that approach. Thanks for the advice!
February 17, 2022 at 7:11 pm
I agree with you totally, Views is the way to go. What we are trying to avoid is having to grant permissions at each database object which is tedious therefore...
February 2, 2022 at 2:24 pm
I totally agree with you. Please continue with your teachings about data types best practices.
Most of those settings are in binary state (1/0, true/false, Yes/No) and where they can be...
June 27, 2019 at 5:50 pm
Point taken. On the real life table, we do have an index on ( ClinicID, ItemID ). I will probably drop the clustered PK and make ( ClinicID, ItemID )...
June 25, 2019 at 9:35 pm
Thank you, Jeff. Another good use for CROSS APPLY!
June 25, 2019 at 9:03 pm
Thank you, Jeff. A good use of CROSS APPLY.
June 25, 2019 at 8:33 pm
Thank you, Desnorton. We run in Azure SQL on a low end service tier so we don't use temp tables much.
I will look into the other possibility.
June 21, 2019 at 11:35 pm
Hi Phil,
Pretty cool, your solution runs fastest compared to Row_Number solution and max/group by solution. Thank you very much!
June 21, 2019 at 12:21 am
Yes,, under Project Properties, there is a target platform dropdown that goes from SQL Server 2005 to Microsoft Azure SQL Database V12. I set Microsoft Azure SQL Database V12.
Setting...
April 19, 2017 at 6:38 pm
Many thanks to both Eirikur and Luis for providing a solution though the statement is unclear . That works for what I am planning to do. It is
April 10, 2017 at 1:10 pm
Hugo,
Thank you very much for the solution which is much compact and easier to read and follow that what I had.
January 31, 2016 at 4:32 pm
I applaud your sense of responsibility.
I will present the Old and main table approach again and offer the view for reporting. Perhaps the view will buy the...
March 4, 2014 at 10:00 am
I am very fond of the "OldPatientRecords" and main clean table approach. That is how I approached it. However, I did not get approval because it complicates...
March 3, 2014 at 3:29 pm
May I ask why the covering index is a better choice? Thanks!
February 11, 2014 at 3:00 pm
Viewing 15 posts - 1 through 15 (of 90 total)