Ryan Whitaker

Dishes of Ryan

Modify data before it's inserted in SQL Server 2000/2005

I had a scenario where I needed to massage some data in this one particular column before it got inserted into the database.

I usually like to implement this kind of logic alongside its business brethren, leaving as much business brouhaha out of the raw database as possible, but in this case I was straddling two apps.  One old one, one new one, both using the same database.  Problem was, I didn't want to pull down the old code from the Vault, recompile, and post a newish-old version.  Long story short, I implemented an INSTEAD OF trigger on the table to massage the data before it got inserted.  Boom, data massage for both apps.

/* This trigger makes sure that the data being inserted into
   the BarColumn column starts with a dash.  If it doesn't, it
  
will prepend one. */

CREATE TRIGGER FooTable_Insert ON dbo.FooTable
INSTEAD OF INSERT
AS
DECLARE @BarColumn varchar(50)
SET @BarColumn = (SELECT BarColumn FROM INSERTED)
IF (LEFT(@BarColumn, 1) <> '-')
BEGIN

     SET @BarColumn = '-' + @BarColumn
     SELECT * INTO #Inserted FROM Inserted
     UPDATE #Inserted SET BarColumn = @BarColumn
     INSERT INTO FooTable SELECT * FROM #Inserted
END
ELSE
     INSERT INTO FooTable SELECT * FROM Inserted

Posted: Feb 02 2006, 11:48 PM by RyanW | with 258 comment(s)
Filed under:

Comments

Thomas said:

Exactly what I was looking for, but I have some small adjustments:

USE [RADIUS]

GO

/****** Objekt:  Trigger [dbo].[CheckDateTimes]    Skriptdatum: 03/29/2008 10:32:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author: <Author,,Name>

-- Create date: <Create Date,,>

-- Description: <Description,,>

-- =============================================

CREATE TRIGGER [dbo].[BusinessEntity_CheckDateTimes]

  ON  [dbo].[BusinessEntity]

  FOR INSERT,UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @CreateDate DateTime

DECLARE @LastModified DateTime

DECLARE @INDEX Int

SET @CreateDate = (SELECT CreateDate from INSERTED)

SET @LastModified = (SELECT LastModify from INSERTED)

SET @INDEX = (SELECT BusinessEntityIndex from INSERTED)

-- SELECT * INTO #Inserted FROM Inserted

IF (@CreateDate = {ts '1753-01-01 00:00:00.000'})

UPDATE BusinessEntity SET CreateDate = NULL WHERE BusinessEntityIndex = @INDEX

IF (@LastModified = {ts '1753-01-01 00:00:00.000'})

UPDATE BusinessEntity SET LastModify = NULL WHERE BusinessEntityIndex = @INDEX

   -- INSERT INTO BusinessEntity SELECT * FROM #Inserted

   -- Insert statements for trigger here

END

GO

CREATE TRIGGER [dbo].[Groups_CheckDateTimes]

  ON  [dbo].[Groups]

  FOR INSERT,UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @Date DateTime

DECLARE @INDEX Int

SET @INDEX = (SELECT GroupIndex from INSERTED)

SET @Date = (SELECT AcctExpireDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE Groups SET AcctExpireDate = NULL WHERE (GroupIndex = @INDEX)

SET @Date = (SELECT AcctStartDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE Groups SET AcctStartDate = NULL WHERE (GroupIndex = @INDEX)

END

GO

CREATE TRIGGER [dbo].[Users_CheckDateTimes]

  ON  [dbo].[users]

  FOR INSERT,UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @Date DateTime

DECLARE @INDEX Int

SET @INDEX = (SELECT UserIndex from INSERTED)

SET @Date = (SELECT PasswordDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE users SET PasswordDate = NULL WHERE (UserIndex = @INDEX)

SET @Date = (SELECT StartDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE users SET StartDate = NULL WHERE (UserIndex = @INDEX)

SET @Date = (SELECT UserExpiryDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE users SET UserExpiryDate = NULL WHERE (UserIndex = @INDEX)

SET @Date = (SELECT LockoutTime from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE users SET LockoutTime = NULL WHERE (UserIndex = @INDEX)

END

GO

CREATE TRIGGER [dbo].[UserDetails_CheckDateTimes]

  ON  [dbo].[userDetails]

  FOR INSERT,UPDATE

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

DECLARE @Date DateTime

DECLARE @INDEX Int

SET @INDEX = (SELECT UserIndex from INSERTED)

SET @Date = (SELECT CreateDate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE UserDetails SET CreateDate = NULL WHERE (UserIndex = @INDEX)

SET @Date = (SELECT LastModify from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE UserDetails SET LastModify = NULL WHERE (UserIndex = @INDEX)

SET @Date = (SELECT LastTotalOnlineUpdate from INSERTED)

IF (@Date = '1753-01-01 00:00:00.000')

UPDATE UserDetails SET LastTotalOnlineUpdate = NULL WHERE (UserIndex = @INDEX)

END

This makes it easier to maintain for my purpose

# March 29, 2008 8:10 AM

Waylon said:

Have you guys tried a batch update on the table(s) with your proposed triggers active?

# July 16, 2008 2:59 PM

Hernan said:

you can use table variables... @table

# February 17, 2009 5:09 PM

ilias said:

Waylon is right, the trigger will fail when more than one records are inserted / updated... The problem is the

SET @x = (SELECT x FROM INSERTED)

INSERTED will contain multiple records when the insert/update statement affects more than just one record

# July 14, 2009 3:13 AM

serivce said:

UtnMG1 Thanks for the article post.Thanks Again. Cool.

# May 15, 2012 10:50 AM

rosacea skin care products said:

Awesome post. Cool.

# May 29, 2012 7:48 AM

Quality Cookware said:

Fantastic blog article.Thanks Again. Cool.

# June 2, 2012 6:34 PM

quartier des spectacles said:

Thanks a lot for the post.Really looking forward to read more. Keep writing.

# June 7, 2012 2:17 PM

Energy & stamina tips said:

Fantastic article post.Much thanks again. Fantastic.

# June 13, 2012 3:16 PM

debt help said:

Say, you got a nice post.Really looking forward to read more. Fantastic.

# June 20, 2012 2:16 PM

cheap seo services said:

9XqfjP Muchos Gracias for your article post.Thanks Again. Really Cool.

# October 20, 2012 6:44 AM

Madeleine McJones said:

Hello can I check for the column being in #inserted and if it is not there add it to the #inserted?  I have many inserts that may not pass the field I want to fix.  So I want to see if it is there first then add it if it is not.. thanks if you can help

# December 17, 2012 5:57 PM

Cash said:

Fantastic article.Much thanks again. Really Cool.

# January 1, 2013 2:29 PM

health articles for kids said:

I am so grateful for your article post. Great.

# January 1, 2013 6:37 PM

discount evening dresses said:

I really enjoy the post. Awesome.

# January 1, 2013 7:15 PM

los angeles personal injury attorney said:

wow, awesome article.Really looking forward to read more.

# January 2, 2013 3:01 AM

brain games said:

I am so grateful for your blog. Will read on...

# January 2, 2013 3:55 AM

covert hypnosis said:

I appreciate you sharing this blog post.Much thanks again. Fantastic.

# January 2, 2013 7:15 AM

buy noadware said:

Thanks for the blog article.Thanks Again.

# January 2, 2013 9:34 AM

bubble shooter said:

Great blog post.Really looking forward to read more. Really Great.

# January 2, 2013 9:38 AM

acne sus remedios caseros said:

Say, you got a nice blog article.Thanks Again. Will read on...

# January 2, 2013 1:47 PM

Web Site said:

Appreciate you sharing, great blog. Awesome.

# January 2, 2013 3:53 PM

marketing said:

Very informative blog.Thanks Again. Great.

# January 2, 2013 5:59 PM

modelos de alian&#231;as said:

This is one awesome article post.Really looking forward to read more. Awesome.

# January 2, 2013 6:46 PM

work at home tips said:

Awesome article.Much thanks again. Awesome.

# January 2, 2013 9:29 PM

landscape designer said:

Im grateful for the article.Thanks Again. Want more.

# January 2, 2013 10:05 PM

chat random said:

I really liked your article.Much thanks again. Really Cool.

# January 2, 2013 10:54 PM

How to get pregnant said:

Major thanks for the blog post.Thanks Again. Awesome.

# January 3, 2013 1:14 AM

928 s4 said:

Great, thanks for sharing this article.Really looking forward to read more. Much obliged.

# January 3, 2013 1:43 AM

brochure design said:

Awesome blog. Really Great.

# January 3, 2013 2:13 AM

best online betting said:

I think this is a real great post.Thanks Again. Really Cool.

# January 3, 2013 4:34 AM

what to eat when pregnant said:

I am so grateful for your post.Really looking forward to read more. Much obliged.

# January 3, 2013 6:00 AM

Acer Laptop Battery said:

I truly appreciate this article post.Thanks Again. Much obliged.

# January 3, 2013 6:53 AM

top credit cards said:

Great blog.Much thanks again.

# January 3, 2013 7:18 AM

pittsburgh permanent cosmetics said:

Muchos Gracias for your blog. Fantastic.

# January 3, 2013 8:56 AM

NYC Spa Specials said:

Really enjoyed this article post. Will read on...

# January 3, 2013 11:03 AM

psg jersey said:

Really enjoyed this article post.Much thanks again. Keep writing.

# January 3, 2013 11:25 AM

check this out said:

Wow, great article post.Thanks Again. Will read on...

# January 3, 2013 1:11 PM

Marketing said:

Very good blog post.Thanks Again. Awesome.

# January 3, 2013 1:41 PM

ganhar dinheiro extra said:

Thanks again for the post. Really Cool.

# January 3, 2013 3:04 PM

pittsburgh tattoo removal said:

I loved your blog.Really looking forward to read more. Fantastic.

# January 3, 2013 3:15 PM

teaching jobs Indonesia said:

Very informative blog article.Thanks Again. Keep writing.

# January 3, 2013 3:58 PM

trabalho em casa said:

Appreciate you sharing, great blog article.

# January 3, 2013 4:26 PM

dental implants santa rosa said:

Thanks for sharing, this is a fantastic article post.Thanks Again. Cool.

# January 3, 2013 5:22 PM

Acne no more said:

Enjoyed every bit of your post.Thanks Again. Will read on...

# January 3, 2013 5:48 PM

desktop computer said:

Hey, thanks for the blog. Keep writing.

# January 3, 2013 8:28 PM

oil change deptford said:

Very informative blog article.Much thanks again. Really Cool.

# January 3, 2013 9:46 PM

rohnert park iphone cracked screen said:

Thanks for sharing, this is a fantastic article.Really looking forward to read more.

# January 3, 2013 11:40 PM

get started right now said:

Really enjoyed this blog article.Thanks Again. Much obliged.

# January 4, 2013 1:48 AM

social media consultants said:

Im thankful for the article post.Thanks Again. Much obliged.

# January 4, 2013 3:45 AM

Tinnitus Miracle Review said:

Major thankies for the blog article. Really Great.

# January 4, 2013 3:55 AM

soccerlanding said:

I appreciate you sharing this article.Thanks Again. Much obliged.

# January 4, 2013 4:25 AM

easy meals said:

wow, awesome article.Much thanks again. Awesome.

# January 4, 2013 5:35 AM

Super Saddle said:

Major thanks for the article post.Really looking forward to read more.

# January 4, 2013 5:36 AM

Surveyors in London said:

I value the article post.Much thanks again. Awesome.

# January 4, 2013 5:59 AM

seo manchester said:

Im obliged for the blog post. Want more.

# January 4, 2013 12:54 PM

Blutdruck zu hoch said:

Say, you got a nice blog post.Thanks Again. Will read on...

# January 5, 2013 3:26 AM

Chat Random said:

Very good article.Much thanks again. Really Great.

# January 5, 2013 5:02 AM

cheap name tags said:

Im thankful for the blog post.Much thanks again. Cool.

# January 5, 2013 6:02 AM

Anyoption said:

Enjoyed every bit of your blog article.Really looking forward to read more. Much obliged.

# January 5, 2013 7:58 AM

Making Money Online said:

Thanks for the article post.Much thanks again.

# January 7, 2013 9:25 AM

Binary Options Signals said:

I am so grateful for your post.Much thanks again. Fantastic.

# January 7, 2013 11:31 AM

Gold capacitor said:

Im obliged for the blog article.Much thanks again. Want more.

# January 7, 2013 1:36 PM

karen millen sale said:

Great blog article.Much thanks again. Much obliged.

# January 7, 2013 3:40 PM

Last Minute Hotels said:

Awesome article post.Really looking forward to read more. Cool.

# January 7, 2013 4:49 PM

Niagara Falls Tours from Mississauga said:

Thanks a lot for the blog.Much thanks again. Keep writing.

# January 7, 2013 5:59 PM

pesoccerworld said:

This is one awesome article post.Really looking forward to read more. Really Cool.

# January 7, 2013 9:15 PM

soccerpro2013 said:

Really appreciate you sharing this article post. Much obliged.

# January 7, 2013 10:24 PM

computacion said:

I really liked your article.Thanks Again. Really Great.

# January 8, 2013 3:06 AM

webcamsonline said:

Muchos Gracias for your article.Thanks Again. Great.

# January 8, 2013 4:42 AM

Vertigo said:

Thanks again for the article post. Will read on...

# January 8, 2013 5:13 AM

Manhattan apartments said:

Fantastic article post. Great.

# January 8, 2013 7:22 AM

name said:

Thanks again for the blog. Really Cool.

# January 8, 2013 7:43 AM

mediatemple coupon said:

Looking forward to reading more. Great article.Much thanks again. Really Great.

# January 8, 2013 7:56 AM

hotel reservations said:

Fantastic blog.Much thanks again.

# January 8, 2013 8:56 AM

property in gurgaon said:

Really appreciate you sharing this article post.Really looking forward to read more. Awesome.

# January 8, 2013 9:26 AM

Philly`s own Topnotch said:

Thanks so much for the article post.Really looking forward to read more. Great.

# January 8, 2013 11:29 AM

buy Herpeset said:

This is one awesome article post.Much thanks again. Cool.

# January 8, 2013 12:09 PM

Barbershop said:

I truly appreciate this blog article.Thanks Again. Keep writing.

# January 8, 2013 1:19 PM

Lexington Law said:

Very informative blog.Really looking forward to read more. Awesome.

# January 8, 2013 4:11 PM

residences at emerald hill said:

I think this is a real great article post.Really looking forward to read more.

# January 8, 2013 4:37 PM

singapore property said:

wow, awesome article. Cool.

# January 8, 2013 5:52 PM

email marketing said:

I really like and appreciate your blog.Thanks Again. Will read on...

# January 8, 2013 6:49 PM

petal fold envelope said:

Really informative blog post.Thanks Again. Cool.

# January 8, 2013 7:04 PM

personal assistant jobs said:

I am so grateful for your post.Much thanks again. Really Great.

# January 8, 2013 7:34 PM

profollica review said:

Really enjoyed this blog article. Much obliged.

# January 8, 2013 8:21 PM

pest control brooklyn said:

Hey, thanks for the post. Keep writing.

# January 8, 2013 9:37 PM

Prosolution Pills said:

Really appreciate you sharing this blog.Thanks Again. Will read on...

# January 9, 2013 12:29 AM

Energy Deregulation Maryland said:

Say, you got a nice blog post.Much thanks again.

# January 9, 2013 1:45 AM

Final Cut Pro X and Motion 5 Online Resource said:

I really enjoy the blog post.Thanks Again. Much obliged.

# January 9, 2013 3:50 AM

Mixed martial arts said:

Really enjoyed this blog post. Awesome.

# January 9, 2013 8:00 AM

Crowdsourced Websites said:

Major thanks for the article. Really Great.

# January 9, 2013 8:47 AM

Superbike said:

Im obliged for the post. Want more.

# January 9, 2013 10:39 AM

professional resume writing service said:

I really enjoy the blog.Really looking forward to read more. Want more.

# January 9, 2013 10:48 AM

project payday reviews said:

Very good blog post. Really Great.

# January 9, 2013 11:56 AM

coconut toil helps with rashes said:

I truly appreciate this article post.Really looking forward to read more. Really Cool.

# January 9, 2013 12:08 PM

Product Creation said:

Muchos Gracias for your blog. Keep writing.

# January 9, 2013 1:30 PM

buy backlinks said:

I appreciate you sharing this blog article.Really looking forward to read more. Really Cool.

# January 9, 2013 2:56 PM

collier anti aboiement said:

A round of applause for your blog. Awesome.

# January 9, 2013 8:16 PM

further details said:

Looking forward to reading more. Great post.Much thanks again. Really Great.

# January 9, 2013 10:20 PM

Creative toys for children said:

Thanks-a-mundo for the blog post.Really looking forward to read more. Awesome.

# January 9, 2013 10:23 PM

ARSENAL said:

Thanks for sharing, this is a fantastic post.Really looking forward to read more. Really Great.

# January 10, 2013 12:26 AM

questions & answers said:

Im grateful for the article.Really looking forward to read more. Want more.

# January 10, 2013 2:34 AM

Consumer Electronics said:

Muchos Gracias for your blog post.Really looking forward to read more.

# January 10, 2013 4:35 AM

branding company london said:

This is one awesome post. Great.

# January 10, 2013 4:43 AM

zalando-gutschein2013.blogspot.com said:

Very informative blog.Thanks Again. Want more.

# January 10, 2013 6:49 AM

flat tops said:

Thanks again for the blog.Much thanks again. Really Cool.

# January 10, 2013 7:48 AM

Play Online Games said:

Really appreciate you sharing this post.Really looking forward to read more. Keep writing.

# January 10, 2013 8:48 AM

Zalando Gutschein 2013 said:

I appreciate you sharing this article post.Thanks Again. Keep writing.

# January 10, 2013 8:54 AM

Mom Gifts said:

Thanks so much for the blog post.Really looking forward to read more. Want more.

# January 10, 2013 11:37 AM

offbeat incorporated said:

A round of applause for your article.Thanks Again. Awesome.

# January 10, 2013 2:28 PM

Home Inspector Austin said:

I think this is a real great blog post. Cool.

# January 10, 2013 2:52 PM

airport taxi said:

Awesome blog post.Much thanks again.

# January 10, 2013 3:12 PM

commercial window tinting said:

Muchos Gracias for your blog post. Keep writing.

# January 10, 2013 5:33 PM

Home Inspector Orlando said:

This is one awesome post. Cool.

# January 10, 2013 6:43 PM

davido mp3 said:

Really enjoyed this article post.Thanks Again. Awesome.

# January 10, 2013 7:35 PM

Home Inspector Dallas said:

Really informative article. Much obliged.

# January 10, 2013 7:59 PM

fresno online traffic school said:

Great, thanks for sharing this article post.Really looking forward to read more. Much obliged.

# January 10, 2013 9:44 PM

Austin Home Inspection said:

Awesome article post. Will read on...

# January 11, 2013 3:30 AM

buypressuregauge said:

I really liked your post.Thanks Again. Really Cool.

# January 11, 2013 5:26 AM

Review said:

This is one awesome blog article.Thanks Again. Cool.

# January 11, 2013 6:09 AM

furnace cleaning calgary said:

Wow, great blog article.Really looking forward to read more.

# January 11, 2013 6:16 AM

website link said:

I am so grateful for your blog article.Much thanks again. Much obliged.

# January 11, 2013 7:29 AM

Easy Video Suite Review said:

Very informative article. Want more.

# January 11, 2013 8:13 AM

paintball said:

Im thankful for the article.Thanks Again. Really Great.

# January 11, 2013 9:34 AM

does inteligator work said:

Say, you got a nice article.Thanks Again. Much obliged.

# January 11, 2013 10:09 AM

wedding dresses said:

Thanks for the post. Much obliged.

# January 11, 2013 11:08 AM

Acoustic said:

I loved your article.Much thanks again. Keep writing.

# January 11, 2013 12:12 PM

web designer wellington said:

Major thankies for the blog article.Much thanks again. Will read on...

# January 11, 2013 12:18 PM

Epiphone said:

Very good blog article.Really looking forward to read more.

# January 11, 2013 1:33 PM

Web Hosting said:

Thanks so much for the article. Cool.

# January 11, 2013 2:05 PM

live coral for sale said:

Thanks so much for the post. Awesome.

# January 11, 2013 2:55 PM

real fitness naples said:

Im grateful for the post. Great.

# January 11, 2013 5:27 PM

wall stickers uk said:

I truly appreciate this post.Thanks Again. Keep writing.

# January 11, 2013 5:33 PM

Local Experts said:

Great blog.Really looking forward to read more. Really Cool.

# January 11, 2013 5:58 PM

houston tx plumber said:

Thanks for sharing, this is a fantastic blog article. Much obliged.

# January 11, 2013 6:39 PM

wellness center naples said:

Awesome article post.Much thanks again. Awesome.

# January 11, 2013 6:39 PM

Dwg CAD said:

Thanks-a-mundo for the blog.Thanks Again. Really Great.

# January 11, 2013 6:43 PM

tech house said:

Thanks again for the blog post. Awesome.

# January 11, 2013 7:24 PM

Celebrity personal assistant said:

Major thankies for the blog post.Much thanks again. Awesome.

# January 11, 2013 7:53 PM

le vpn said:

Major thankies for the article.Much thanks again. Fantastic.

# January 11, 2013 7:55 PM

fort collins home inspection said:

Very neat blog article.Much thanks again. Great.

# January 11, 2013 10:03 PM

fort collins home inspection said:

Really appreciate you sharing this article post.Much thanks again. Really Cool.

# January 11, 2013 11:22 PM

massage jakarta said:

Really informative post.Thanks Again. Really Great.

# January 11, 2013 11:48 PM

real estate training systems said:

Major thanks for the article.Much thanks again. Cool.

# January 12, 2013 7:08 AM

cape coral remodeling said:

Say, you got a nice blog article.Much thanks again. Keep writing.

# January 12, 2013 9:42 AM

cadastro em sites de busca gratis said:

A round of applause for your article post.Really looking forward to read more. Much obliged.

# January 12, 2013 10:56 AM

How To Unlock A Blackberry 9650 said:

Very informative blog. Really Great.

# January 12, 2013 1:27 PM

Sniper Ghost Warrior 2 Cracked said:

Thanks a lot for the post.Much thanks again. Really Great.

# January 13, 2013 12:06 PM

consumer protection said:

I value the blog.Really looking forward to read more. Really Great.

# January 14, 2013 8:32 AM

Mis-sold PPI said:

Wow, great blog post.Thanks Again. Keep writing.

# January 14, 2013 10:36 AM

winnetka hypothyroid said:

Thanks-a-mundo for the blog article.Much thanks again. Cool.

# January 14, 2013 10:41 AM

Blutdruck Senken said:

A round of applause for your article post.Much thanks again. Really Great.

# January 14, 2013 2:45 PM

lolosbridal said:

This is one awesome article. Cool.

# January 14, 2013 5:06 PM

singapore property said:

I think this is a real great blog.Thanks Again. Want more.

# January 14, 2013 6:51 PM

residences at emerald hill said:

Very good blog.Thanks Again. Really Great.

# January 14, 2013 8:09 PM

Moving to Austin TX said:

Awesome post.Really looking forward to read more. Cool.

# January 14, 2013 9:19 PM

Mega Hoodia Online said:

Thanks a lot for the blog post.Much thanks again. Much obliged.

# January 14, 2013 9:27 PM

Chauvet said:

Hey, thanks for the article post.Much thanks again. Great.

# January 14, 2013 10:01 PM

iphone broken said:

I appreciate you sharing this blog.Thanks Again. Fantastic.

# January 14, 2013 11:41 PM

how to create an app said:

I really enjoy the post.Thanks Again. Cool.

# January 15, 2013 6:59 AM

granuflo lawsuit said:

I appreciate you sharing this post.Thanks Again. Really Great.

# January 15, 2013 9:00 AM

paskolos internetu said:

I am so grateful for your article. Great.

# January 15, 2013 10:08 AM

Fantasy book scifi sci-fi homepage said:

Very informative post. Really Cool.

# January 15, 2013 10:59 AM

click here said:

Very informative article.Thanks Again. Great.

# January 15, 2013 12:32 PM

cheap contact lenses said:

Major thankies for the blog article.Really looking forward to read more. Keep writing.

# January 15, 2013 2:55 PM

sunglasses shop said:

Very neat blog.Really looking forward to read more. Want more.

# January 15, 2013 4:53 PM

blocked drain brisbane said:

I loved your article.Thanks Again. Really Cool.

# January 15, 2013 5:27 PM

help me get a job said:

Thanks again for the article.Much thanks again. Will read on...

# January 16, 2013 12:39 AM

movie t-shirts said:

Major thankies for the article post.Much thanks again. Fantastic.

# January 16, 2013 3:19 AM

Blutdruck Senken said:

Major thankies for the post.Really looking forward to read more. Really Great.

# January 16, 2013 4:13 AM

candy store said:

I think this is a real great post.Really looking forward to read more. Keep writing.

# January 16, 2013 7:42 AM

bluehost coupon reseller said:

Hey, thanks for the blog post.Thanks Again. Keep writing.

# January 16, 2013 7:53 AM

hair extensions said:

Thanks for the article.Much thanks again. Want more.

# January 16, 2013 9:37 AM

TV Show T-Shirts said:

I am so grateful for your article post.Really looking forward to read more. Really Great.

# January 16, 2013 9:46 AM

florianopolis interiores said:

Im grateful for the blog.Thanks Again.

# January 16, 2013 10:46 AM

trendy clothes for women said:

Thanks so much for the article.Thanks Again.

# January 16, 2013 11:19 AM

Drop 5 inches in 2 weeks said:

Im thankful for the post. Cool.

# January 16, 2013 11:56 AM

petaluma ipad repair said:

Looking forward to reading more. Great blog post. Much obliged.

# January 16, 2013 12:33 PM

buy pinterest followers said:

I really liked your blog post.Really looking forward to read more. Will read on...

# January 16, 2013 1:37 PM

ppc management said:

Thanks a lot for the blog article. Will read on...

# January 16, 2013 1:55 PM

agencias de viajes said:

Thanks for the post.Really looking forward to read more.

# January 16, 2013 2:59 PM

http://myplaces.co.nz/ said:

I loved your blog.Really looking forward to read more. Will read on...

# January 16, 2013 4:14 PM

view site said:

Major thanks for the article.Really looking forward to read more. Great.

# January 16, 2013 7:37 PM

weight loss naples fl said:

Thanks again for the blog.Much thanks again. Much obliged.

# January 16, 2013 9:12 PM

scam said:

I really like and appreciate your blog article. Fantastic.

# January 17, 2013 2:28 AM

Justdreams scam said:

I value the blog.Really looking forward to read more. Great.

# January 17, 2013 6:41 AM

Motivasi Kerja said:

Really informative article post.Thanks Again. Much obliged.

# January 17, 2013 7:14 AM

how to find a job in a recession said:

Really informative blog. Much obliged.

# January 17, 2013 7:51 AM

more info said:

Really informative article.Really looking forward to read more. Awesome.

# January 17, 2013 8:59 AM

SLIMLIDA said:

I appreciate you sharing this blog.Much thanks again. Great.

# January 17, 2013 11:00 AM

Optimen said:

Major thankies for the article.Really looking forward to read more. Cool.

# January 17, 2013 11:12 AM

Microblog said:

I really enjoy the post.

# January 17, 2013 12:19 PM

HG Coupon 2013 said:

Thanks so much for the article post.Much thanks again. Really Great.

# January 17, 2013 12:21 PM

stock said:

Really appreciate you sharing this post.Thanks Again.

# January 17, 2013 12:52 PM

how to build muscle fast said:

Great, thanks for sharing this blog post.Thanks Again. Cool.

# January 17, 2013 1:25 PM

buy instagram likes said:

Really appreciate you sharing this blog article.Much thanks again. Cool.

# January 17, 2013 2:45 PM

quick quid said:

Looking forward to reading more. Great article post.Really looking forward to read more. Want more.

# January 17, 2013 4:38 PM

Skype said:

Thanks a lot for the article post. Want more.

# January 17, 2013 6:32 PM

fischen angeln said:

Hey, thanks for the post.Much thanks again. Want more.

# January 18, 2013 12:14 AM

Ange Kagame Images said:

Thanks for sharing, this is a fantastic blog article. Great.

# January 18, 2013 2:08 AM

edinburgh singing lessons said:

I really liked your article post.Really looking forward to read more. Cool.

# January 18, 2013 4:56 AM

Digital Options Brokers said:

Appreciate you sharing, great article.Thanks Again. Great.

# January 18, 2013 5:21 AM

coffee table plans said:

Im grateful for the blog. Keep writing.

# January 18, 2013 8:36 AM

vacante de iarna last minute said:

Really enjoyed this post.Really looking forward to read more. Cool.

# January 18, 2013 9:33 AM

Bal der Bals said:

I truly appreciate this blog.Really looking forward to read more. Really Cool.

# January 18, 2013 10:50 AM

photo effects download said:

Hey, thanks for the blog article.Really looking forward to read more. Really Great.

# January 18, 2013 10:58 AM

trick photography and special effects said:

Thanks for sharing, this is a fantastic blog. Cool.

# January 18, 2013 12:05 PM

kitesurfing hostel tarifa said:

I truly appreciate this post.Really looking forward to read more.

# January 18, 2013 12:09 PM

watch here said:

Thanks so much for the blog article.Really looking forward to read more. Really Cool.

# January 18, 2013 12:48 PM

university BAR ILAN said:

wow, awesome blog article.Much thanks again. Really Cool.

# January 18, 2013 2:43 PM

Google Sniper 2.0 Review said:

I really enjoy the post.Thanks Again. Want more.

# January 18, 2013 2:54 PM

PUA Routines Manual said:

Great, thanks for sharing this blog post.Really looking forward to read more. Want more.

# January 18, 2013 3:13 PM

printing company said:

Enjoyed every bit of your blog. Really Great.

# January 18, 2013 6:38 PM

cheap instagram followers said:

I really like and appreciate your blog. Much obliged.

# January 18, 2013 9:22 PM

prostate cancer cure said:

Say, you got a nice blog post.Much thanks again. Great.

# January 19, 2013 12:06 AM

chicco cortina travel system said:

Fantastic blog post.Much thanks again. Will read on...

# January 19, 2013 1:26 AM

chiropractor green bay wisconsin said:

Thanks again for the blog post.Much thanks again. Much obliged.

# January 19, 2013 4:07 AM

wordpress said:

I really liked your blog.Thanks Again. Want more.

# January 19, 2013 5:24 AM

24 hour towing said:

Really appreciate you sharing this post.Thanks Again. Really Great.

# January 19, 2013 6:52 PM

social networks said:

This is one awesome article post.Thanks Again. Keep writing.

# January 20, 2013 3:22 AM

http://chatrandom.com/multichat/ said:

A round of applause for your article.Thanks Again. Really Great.

# January 20, 2013 7:56 AM

uk payroll services said:

I appreciate you sharing this post.Thanks Again. Will read on...

# January 20, 2013 10:36 AM

walrus said:

Thanks-a-mundo for the article post.Thanks Again. Want more.

# January 20, 2013 12:04 PM

chat said:

Great, thanks for sharing this blog article.Much thanks again. Keep writing.

# January 20, 2013 2:45 PM

gate valve supplier said:

Awesome blog post.

# January 20, 2013 6:22 PM

ceramic mosaic said:

I am so grateful for your article post.Thanks Again. Fantastic.

# January 20, 2013 7:35 PM

kits u&#241;as de gel said:

Thanks again for the blog article.Really looking forward to read more. Great.

# January 21, 2013 7:15 AM

Ripley said:

Hi there just wanted to give you a quick heads up.

The text in your article seem to be running off the screen in Opera.

I'm not sure if this is a formatting issue or something to do with browser compatibility but I thought I'd post to let you know.

The design look great though! Hope you get the

problem solved soon. Thanks

# January 22, 2013 8:57 AM

www.datacollec.com said:

A round of applause for your blog post.Much thanks again. Will read on...

# January 22, 2013 9:38 AM

podr&#243;&#380;e afryka said:

Great blog.Much thanks again. Will read on...

# January 22, 2013 1:01 PM

Windows 9 said:

I am so grateful for your blog.

# January 22, 2013 2:08 PM

payday uk said:

Major thankies for the article. Will read on...

# January 28, 2013 7:39 AM

random chat said:

Major thanks for the blog.Much thanks again. Really Cool.

# January 29, 2013 10:45 AM

Google Sniper said:

I am so grateful for your article.Much thanks again. Will read on...

# January 30, 2013 4:51 PM

How to get your ex boyfriend back said:

Really informative article post.Thanks Again. Really Cool.

# January 30, 2013 6:00 PM

daily said:

Thanks-a-mundo for the article post. Will read on...

# January 30, 2013 9:31 PM

pills for weight loss said:

SNFq1a I really liked your article. Want more.

# February 1, 2013 8:12 AM

Spiderman Comics said:

Im grateful for the blog article.Really looking forward to read more. Really Great.

# February 4, 2013 3:27 AM

Pregnancy Photography Birmingham said:

Great article.Thanks Again. Keep writing.

# February 5, 2013 1:08 PM

wedding photographer north east said:

This is one awesome blog.Thanks Again. Awesome.

# February 5, 2013 3:30 PM

website traffic promotion said:

Looking forward to reading more. Great blog.Really looking forward to read more. Want more.

# February 5, 2013 4:24 PM

Zippo Limited Edition said:

Really appreciate you sharing this blog article.Really looking forward to read more. Will read on...

# February 5, 2013 5:20 PM

como ganhar dinheiro said:

I truly appreciate this post. Much obliged.

# February 7, 2013 12:54 PM

programa de afiliados said:

Thanks-a-mundo for the article post.Much thanks again. Great.

# February 7, 2013 3:26 PM

pell grants said:

Hey, thanks for the article post. Really Great.

# February 7, 2013 5:56 PM

Red said:

Thanks for info , helped a lot !

# February 7, 2013 9:36 PM

filmy online said:

Fantastic post. Fantastic.

# February 7, 2013 11:05 PM

desene animate said:

I loved your article. Keep writing.

# February 8, 2013 2:50 AM

filme online gratis said:

I really enjoy the article post.Really looking forward to read more. Want more.

# February 8, 2013 4:04 AM

Columbus said:

I am so grateful for your blog article.Thanks Again. Fantastic.

# February 17, 2013 9:07 AM

online property auctions said:

Great blog article.Much thanks again. Keep writing.

# February 22, 2013 7:08 AM

Horse Riding SD said:

Wow, great blog post. Really Great.

# February 22, 2013 8:24 AM

http://www.dobrypit.pl said:

This is one awesome blog article.Really looking forward to read more. Cool.

# February 22, 2013 10:57 AM

pomodoro technique said:

Great blog.Much thanks again.

# February 22, 2013 12:14 PM

Tinnitus Miracle said:

Thanks so much for the article.Much thanks again. Cool.

# February 22, 2013 1:27 PM

ganhar dinheiro pela internet said:

Wow, great blog post.Much thanks again. Will read on...

# February 22, 2013 2:41 PM

Beaulieu said:

Simply want to say your article is as amazing.

The clarity in your post is just cool and i can assume you are

an expert on this subject. Fine with your permission let me

to grab your RSS feed to keep updated with forthcoming post.

Thanks a million and please carry on the gratifying work.

# May 3, 2013 12:51 AM