Viewing 15 posts - 1,231 through 1,245 (of 5,109 total)
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,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 27, 2019 at 3:46 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 26, 2019 at 10:01 am
You are going...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 26, 2019 at 8:47 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 26, 2019 at 8:44 am
As per...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2019 at 3:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 21, 2019 at 2:13 am
Considering this is SSIS, I would suggest directing your failed rows to a different output (i.e. a text file) and then inspect those. We don't know your data or the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
February 19, 2019 at 10:01 am
Viewing 15 posts - 1,231 through 1,245 (of 5,109 total)