Wednesday, February 17, 2010

Speeding Ticket North Carolina

I. DO NOT HIRE AN ATTORNEY

The day after your ticket, you will receive about 30 advertisements in the mail for an attorney to take care of your ticket. If it's just your first simple speeding ticket, you aren't going to need one.

II. SAVE YOUR PRAYER FOR JUDGEMENT

You'll want to save your 'prayer for judgement' for a ticket that cannot be lowered, like a stop sign or red-light ticket.

III. THE PROCESS

You show up at the courthouse on the "Court Day Assigned" and wait in a line. If you get there before 9:00 a.m. the line is short. There are a couple of District Attorneys at the end of the line, figuring out if it's even worth it to go to trial. Tell them that you are not guilty and would be willing to plea it down. Make sure they give you no more than 9 miles per hour over the speed limit. The court gets their money, the DA gets a guilty plea, and you get off without an increase in insurance premium.

MAKE SURE TO BRING CASH WITH YOU! There's a ATM at the court house but you may be charged a fee.

Ticket for $160 became $145

CO FAC FEE D CR - $12.00
OFF FEES-AP - $5.00
FINES - $15.00
DC-CRIM FEES - $92.50
DC-CR IDA FEES - $3.00
LEOB & RF - ST - $7.50
LEO TRNG & CERT - $2.00
JUD PHONE FEE - $3.00
VEHICLE VIO FEE - $5.00




.

Replace Single Quotes SQL Stored Procedure User Defined Function

Create a User Define Function in SQL:

****************************************************************
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[CleanQuotes] (@string VARCHAR(500))
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE @return BIT
DECLARE @position INT
SET @position = 1

DECLARE @output VARCHAR(500)
SET @output = ''

DECLARE @finalOutput VARCHAR(500)
SET @finalOutput = ''

DECLARE @singleQuoteCount INT
SET @singleQuoteCount = 0

WHILE @position <= DATALENGTH(@string) BEGIN IF ASCII(SUBSTRING(@string, @position, 1)) = 39 SET @singleQuoteCount = @singleQuoteCount + 1 ELSE SET @singleQuoteCount = 0 IF @singleQuoteCount <= 1 SET @output = @output + SUBSTRING(@string, @position, 1) IF @position > DATALENGTH(@string)
GOTO ProcessBackQuote
ELSE
SET @position = @position + 1

END

SET @output = REPLACE(@output, Char(39), Char(96))

ProcessBackQuote:

SET @position = 1
SET @singleQuoteCount = 0

WHILE @position <= DATALENGTH(@output) BEGIN IF ASCII(SUBSTRING(@output, @position, 1)) = 96 SET @singleQuoteCount = @singleQuoteCount + 1 ELSE SET @singleQuoteCount = 0 IF @singleQuoteCount <= 1 SET @finalOutput = @finalOutput + SUBSTRING(@output, @position, 1) IF @position > DATALENGTH(@output)
GOTO ExitUDF
ELSE
SET @position = @position + 1

END

ExitUDF:
RETURN @finalOutput

END
****************************************************************

Use the function to replace the quotes in fields:


UPDATE TABLE_NAME SET FIELD_NAME = dbo.CleanQuotes(FIELD_NAME);





.

Check This Out!

More Links to Good Information