I’ve added a resume site, please take a look.
Added Resume
04
Sep
Creating a mysql db and user from command-line
15
Feb
1. From the command-line enter the following to use MySQL Monitor. You will be prompted for your MySQL root password.
mysql -u root -p
2. Create the database:
- Replace [DB NAME] with the name of your database you wish to create.
CREATE DATABASE [DB NAME];
3. Select the created Database.
- Replace [DB NAME] with the database you created.
USE [DB NAME];
4. Create a User for this Database and Grant ALL Privileges:
- Replace [DB NAME] with the name of the database you just created.
- Replace [DB USERNAME] with the username you wish to create.
- Replace [DB PASSWORD] with the password you wish to use for this created user.
- By default this user can only connect from localhost, if you wish to connect from another source, replace localhost with either a % or another source address.
GRANT ALL PRIVILEGES ON [DB NAME].* TO '[DB USERNAME]'@'localhost' IDENTIFIED by '[DB PASSWORD]';
Splitting Full Name into two separate fields (First Name, Last Name)
14
Feb
Recently I implemented a new CRM at our office. The old CRM was custom built by our CEO when the company was new and with only a couple employees. For many reasons we decided to implement a new CRM. The old crm didn’t separate the First Name and Last Name but instead had a contact field for the full name. When the initial import of data happened, I imported the full name into the last name field. This has been problematic for our Sales department. I was able to resolve this by using the following;
UPDATE CONTACTS
SET FIRST_NAME = RTRIM(LTRIM((substring(LAST_NAME,1,charindex(' ', LAST_NAME)))),
LAST_NAME = RTRIM(LTRIM(substring(LAST_NAME,charindex(' ', LAST_NAME)+1,
len(LAST_NAME))))
Original Source: http://www.daniweb.com/forums/thread66532.html
Display Percentages when Field value is populated
11
Feb
I was creating a sales percentages report and ran into a problem that caused Percentage calculations for months that haven’t been completed yet. See below table for example of data. After I submitted my question to the SSRS Microsoft Forum, I found a solutions. If I set a condition that only calculated the percentage is the value of the cell wasn’t “0.00″.
Issue: Calculate Percentage is calculated by (2011.Value – 2010.Value) / 2010.Value
| Month | 2010 | 2011 | Increase % |
| 1 | $400,000.00 | $500,000.00 | 25% |
| 2 | $300,000.00 | 0.00 | -100% |
| 3 | $500,000.00 | 0.00 | -100% |
Resolution: Calculate Percentage is calculated by (2011.Value – 2010.Value) / 2010.Value
| Month | 2010 | 2011 | Increase % |
| 1 | $400,000.00 | $500,000.00 | 25% |
| 2 | $300,000.00 | 0.00 | |
| 3 | $500,000.00 | 0.00 | |
SSRS Expression on the Increase Percentage Cell:
=IIF(Fields!ID2011_year.Value = "0.00", "", SUM((Fields!ID2011_year.Value-Fields!ID2010_year.Value)/Fields!ID2010_year.Value))
Original Source: http://tiny.cc/e731l
Alternate Background of Table Rows
11
Feb
Go to the table row’s BackgroundColor property and choose “Expression…”
Use this expression:
= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
This trick can be applied to many areas of the report.
And in .NET 3.5+ You could use:
= If(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")
Original Source: http://tiny.cc/48w78