Viewing 15 posts - 271 through 285 (of 1,219 total)
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...
July 4, 2019 at 5:44 pm
Triplicate post. Answer posted in https://www.sqlservercentral.com/forums/topic/katma-install-error-shit-2.
July 2, 2019 at 1:50 pm
Triplicate post. Answer posted in the thread https://www.sqlservercentral.com/forums/topic/katma-install-error-2
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...
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...
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?
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...
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...
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...
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...
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...
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...
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...
June 9, 2019 at 7:27 am
Apparently there is a trigger the table calling sp_runwebtask.
June 7, 2019 at 3:40 pm
Viewing 15 posts - 271 through 285 (of 1,219 total)