Viewing 15 posts - 11,926 through 11,940 (of 59,064 total)
July 2, 2018 at 1:31 pm
July 2, 2018 at 12:56 pm
Hammers existed before we...
July 2, 2018 at 12:16 pm
If it's for a one-off task, you can use SQL Diagrams, which is a built in tool. It's fairly limited but for simple tasks such as you describe, it may...
July 2, 2018 at 7:10 am
The whole purpose of the third party software is to do exactly what is being requested and it's being done for "legal reasons". Pre-filtering is not only more difficult than...
July 2, 2018 at 6:56 am
I have been tasked with building a powershell file mover to move files (which...
July 2, 2018 at 6:49 am
Luis Cazares - Monday, July 2, 2018 6:29 AMHave you tried using EXCEPT?
That would be my recommendation, as well. WHERE...
July 2, 2018 at 6:44 am
Doing more frequent log file backups
July 2, 2018 at 6:38 am
July 2, 2018 at 6:27 am
Heh... Just a random thought... With no reflection on the OP, even as few as 20 colors is going to add no value to the report. 1 color for each...
July 1, 2018 at 5:27 am
There is no need to make another scan on the table in the outer SELECT just to get things like the ManagerName.
Also, if the CEO want's to be...
June 30, 2018 at 11:16 pm
This part of your code causes a full table scan regardless of the TOP 52 because of the ORDER BY in the ROW_NUMBER(). Since you're doing the ORDER BY on...
June 30, 2018 at 10:36 pm
June 30, 2018 at 9:33 pm
June 30, 2018 at 7:21 pm
Viewing 15 posts - 11,926 through 11,940 (of 59,064 total)