Viewing 15 posts - 421 through 435 (of 844 total)
Jeff, If you have a better solution please include it. I would really like to understand how it could be done without the OR.DECLARE @Data_Group_Number CHAR(1);
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 2, 2018 at 1:01 pm
Couldn't you concat the loan number and the date to create the unique ID? In your example 2 and 4 would have the same UniqueID.ID Loan# Date UniqueID
1 12345 2015-12-01 1234520151201
2 12345 2016-12-01 1234520161201
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 30, 2018 at 1:57 pm
I modified Steve's code: This will return all 3 rows if you send the value of '0'.DECLARE @Data_Group_Number CHAR(1);
SET @Data_Group_Number = '0';
WITH group1...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 30, 2018 at 1:43 pm
I've never needed to do anything like this, but I would think you could tie the image to the group footer. I may be way off, it has been a...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 30, 2018 at 1:28 pm
In the properties for the cell, under 'Number' there is Format, if you put a lower case d it will display the date without the time in MM/DD/YYYY format.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 30, 2018 at 1:19 pm
2018 World Series Champs, Pirate's!! 🙂 Heck, I'll be happy if they finish above 500, the bums.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 29, 2018 at 2:02 pm
Although, yours has the same desired layout on the output, my example allowed...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 22, 2018 at 10:46 am
Thanks for the suggestion. I like what you did, but the output is not...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 22, 2018 at 9:50 am
OK, I couldn't figure out how to do it with PIVOT without hard coding the names. I'm sure there is a way, just not seeing it right now.
Here is...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 22, 2018 at 9:49 am
I would think you would only need one pivot statement. Pivot the name and percentage in the same statement. If you can't get that to work, I think 'Cross Apply'...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 21, 2018 at 12:57 pm
What have you tried? Did you try using PIVOT?
https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 21, 2018 at 11:04 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 15, 2018 at 11:12 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 15, 2018 at 9:45 am
GeorgeCopeland - Thursday, March 15, 2018 7:21 AMThe proper term for a developer who doesn't use source control is "amateur".
WOW, I was...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 15, 2018 at 7:46 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 8, 2018 at 8:59 am
Viewing 15 posts - 421 through 435 (of 844 total)