Viewing 15 posts - 226 through 240 (of 844 total)
When I came back to work Monday I was initially excited to see we were on the new version of SSC. My excitement quickly faded.
I read Steve's article the other...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 10, 2019 at 2:04 pm
Lanes
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 8, 2019 at 7:17 pm
kdrymer - Wednesday, March 27, 2019 1:01 PMWorks beautifully!!! Think it was an issue with the grouping. Thanks very much!
Your Group...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 27, 2019 at 1:43 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 27, 2019 at 11:55 am
A definition and test data for businessunitbase would be helpful.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 27, 2019 at 10:17 am
Couldn't you just left join the table businessunitbase to itself?
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 27, 2019 at 9:38 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 27, 2019 at 7:41 am
I see Lynn, but I'll take my chances for now.WITH CTE AS
(SELECT A.BUSINESS_UNIT, A.PO_ID, A.PO_TYPE, A.PO_STATUS,
(CONVERT(CHAR(10),A.PO_DT,121)) AS PO_DT,
...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 3:18 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 3:08 pm
I modified the SQL I posted, I didn't want to take the time to reformat your last post.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 1:55 pm
With out test data it's hard to say, but try this: (ALWAYS post your code within the SQL code tags) I removed a bunch of columns in your group by...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 1:38 pm
I...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 12:42 pm
Looking at your results from (Alias 'CTE') the reason you are not getting one row per requestor is the 'Line_NBR' column.
It doesn't look like you are using that field...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 26, 2019 at 12:41 pm
Cast Sequence# as a char and don't convert member# to an int to get around this. At least that's what I would do. There is no FROM in your CTE,...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 25, 2019 at 2:36 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 22, 2019 at 12:53 pm
Viewing 15 posts - 226 through 240 (of 844 total)