Viewing 15 posts - 76 through 90 (of 179 total)
Seems to me that this is a classic case of normalization.
You have a table containing Jobs and some information about the jobs.
You have another table containing Objects and...
November 28, 2018 at 6:07 am
November 28, 2018 at 5:22 am
November 13, 2018 at 8:41 am
Do you know if the incoming numbers will always have 4 groupings with a single space between them?
Or might you get numbers like
1-800-123-4567
1(800)123-4567
1 (800) 123-4567
October 30, 2018 at 5:45 am
October 11, 2018 at 5:55 am
October 2, 2018 at 5:09 am
Since you're filtering on an identity column which would only have the value 1, why would any data be returned?
September 11, 2018 at 5:19 am
Maybe I'm reading the OP's (clarified) requirements wrong.
But I don't think he wants a count of the number of non-zero values. Rather, he wants the highest prod id...
August 15, 2018 at 5:37 am
July 30, 2018 at 5:25 am
Why don't we just do it the correct way for handling nulls:
WHERE nt.myvalue IS NULL
Since the first two choices were the same, I thought...
July 30, 2018 at 5:12 am
July 26, 2018 at 5:16 am
dalviprasad31 - Monday, July 23, 2018 6:33 AMUse below expression
convert(char(8), dateadd(second, [int_datatype_column], ''), 114)
I know you're a new user.
But you responded to...
July 24, 2018 at 6:04 am
I don't quite understand your process.
You say the table has 2 1/2 years of data, so for simplicity let's say all of 2016, 2017 and the first half...
July 17, 2018 at 5:27 am
We use the Expression Builder for a variable in SSIS to generate a date-stamp
(DT_WSTR,4) YEAR(GETDATE()) +
RIGHT("0" + (DT_WSTR,2) MONTH(GETDATE()),2) +
RIGHT("0" + (DT_WSTR,2) DAY(GETDATE()),2)
Rearrange...
July 10, 2018 at 5:46 am
Viewing 15 posts - 76 through 90 (of 179 total)