Wednesday, October 19, 2016

Olly Murs, "Grow Up" [OPC Hits 2016.10.16]

The runner-up of the sixth series of The X Factor UK may have previously fallen short, with "You Don't Know Love" only peaking at #7 here on OPC, but this time, he's right on target as his follow-up jam from his upcoming fifth studio album 24 Hrs debuts on the top spot on this week's Popsounds chart. After "Up" and "Wrapped Up," here's Olly Murs's third OPC #1, and it's yet another track with the word up on the title: "Grow Up."


OPC Hits
October 16-22, 2016

TWLWPPWCARTISTTITLE
POPSOUNDS
1-1@11Olly MursGrow Up
213@15Kenny ChesneySetting the World on Fire [feat. Pink]
3224SiaThe Greatest [feat. Kendrick Lamar]
4332LeAnn RimesHow to Kiss a Boy
541@16Cash CashMillionaire [with Digital Farm Animals feat. Nelly]
6546BastilleGood Grief
7774Olly MursYou Don't Know Love
8654Yeng ConstantinoPaasa (T.A.N.G.A.)
981@15Christina GrimmieWithout Him
1010102Dan + ShayHow Not To
PRAISE PARADE
1-1@11Sidewalk ProphetsImpossible
211@12Chris TomlinGod of Calvary
3-31David DunnI Wanna Go Back
4222DiscipleErase
5332Micah TylerNever Been a Moment
6442UnspokenHigher
7-71Tasha CobbsPut a Praise on It [feat, Kierra Sheard]
852@15Britt NicoleThrough Your Eyes
9662Lauren DaigleWordless
10727Tauren WellsLove Is Action
PINOY PICKS
116@16Yeng ConstantinoPaasa (T.A.N.G.A.)
2224Mark CarpioHiling
332@18Hazel FaithKinikilig
4428Leanne and NaaraAgain
5538Rico BlancoWag Mong Aminin

Monday, October 17, 2016

Cupid's Reason


Q: Why does Cupid shoot us with his arrows?
A: So we can love with our HOLE heart.

Monday, October 3, 2016

OPC Hits: Yeng Constantino, "Paasa (T.A.N.G.A.)"

Yeng Constantino is continuing on her tradition of topping the OPC Hits chart. Following her #1 songs "Ferris Wheel," "Dance Without the Music," "What's Up Ahead" featuring husband Yan Asuncion, and "Shining Like the Sun (Baby Are You Ready)" is another track which people could easily relate to, especially in this age of social media. Here's "Paasa (T.A.N.G.A.)," now on its fourth week at #1.


OPC Hits
October 2-8, 2016

TWLWPPWCARTISTTITLE
POPSOUNDS
112@13Kenny ChesneySetting the World on Fire [feat. Pink]
2222SiaThe Greatest [feat. Kendrick Lamar]
331@14Cash CashMillionaire [with Digital Farm Animals feat. Nelly]
4444BastilleGood Grief
5552Yeng ConstantinoPaasa (T.A.N.G.A.)
6962JoJoMad Love
7-71Kings of LeonWaste a Moment
8772Olly MursYou Don't Know Love
9-23Shawn MendesMercy
10-101Mike PerryThe Ocean [with Shy Martin]
PRAISE PARADE
112@13Britt NicoleThrough Your Eyes
2225Tauren WellsLove Is Action
3-31Danny GokeyRise
431@13Building 429Be with Us Now (Emmanuel)
5423Hawk NelsonLive Like You're Loved
654@18Casting CrownsOne Step Away
761@16Jason GrayCelebrate
8728Every Nation MusicAuthor of My Life [feat. Bryson Breakey]
9-91Lauren DaigleCome Alive (Dry Bones)
10992Colin BakerHeaven Open
PINOY PICKS
114@14Yeng ConstantinoPaasa (T.A.N.G.A.)
2222Mark CarpioHiling
332@16Hazel FaithKinikilig
4426Leanne and NaaraAgain
5536Rico BlancoWag Mong Aminin

Saturday, October 1, 2016

SQL Error on Unnecessary varchar to int Conversion


Scenario

Consider the following table:

CREATE TABLE [dbo].[AuditTrail](
[AuditTrailID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NOT NULL,
[FieldName] [varchar](50) NULL,
[OldValue] [varchar](max) NULL,
[NewValue] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

And consider the following script:

DECLARE @OldRoleID int
DECLARE @NewRoleID int

DECLARE @OldUsername varchar(25)
DECLARE @NewUsername varchar(25)

SET @OldRoleID = 1
SET @NewRoleID = 2

SET @OldUsername = 'Juan'
SET @NewUsername = 'John'

INSERT INTO dbo.AuditTrail VALUES
(1, 'RoleID', @OldRoleID, @NewRoleID),
(1, 'Username', @OldUsername, @NewUsername);