Viewing 15 posts - 7,456 through 7,470 (of 59,072 total)
It would help a whole lot if you explained the basis of the pivot. For example, what does the column labels of [xx-yy] equate to in the original data?
March 25, 2020 at 8:21 pm
I agree with you. That's too much power for what they do. And they shouldn't be creating linked servers for just anyone.
However, if that's the way it is and you...
March 25, 2020 at 5:27 pm
I actually hope that MS doesn't ever fix that. As the resident DBA for my company, I don't want a bunch of yahoooos building linked servers that could cause breaks...
March 25, 2020 at 4:40 pm
I'm not sure this is still true, but at one point several countries required that invoice numbers and other commercial documents have sequential numbering. This was a legal problem,...
March 25, 2020 at 12:38 pm
Thanks,got it
If you say so. 😉 Just trying to figure out what your goal is so that we can help someone new at it.
March 25, 2020 at 12:32 pm
Jeff Moden wrote:Why wouldn't you just disable the login?
Might still need server-level access, for example to create logins or linked servers.
John
If that's true, I wish the OP would state the...
March 25, 2020 at 12:31 pm
Tip for when you 'walk the second range', take the stories.id from your first query (i.e. add it to the result), and then in the second query add a...
March 25, 2020 at 12:29 pm
That is extraordinary... what's more, it accomplishes work, yet I don't assume you realize how to get the toolbar like you have in the image? I might truly want...
March 25, 2020 at 12:24 pm
The correct answer (according to me :D) isn't available in the list of answers. The correct answer would be to do it in T-SQL. 😀
March 25, 2020 at 12:19 pm
I got this to work, however if the month is 1-9 it sets the date to '01/01/1900' because of the month not having 2 digits.
CASE WHEN ISDATE(left([Due Date],2) +'/'+...
March 24, 2020 at 7:37 pm
Using an idea similar to Phil's good code, if the date and time notation and the extension will always be the same, you could do this just for a little...
March 24, 2020 at 7:07 pm
Why wouldn't you just disable the login?
March 24, 2020 at 6:39 pm
I know. I'm not saying it makes the question or answer incorrect.
I was just providing a possible reason for the explanation's being inaccurate in the way JeremyE pointed out.
That...
March 24, 2020 at 5:13 pm
I'm not sure why such an omission matters. The title of the question specifically cited "Partitioning Limits in SQL Server 2019" and the link is to the official documentaion.
March 24, 2020 at 5:07 pm
an interesting point... using that feature to mask missing identity rows for audit … is that not unethical? just asking for opinions
Identity cache doesn't work that way. Identity cache...
March 24, 2020 at 5:01 pm
Viewing 15 posts - 7,456 through 7,470 (of 59,072 total)