Viewing 15 posts - 1,231 through 1,245 (of 5,111 total)
The other problem that that is that you do need the SQL Browser service to be running. I assume, therefore, you don't at least have any documentation of the servers...
February 27, 2019 at 4:41 am
Out of interest, why are you storing decimal values in a varchar? Doing things like that are only going to come back to bite you. For example, in your data,...
February 27, 2019 at 3:46 am
February 26, 2019 at 10:01 am
You are going...
February 26, 2019 at 8:47 am
February 26, 2019 at 8:44 am
As per...
February 26, 2019 at 8:12 am
Use date variable instead and then add a couple of extra clauses to your WHERE. In very simple Pseudo-SQL terms:
DECLARE @date varchar(100);
SET @date='2019-02';
DECLARE...
February 26, 2019 at 7:47 am
If you mean that you want al "all" option for @Company, I'd personally pass NULL and handle it with an OR:
SELECT
[SS-zzReport].order_no
...
February 26, 2019 at 4:30 am
tmmutsetse - Monday, February 25, 2019 6:57 AMThanks so much
Did you fix the problem then tmmutsetse? What was the problem in the...
February 25, 2019 at 7:04 am
The only reason the query would return a different result is if the query isn't the same, the permissions differ (meaning the user running the report can't see the data),or...
February 25, 2019 at 2:49 am
DBA_007 - Thursday, February 21, 2019 7:45 AMHow to purge Historical data from a Database
I've tried to help here, but we're getting...
February 21, 2019 at 7:58 am
kiran 4243 - Thursday, February 21, 2019 1:18 AMHello Experts,Any feedback for my request. Appreciate your valuable feedback.
Best Regards,
What was wrong with...
February 21, 2019 at 3:25 am
Could it be the network, rather than the disc(s)? Considering this is a linked server, I assume that the location of the data is from a different host, so perhaps...
February 21, 2019 at 3:02 am
February 21, 2019 at 2:56 am
DBA_007 - Thursday, February 21, 2019 1:40 AMHello All,
Please let me know how to purge data in production.
What do you mean by...
February 21, 2019 at 2:13 am
Viewing 15 posts - 1,231 through 1,245 (of 5,111 total)