Grant Fritchey (11/30/2016)

---

Is abc.name from a table or is it from some code? If it's a table, sure, I guess you leave it be. If it's code, I'd rather see...

There's no user input...

Yes, in most cases replacing loops with set-based code is a good thing. There's nothing wrong with your code as written. You can also write it something like...

Your original request was for comments from those who have encountered this problem before. I haven't, but I'd say all you need to do is make any necessary changes...

What have you been asked to do - fix the incorrect data, or prevent any further incorrect data from getting in...

I would say no, although it does, of course, depend on what your loop is actually doing. If you use a correctly configured cursor then the result set through...

The best way to be sure is to test it, but I think the answer is no - you can only restore in one direction, regardless of compatibility level.

John

Isn't it as simple as this?

SELECT DISTINCT

MAX(TheDate) OVER(PARTITION BY YEAR(MyDate), MONTH(MyDate)) AS LastBizofMonth

,MyDay

FROM MyTable

WHERE MyDay NOT IN ('Saturday', 'Sunday')

By the way, please don't double-post.

John

Joe's solution involves connecting to each instance on the server individually. You may be happy with that, or you might prefer to connect to one of them and use...

Nicole

SQL Server 2016 Developer Edition is now free. As its name suggests, though, it's not for use in a production environment.

As for migration, if white papers exist, they'll be...

The error message does state that the problem is in the TABLE HINT clause, so it's curious that changing the actual statement makes it go away. What is MVXJDTA.MITALO...

tonytohme (11/25/2016)

---

Hello,

I have the following table:

ID bigint,

Name varchar(50),

Address varchar(250),

RecDate smalldatetime,

PurPrice decimal(7,2),

PaidBy varchar(50)

I am trying to come up with a select statement that will group the results by ID and sums...

It looks to me as if the problem is with the TABLE HINT clause in the @hints parameter. ...

The reason the fragmentation level is so high is merely academic. For a 15-page index, it really doesn't matter. As for the other numbers you mentioned, I can't...

For small indexes, rebuilding or reorganising won't make any difference to fragmentation levels. Because of the size of such indexes, the fragmentation level has little or no impact on...