Viewing 15 posts - 271 through 285 (of 1,219 total)
No, you the subscriber can have any name.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 8, 2019 at 12:31 pm
This is obviously not the right place to ask about settings in Excel. However, what I do when I don't want Excel to munch the data, for instance drop leading...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 4, 2019 at 5:44 pm
Triplicate post. Answer posted in https://www.sqlservercentral.com/forums/topic/katma-install-error-shit-2.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 2, 2019 at 1:50 pm
Triplicate post. Answer posted in the thread https://www.sqlservercentral.com/forums/topic/katma-install-error-2
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 2, 2019 at 1:47 pm
Are you working for a museum? 🙂 Pretty old software here, both SQL Server and Windows.
Since the message relates to Office, I guess it is not related to the Database...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 2, 2019 at 1:46 pm
In addition, this sort of problem is a lot easier if you have a full-fledged calendar table, where you have an entry for each day, and where you have a...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 28, 2019 at 7:27 pm
I note that in the screenshot from the query result that SUB_PROG_ID is 436, which does not agree with the WHERE condition.
What is the output from SELECT @@version?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 25, 2019 at 2:57 pm
Well, 2053-07-05 is after 2019-01-01, isn't it?
We don't see the full query, and we don't know how produced the various screenshots, so we can just guess. Either you are doing...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 25, 2019 at 2:47 pm
First build the statement with static SQL and forget the dynamic part, so that you understand how the generated query should look like. Once you have that in place, you...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 21, 2019 at 9:13 pm
Your problem is that you are using the PIVOT keyword for the pivot. That gives you slightly more compact code in the plain-vanilla case, but when you want something else...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 20, 2019 at 4:59 pm
I don't think there is much auditing in msdb. You can run SELECT * FROM msdb.sys.tables to see if anything that catches your eye turns up.
What I found at a...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 20, 2019 at 2:16 pm
The correct way is to explain your problem in a way so that outsiders can understand it. I am sorry, but I am not able to understand what you are...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 17, 2019 at 11:13 am
I can't say why T.[RelatedReferenceType] = Q.ArrangementType AND does not work for you because, I know nothing about your data, tables and view.
However, I can answer why
T.[RelatedReferenceType] = 'TypeA' OR...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 13, 2019 at 10:39 am
I would guess that the reason that the query came back empty-handed is that Chris put in the name of the wrong stored procedure in his query...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 9, 2019 at 7:27 am
Apparently there is a trigger the table calling sp_runwebtask.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
June 7, 2019 at 3:40 pm
Viewing 15 posts - 271 through 285 (of 1,219 total)