Get Over 1,000 TV Channels on Your Computer

Are you looking to save some cost? You might want to consider getting rid of your expensive cable bill, and instead switch to livetv4me.com.This service will allow you to watch television right from your computer. You have no monthly fees, no contracts and no hardware to install. You can begin watching television from your computer in minutes. You only need to pay a one time payment of $39.95. In this recession, it is important to find ways to cut costs. You can get over 1,000 channels with a one time fee of 39.95 which beats any cable bill.It is easily down loadable, and you can watch programs from all over the world. This program is completely legal and doesn't rely on any illegal boxes, or pirated content. This program works anywhere in the world just as long as you have an Internet connection, and it will work with any type of Internet connection. So what are you waiting for? If you are looking to save some money on your cable bill, you might consider switching to livetv4me.com today. If you have any questions about it, you can contact a live person from their website. You check them out today so you can start saving.

Read more...

Pull Integer From String in SQL

Sometimes you find it necessary to pull Integers from a String. Instead of parsing the value, you can use this SQL function to pull an Integer value from a String. You just need to create this function using your Enterprise Manager, and call the function like this:
select dbo.GetIntegerFromString_GD("abc123") .

You will get returned 123.



CREATE FUNCTION dbo.GetIntegerFromString_GD
(@S varchar(100))
RETURNS INT
AS
BEGIN

Declare @result varchar(100)
set @result=''


select
@result=@result+case when number like '[0-9]' then number else '' end from
(
select substring(@s,number,1) as number from
(
select number from master..spt_values where type='p' and number between 1 and len(@s)
) as t
) as t


RETURN ( select @result as only_numbers )
END

Read more...

Accor Hotels 3-Day Super Sale Asia Pacific

Are you getting ready to travel for the holidays? You might want to check out the Accor Hotels 3-Day Super Sale Asia Pacific for great deals on hotels. All kinds of travelers are able to take advantage of these savings when they book online between 27 – 30 October 2009. They will be having one million room nights that will be on sale as low as $30 US per night. You can get great deals for many different countries such as Australia, Bali and South Korea. You can also get deals in Malaysia, Japan and New Zealand. You can make these reservations for the period of December 2009 through April 2010. This might come in handy for me since my family is planning on traveling shortly. If you are a AIClub member, you can earn points on all of your Super Sale Bookings. If you area a Accor Advantage Plus member, you are entitled to a 10% discount on all Super Sale rates. So what are you waiting for? If you are looking for a great website to get great deals on hotels when you travel, you need to checkout accorhotels.com today. You want to hurry before you miss their great sale.

Read more...

Using the Replication Manager SQL Server 2000

The SQL Replication Manager is used to copy data from one database to another.

You can use the SQL Replication Manager to either push or pull data to or from another database.

If you currently use the Replication Manager and you want to add tables to it, you first will need to remove it and recreate it.

Removing the Replication

1) Select the Database Name (that does not say local) and Select the Tools Menu->Replication->Disable Publishing.

2) Follow the steps to disable the publishing. The Replication Monitor folder should disappear.

3) Now you need to remove all the publications and subscriptions pointing to this replication.

a) Locate all servers that might be using this Replication and open the Replication Folder.

b) Select the Publications folder and Subscriptions folder. If you see any items listed in these two folders, you will need to remove them. To remove them, open query analyzer and run this store procedure exec sp_removedbreplication '' where “DB Name Here” is the name of the database listed under the Database column for the subscriptions or publications. Refresh the database and verify that the Publication and Subscription has been removed.

4) Your replication has been removed.

Adding Replication


1) You might want to drop all the tables first before replicating.

2) Select the database and select tools->Replication->Create and Manage Publications

3) At the publication wizard select Next after selecting show advanced options

4) Select your database and press next.

5) Select snapshot and press next, Press Next, Select No, Subscribers receive data directly and press Next.

6) Select Servers running SQL server 2000 and press next

7) Select the tables you will need to copy over to the new database.

8) Name the publication

9) Select No, create the publication as specified and press next

10) Select Finish and you should see SQL Server Enterprise Manager successfully etc... Press Close

11) You will now be forwarded to create the subscription. Select Push subscription. This subscription will push the data over to the new database as it duplicates the data.

12) Select the name of your server and press Next.

13) Run the agent at the Distributor and select next

14) Select Using the following schedule and change it to say Occurs once at 12:00AM every day (or when ever yoiu need the data copied) press next

15) Select Yes, initialize the schema and data and press next

16) Press next

17) Press finish

18) Verfiy that the tables from step 7 are created and populated in the new database. If the tables aren’t there, you might need to select the Distribution Agents, and right mouse button on the Distribution Agent and select start. Refresh the database and you should see the tables created and populated with data.

Read more...

Celebrate the holiday season at the Hilton Promenade at Branson Landing and Hilton Branson Convention

There are many exclusive packages that you can find at Hilton Promenade at Branson Landing and Hilton Branson Convention Center Hotel. Here are some exclusive packages they offer:

It’s a Wonderful Life, starting at $329 per night and running from Nov 15 thru Dec 23:
- experience the ultimate holiday getaway for shopping, relaxation and entertainment
- loaded with discounts at dozens of shops and restaurants along with a treatment at Aspire Medical Spa.

Santa’s Coming to Town Package, starting at $189 per night and running from Friday thru Sunday Nov 15 thru Dec 23:
- Story Time with Mrs. Claus in the lobby of the Hilton Branson Convention Center Hotel
- little ones will enjoy Story Time with Mrs. Claus in the lobby
- Santa himself will deliver presents, cookies and milk to guest’s rooms

Polar Express Package starting at $289 for a family of four. The train runs Thursday to Sunday beginning Friday, Nov 6th :
- includes deluxe accommodations, first-class excursion on the Polar Express with dining car seating, hot cocoa and cookies along with a souvenir ceramic mug.
- Advance reservations are required and additional tickets are available at $49.00 per adult and $39.00 for children ages 2-12.

For more exclusive rates, you should visit them today for details.

Read more...

21 Laws of Computer Programming

I found this Computer Programming Laws at devtopics.com which I thought was pretty funny.

1. Any given program, once deployed, is already obsolete.
2. It is easier to change the specification to fit the program than vice versa.
3. If a program is useful, it will have to be changed.
4. If a program is useless, it will have to be documented.
5. Only ten percent of the code in any given program will ever execute.
6. Software expands to consume all available resources.
7. Any non-trivial program contains at least one error.
8. The probability of a flawless demo is inversely proportional to the number of people watching, raised to the power of the amount of money involved.
9. Not until a program has been in production for at least six months will its most harmful error be discovered.
10. Undetectable errors are infinite in variety, in contrast to detectable errors, which by definition are limited.
11. The effort required to correct an error increases exponentially with time.
12. Program complexity grows until it exceeds the capabilities of the programmer who must maintain it.
13. Any code of your own that you haven’t looked at in months might as well have been written by someone else.
14. Inside every small program is a large program struggling to get out.
15. The sooner you start coding a program, the longer it will take.
16. A carelessly planned project takes three times longer to complete than expected; a carefully planned project takes only twice as long.
17. Adding programmers to a late project makes it later.
18. A program is never less than 90% complete, and never more than 95% complete.
19. If you automate a mess, you get an automated mess.
20. Build a program that even a fool can use, and only a fool will want to use it.
21. Users truly don’t know what they want in a program until they use it.

Read more...

Paid Reviews

Join here to get paid reviews!

Read more...

Search Engine Ranking Software

If you are looking to improve your website’s ranking, you might want to checkout the SEO Tools. You can track key stats like backlinks and page indexed by Google, Yahoo, and MSN. You will be able to spot trends easily and quickly. You can also create all kinds of reports either daily, weekly, or on a monthly basis. You can easily track your Page Rank and Technorati Rank to help improve your website’s visibility. This software is very easy to use, and can give you detailed reports on competitive tracking, and keyword ranking. You can also research keywords with ease on multiple platforms. You also will have a user friendly snapshot dashboard. This is one of the easiest and least expensive ways to improve your ranking online. With millions of websites on the web, it is very important for you to monitor your site’s performance. Your search engine optimization needs constant maintenance, and this exciting software can help you to find the places that you need to improve to make your website more visible. So what are you waiting for? If you are looking for way to improve your sites visibility and search engine ranking, you need to checkout this SEO Tool today.

Read more...

Advanced mySQL and SQL 2000 Queries, Using Pointers

There are some more advanced queries you can do using SQL and mySQL. Below I discuss the case statement, unions, intersections, and creating a pointer to a column in a database using a Cursor.

1) Adding a condition to your query using the Case Statement:

select * from book
where case BookAuthor
when 'Tracy' then 'T'
when 'Bob' then lower(BookAuthor)
end like '%T%'

This query is using a case statement. The case statement allows you to put a condition in your query. You can't use the case statement in the enterprise manager in SQL, but you can use it in the query analyzer, views or stored procedures.

This statement says that when the BookAuthor is Tracy, return a T and when BookAuthor is Bob, then return the lower case BookAuthor column. That will just return what you want from the column, and then you can add the like condition to check if your case statement has a T in it. This can be handy when you are doing complex querys without using a stored procedure. The % is a wild card and means that anything can be before the T and anything can be after the T.

2) Using a Union Command:

select BookName as name from book
union
select FirstName as name from users

A union returns anything that is either in the book table or the users table, but not in both tables. The union is checking the book name from book table and the first name from the users table and returns only the rows that are not contained in both tables. You have to have the same number of columns in each select statement with the same name or alias.

3) Using an Intersection Command:

There isn't a command called insersection. An insersection is something that is contained in both tables. You can do an intersection using a sub query.

select id from book where
id in (select bookid from userbook)

This query checks the id and returns only the id's that are contained in the userbook table. The column in the subquery has to be one column.

If you want to return the items not contained in the userbook table, you can put a not before the in to say return the ids that are not in the userbook table.

4) Updating a column from data contained in another table

This is a handy query that I have only tested in SQL. I basically needed to retrieve data from a table and place that data into a specific column in the database in another table. This query will create a pointer to the gls_objective column and get all of the descriptions based on the id, add them together, add some break points CHAR(10), and set that description variable @description into the gls_objective column.

Declare ObjectiveCursor Cursor
For
Select OBJ_description,OBJ_goalGUID from Objectives order by obj_goalguid
Open ObjectiveCursor
Declare @goalid uniqueidentifier
Declare @description varchar(1024)
declare @ptr VARBINARY (16)
Fetch Next From ObjectiveCursor Into @description, @goalid
While @@Fetch_Status = 0
Begin
select @ptr=TEXTPTR(gls_objective) from goals where gls_goalguid=@goalid
set @description=@description+CHAR(10)+CHAR(10)
UPDATETEXT goals.gls_objective @ptr null null @description
Fetch Next From ObjectiveCursor Into @description, @goalid
End
Close ObjectiveCursor
Deallocate ObjectiveCursor

Read more...

6,000 Movies and Shows to Watch Anytime You Want

Are you a member of Charter? Did you know that if you have Charter digital, you also have On Demand which is free? You are able to watch over 6,000 movies and shows anytime you want. You are able to watch many of the big shows such as 30 Rock and The Office if you have missed a prior episode. My daughter demands to watch Spongebob, and it is nice to have it right there on our finger tips. It is very easy to llearn more at charter.net/ondemand because you can get information just by visiting their website. You can also get updates and fun extras on Charter’s Facebook page. There are many shows that you might want to check out on Charter such as Turning Point, Machida vs. Shogun and Bound for Glory. You can get Cable and High Speed Internet using Charter. You might also be interested in one of their bundles. You also might qualify for a free wireless router, free cable modem and free multimedia package. They also are offering $150 rebate. So what are you waiting for? If you are looking for the best place for movies and shows, you might want to checkout Charter’s On Demand.

Read more...

Linked Server SQL using OpenQuery

If you are trying to find out how to link databases, you might consider creating a linked server. In SQL 2000, you can select the security folder in the Enterprise Manager where you will see a Linked Server option. Select the right mouse button on the linked server and select "new linked server". Type in the name of the other server you want to link to. To query on a linked server, you will use the OpenQuery command.

SELECT * FROM OPENQUERY(servername, 'select * from databasename.dbo.tablename')

the openquery command will query the other server. You will input the server name, and the query that will be used to access the other server.

Read more...

Free Auto Insurance Quotes

In these difficult times, it is important to find ways to cut cost. One place to try and save some money is with your auto insurance. I have found this cool website that can easily give you an auto insurance quote. You should visit PremiumAutoInsurance.net because they might be able to give you a competitive auto insurance quote to help you save some money. What you should do to get some Free Auto Insurance Quotes is to visit the website and first start filling out the forms. I was able to save about $100 on my auto insurance. My quote is from Nationwide Insurance. They quoted me $250/$500 of liability coverage. They also included $100,000 of property damage and $25,000 of medical coverage. The quote also includes $250/$500 of uninsured motorist. They also have included 500 comprehensive and 500 of collision coverage. The company also has rental reimbursement coverage for $30 dollars per day. With all of these coverages, I will only pay $122 dollars a month which is about $100 cheaper than my current policy. So what are you waiting for? Before shopping around for auto insurance, you should checkout PremiumAutoInsurance.net to get your free quote. You might be able to save some money too.

Read more...

Java PermGen Space Out of Memory Error Using Tomcat as a Service

Many people experience an out of memory error using Java with Tomcat.

Tomcat defaults the memory that is reserved for Java to --JvmMs 128 --JvmMx 256.

If you receive an out of memory error, then you need to adjust these values.

If you are using Tomcat as a service, you need to change these parameters in the service.bat file. In the version Tomcat 5.527, locate this line in the service.bat file: --JvmMs 128 --JvmMx 256. You can change these values to increase the Java Heap Space in Tomcat.

You will need to uninstall the service, and reinstall it to make these values take effect. After you have changed these values and reinstalled the service, open up your tomcat5w.exe located in your bin directory, and you should see the size of your heap space set to the values you inputted in your service.bat file.

Changing the values directly in the Tomcat5w.exe file didn't seem to work for this version of Tomcat without changing it in the service.bat file and reinstalling the service.

However, if you are using Tomcat 5.0.28, changing the Initial memory pool and Maximum memory pool in the Tomcat5w.exe and restarting the service does work. (You do not have to change it in the service.bat file and reinstall the service)

Read more...

Celebrate the holiday season at Branson, Missouri

Read more...

SQL Sorting By String That Contains WBS

I had an issue where we had strings that contained a wbs number in front of it. Not all of the strings contained a wbs however. I was trying to sort the strings correctly if they contained a wbs number. The wbs would be a list like this:

1.1,1.2,1.3,1.4,1.5,1.6,...,1.11

This list should put the 1.11 after 1.10 and 1.9, however, it was putting the item after 1.1 if I just sorted by the name.

My solution is listed below. It will first check if the first character is a number. If it isn't a number, it will add the ascii characters (since
the case statement requires an integer in this case) for the first two characters in the string and sort by that.

If it does contain a number, then I assume that it is a wbs number. I also assume that the wbs number will not go 3 levels deep. If that is the case, this solution won't work. This solution will only work if the wbs number is 2 levels deep and you don't need to alpha sort past 2 characters in the name.

If it has a wbs number, I will parse it up and sort on the first number, and then the second number.

Usually you would want an order id in the database to sort it correctly, but in this case we didn't have that option.

SELECT distinct
case isnumeric(substring(deliverablename,0,2)) when 1
then cast(substring(deliverablename,0,2) as int) else cast(ascii(deliverablename) as int)+
cast(ascii(substring(deliverablename,1,2)) as int) end as nodecimal ,
case isnumeric(substring(deliverablename,0,2)) when 1 then
cast(substring(deliverablename,0,CHARINDEX('.',deliverablename,1)) as int)
else cast(ascii(deliverablename) as int)+ cast(ascii(substring(deliverablename,1,2)) as int)
end as firstdecimal , case isnumeric(substring(deliverablename,0,2)) when 1 then
cast(substring(deliverablename,CHARINDEX('.',deliverablename,1)+1
,CHARINDEX(' ',deliverablename,1)-CHARINDEX('.',deliverablename,1)) as int)
else cast(ascii(deliverablename) as int)+ cast(ascii(substring(deliverablename,1,2)) as int)
end as seconddecimal, userdefinedfixedfeeid,budgetfixedfeedate,deliverablename,
budgetfixedfee.fixedfeeid,deliverableamount FROM FixedFeeSchedule INNER JOIN
BudgetFixedFee ON FixedFeeSchedule.FixedFeeID = BudgetFixedFee.FixedFeeId
INNER JOIN RevisionHistory ON BudgetFixedFee.BudgetId = RevisionHistory.BudgetId
AND RevisionHistory.RevisionNum = 0 INNER JOIN Budget ON FixedFeeSchedule.CustomerId =
Budget.CustomerId AND FixedFeeSchedule.EngagementID = Budget.EngagementId AND
BudgetFixedFee.BudgetId = Budget.BudgetId INNER JOIN Project ON FixedFeeSchedule.CustomerId =
Project.CustomerId AND Budget.ProjectId = Project.ProjectId left outer JOIN Tasks
ON Project.CustomerId = Tasks.CustomerId AND Project.EngagementId = Tasks.EngagementId AND
Project.ProjectId = Tasks.ProjectId AND BudgetFixedFee.FixedFeeId = Tasks.FixedFeeId and
tasks.deleted=0 left outer JOIN TaskAssignment ON Tasks.TaskId = TaskAssignment.TaskId
AND Tasks.CustomerId = TaskAssignment.CustomerId AND Tasks.EngagementId = TaskAssignment.
EngagementId AND Tasks.ProjectId = TaskAssignment.ProjectId and TaskAssignment.deleted=0
left outer JOIN Resources ON TaskAssignment.ResourceId = Resources.ResourceId left outer
join resourcerate rr on rr.resourceid=taskassignment.resourceid and rr.active=1 and
rr.effectivedate=(select isnull(max(rrra.effectivedate),0) from ResourceRate rrra
INNER JOIN Resources rcas ON rrra.ResourceId = rcas.ResourceId and rcas.resourceid=
rr.resourceid and rrra.active=1) WHERE (BudgetFixedFee.CopyTo IS NULL) AND
(FixedFeeSchedule.Deleted = 0) AND (BudgetFixedFee.Deleted = 0)
AND (Budget.ProjectId = '{307B2997-5F01-4E27-8E6B-25BEC20EAF27}')
AND (Budget.Deleted = 0) order by case isnumeric(substring(deliverablename,0,2))
when 1 then cast(substring(deliverablename,0,2) as int) else cast(ascii(deliverablename) as int)
+ cast(ascii(substring(deliverablename,1,2)) as int) end,
case isnumeric(substring(deliverablename,0,2)) when 1 then
cast(substring(deliverablename,0,CHARINDEX('.',deliverablename,1)) as int)
else cast(ascii(deliverablename) as int)+ cast(ascii(substring(deliverablename,1,2)) as int)
end, case isnumeric(substring(deliverablename,0,2)) when 1 then
cast(substring(deliverablename,CHARINDEX('.',deliverablename,1)+1,
CHARINDEX(' ',deliverablename,1)-CHARINDEX('.',deliverablename,1)) as int)
else cast(ascii(deliverablename) as int)+ cast(ascii(substring(deliverablename,1,2)) as int)
end

Read more...

Thousands of Dogs and Cats Available for Adoption

Are you a pet lover? Petango.com is an organization that is dedicated in helping homeless pets find loving homes. You might want to check them out to see the animals that are up for adoption. You can become a follower of Petango on twitter at www.twitter.com/petangopets and facebook at www.facebook.com/petango. If you want to adopt a cat, you can visit Petango.com - Adopt a cat! You can start to adopt a cat simply by visiting the Petango website. You can use their powerful search engine to look for the pet that you are looking for. You can then use the contact information to contact the person who is giving the pet up for adoption. Maybe you want to adopt a dog, so you should visit Petango.com - Adopt a dog today!! They are an animal control office that is interested in compassion and compliance when it comes to the pets. They also have a caring staff that loves animals. So what are you waiting for? If you are looking for a new pet, this should be the first website you should visit. You can look for all types of pets from their website. So if you are interested to adopt a pet, you should visit Petango.com today.

Read more...

Halloween Adventure

Are you looking to get involved in the best Halloween Adventure? Now that Halloween has begun, so has Jack's Quest. Jack is looking for the Best Halloween Adventure where you could win some fabulous prizes. What you want to do is to submit your stories, pictures or videos which will automatically give you a shopping discount and you could be eligible for more prizes. Everybody will be able to vote on the best entry and Jack will give away over 100 prizes to the top ranked adventures. It is easy to join. You can create a login at Jack’s website, and start submitting your stories or videos right away. You can post a “Vote for me button” on your blog or website to get people to vote for you. You also might want to put it on your MySpace page or FaceBook profile. Jacks Quest started September 7th and will end on October 25th so you better hurry and enter your photos and videos today. This contest will start again on November 5th for the 2010 contest. So what are you waiting for? If you are looking to win some great cash prizes, you need to checkout Jack’s website today before it is to late.

PRESS RELEASE:

"Coming this fall - Jacks Quest. Let the Halloween Adventure begin!:

Boothwyn, September 7th, 2009 - Halloween Season has begun, and so has Jack’s Quest for the Best Halloween Adventures. Anyone who is looking to spice up their fall season and win some fabulous prizes need look no further. Jack, the hip, young spokes character from Halloween Adventure, invites Americans to join his Quest and to share their individual Halloween adventures. Whether these adventures involved a child’s first Halloween, a terrifying Haunted House, or even the look of surprise on a boss’ face when he saw an employee clock in to work in a gorilla suit, Jack wants to know about them.

Everyone who joins Jack's Quest, by submitting their stories, pictures, or videos, will be automatically rewarded with a shopping discount and will be eligible to win even more prizes. Everyone can help Jack choose winning entries by voting on the adventures; everyone is a judge in this Quest. And because Jack is taking the Quest seriously, he is giving out over 100 prizes to the top ranked adventures chosen by YOU!

Read more...

Installing SVN (Subversion) Eclipse Plugin

These are the step to install subversion's plugin for eclipse Ganymede.


1) To download SVN eclipse plugin, go to the help menu in eclipse and select software update.
Select the available software tab and remove the text from the filter textbox that says, "type filter text" and type C. It is possible you need to press the refresh button. Select the eclipse C/C++ Development Tools and press the install button. Press next, accept the license and press finish.

Go to the Software Update site again, and select available software. Select Add Site and paste this URL in it. http://www.polarion.org/projects/subversive/download/eclipse/2.0/update-site/

You should also add this site: http://subclipse.tigris.org/svn/subclipse/

Now go back to the filter text box and type subversion. Select the Ganymede which will install all the subversion files below it. Press the install button and press finish.


Press the subversion SVN connector sources and install all of the binaries below it.


Restart eclipse.


If you get this error when checking out a project using this plugin, it is because you need to add the www.polarion.org site that I stated above.
SVN: '0x00400006: Validate Repository Location' operation finished with error: Selected SVN connector library is not available or cannot be loaded.


To test subversion when eclipse is loaded, select File->New->Project->SVN->Project from SVN
paste this url in the URL text box. http://subclipse.tigris.org/svn/subclipse/
and press next. The user name is guest, and password is left blank. You will see trunk, branches and tags display in the console. That will tell you that your subversion is working correctly.

If you get this error when loading eclipse: Caused by: java.io.UTFDataFormatException: malformed input

You might need to remove the projects from your workspace, and import the projects over again.

Read more...

Update Your Look Before You Update Your Resume

Did you know that there was a study of over 500 HR professionals that said 84% of HR professionals agree that well-groomed employees climb the corporate ladder faster than those who are not well-groomed? It is a well known fact that grooming standards are very important in the workplace which can even be even more important than a firm handshake. Gillette even discussed this issue with expert Mark Jeffries and GQ style correspondent, Brett Fahlgren who both agree that grooming is very important. You can see their comments by visiting the Gillette Career Advantage website. Gillette launched this website to provide tools, advice and information to help people become competitive in the job market. You might also want to take the Gillette Career Quiz and read through the Hire Guide to see what other HR professionals really think. If you want to checkout some of the Gillette products to improve on your grooming standards, you might want to checkout the Gillette Resource Center. They have all kinds of items such as anti-dandruff shampoo, antiperspirant/deodorant blades and many more items. So if you are looking to get ahead in the work place and want to improve on your grooming standards, you should checkout the Gillette’s websites today.

Read more...

Calculate Working Days in SQL

This is a function that will allow you to calculate working days between two dates. A working day is a day that isn't a weekend. It does not subtract any holidays.

CREATE FUNCTION dbo.GetWorkingDays_GD
( @StartDate datetime,
@EndDate datetime )
RETURNS INT
AS
BEGIN

DECLARE @i INT
DECLARE @WorkDays INT
DECLARE @DaysNo INT
DECLARE @DatePivot DATETIME



SET @i = 0
SET @WorkDays = 0
SET @DaysNo = DATEDIFF(DD, @StartDate, @EndDate) +1

WHILE @i <= @DaysNo - 1
BEGIN
SET @DatePivot = DATEADD(DD, +@i, @StartDate)

IF DATENAME(DW, @DatePivot) NOT IN ('Saturday', 'Sunday') SET @WorkDays = @WorkDays + 1

SET @i = @i + 1
END

RETURN ( @WorkDays )
END

Read more...

you can save with premiumautoinsurance.net

In these difficult times, it is important to find ways to cut cost. One place to try and save some money is with your auto insurance. I have found this cool website that can easily give you an auto insurance quote. You should visit PremiumAutoInsurance.net because they might be able to give you a competitive auto insurance quote to help you save some money. What you should do to get some Free Auto Insurance Quotes is to visit the website and first start filling out the forms. I was able to save about $100 on my auto insurance. My quote is from Nationwide Insurance. They quoted me $250/$500 of liability coverage. They also included $100,000 of property damage and $25,000 of medical coverage. The quote also includes $250/$500 of uninsured motorist. They also have included 500 comprehensive and 500 of collision coverage. The company also has rental reimbursement coverage for $30 dollars per day. With all of these coverages, I will only pay $122 dollars a month which is about $100 cheaper than my current policy. So what are you waiting for? Before shopping around for auto insurance, you should checkout PremiumAutoInsurance.net to get your free quote. You might be able to save some money too.

Read more...

Add Attachment in Java

This is sample code to create an attachment using Java. You will use the Java Mail API to create attachments. The addAttachments method is the method you will use to create the attachments. You will pass in an array of paths that contain the location of your attachments, and Java will create the attachments for to send in the email.

import javax.mail.*;
import javax.mail.internet.*;
import javax.activation.*;
import java.io.*;
import java.util.Properties;
public class MailClient
{
public void sendMail(String mailServer, String from, String to,
String subject, String messageBody,
String[] attachments) throws
MessagingException, AddressException
{
// Setup mail server
Properties props = System.getProperties();
props.put("mail.smtp.host", mailServer);
// Get a mail session
Session session = Session.getDefaultInstance(props, null);
// Define a new mail message
Message message = new MimeMessage(session);
message.setFrom(new InternetAddress(from));
message.addRecipient(Message.RecipientType.TO, new InternetAddress(to));
message.setSubject(subject);
// Create a message part to represent the body text
BodyPart messageBodyPart = new MimeBodyPart();
messageBodyPart.setText(messageBody);
//use a MimeMultipart as we need to handle the file attachments
Multipart multipart = new MimeMultipart();
//add the message body to the mime message
multipart.addBodyPart(messageBodyPart);
// add any file attachments to the message
addAtachments(attachments, multipart);
// Put all message parts in the message
message.setContent(multipart);
// Send the message
Transport.send(message);
}
protected void addAtachments(String[] attachments, Multipart multipart)
throws MessagingException, AddressException
{
for(int i = 0; i<= attachments.length -1; i++ )
{
String filename = attachments[i];
MimeBodyPart attachmentBodyPart = new MimeBodyPart();
//use a JAF FileDataSource as it does MIME type detection
DataSource source = new FileDataSource(filename);
attachmentBodyPart.setDataHandler(new DataHandler(source));
//assume that the filename you want to send is the same as the
//actual file name - could alter this to remove the file path
attachmentBodyPart.setFileName(filename);
//add the attachment
multipart.addBodyPart(attachmentBodyPart);
}
}
public static void main(String[] args)
{
try
{
MailClient client = new MailClient();
String server="pop3.mydomain.com";
String from="myname@mydomain.com";
String to = "someuser@somewhere.com";
String subject="Test";
String message="Testing";
String[] filenames =
{"c:\somefile.txt"};
client.sendMail(server,from,to,subject,message,filenames);
}
catch(Exception e)
{
e.printStackTrace(System.out);
}
}
}

Read more...

You Could Win A Dream Kitchen Makeover

This might be a good time for you to think about getting a kitchen makeover ? You might want to checkout the new Maple Leaf Market experience where you can get easy-to-make meal ideas. You can also find some cool tips and coupons. You also can get some exciting recipes. This website can help you take the guess work out of cooking because this is a great website to get all the help you need to make a great meal. You can visit the Pasta Maker, The Baker and the Butcher to get many great ideas. The good news is that they are giving away a $32,000 dream kitchen and twelve fridges to celebrate the launch of their delectable new site. If I won this contest, I would love to get all new appliances for my kitchen. It also would be nice to do a kitchen makeover, and give the kitchen hardwood floors. Every entrant into the contest will also be eligible for a $500 rebate offer from Frigidaire. If you would like to win a $32,000 kitchen makeover, you should checkout Maple Leaf today and enter their sweepstakes. Don't forget to get some important tips from the Butcher and read the frequently asked questions to get more information.

Read more...

How to Search Through Entire Database

Recently I needed a way to search through my entire database for a particular keyword. I found this stored precedure that will do just that in SQL. I did not write this stored procedure, but it might be very handy when you are trying to debug an issue.

To run the stored procedure, you will execute it using this command:
EXEC SearchAllTables 'Computer'
GO

The actual stored procedure is this:

CREATE PROC SearchAllTables
(
@SearchStr nvarchar(100)
)
AS
BEGIN

-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
-- Purpose: To search all columns of all tables for a given search string
-- Written by: Narayana Vyas Kondreddi
-- Site: http://vyaskn.tripod.com
-- Tested on: SQL Server 7.0 and SQL Server 2000
-- Date modified: 28th July 2002 22:50 GMT


CREATE TABLE #Results (ColumnName nvarchar(370), ColumnValue nvarchar(3630))

SET NOCOUNT ON

DECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @SearchStr2 nvarchar(110)
SET @TableName = ''
SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%','''')

WHILE @TableName IS NOT NULL
BEGIN
SET @ColumnName = ''
SET @TableName =
(
SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName
AND OBJECTPROPERTY(
OBJECT_ID(
QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)
), 'IsMSShipped'
) = 0
)

WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)
BEGIN
SET @ColumnName =
(
SELECT MIN(QUOTENAME(COLUMN_NAME))
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)
AND TABLE_NAME = PARSENAME(@TableName, 1)
AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')
AND QUOTENAME(COLUMN_NAME) > @ColumnName
)

IF @ColumnName IS NOT NULL
BEGIN
INSERT INTO #Results
EXEC
(
'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)
FROM ' + @TableName + ' (NOLOCK) ' +
' WHERE ' + @ColumnName + ' LIKE ' + @SearchStr2
)
END
END
END

SELECT ColumnName, ColumnValue FROM #Results
END

Read more...

Learn to cook in style!

The Hilton Branson Convention Center Hotel is having a Cooking School weekend coming up October 16th and 17th. You will be able to see a cooking demonstration and engage in wine tasting with a Hilton chef Nathan Reed. If you participate on Saturday, you will be able to enjoy a four-course dinner. You will also learn how to prepare the meal that will be served the following morning. This package will include deluxe accommodations at the Hilton Branson Convention Center Hotel for two people Friday and Saturday. Along with the Cooking you will be able to participate in, you will also be able to visit shops, boutiques, and restaurants. You might want to consider going to Branson for your next vacation an engage in golf or attend one of the 49 theaters. What appeals to me the most about Branson is being able to visit one of their awesome live entertainment events. I also look forward to staying at the Hilton Branson Convention Center Hotel because it is in such a good location which is right next to a lot of entertainment and shopping areas. Since I love to cook, this Cooking School idea will be a great way for me to improve my skills. What I am really looking forward to this cooking weekend is to learn how to prepare a gourmet meal that I can share with my family and friends. I would love to be able to cook a gourmet meal to entertain my guests especially the Wild Mushroom Risotto and Dried Cherry Vanilla Demi Glace. The Charcuterie and Cheese Display with Assorted Accompaniments sounds pretty appetizing too. So what are you waiting for? If you are looking to participate in a great weekend, you need to checkout the Hilton Branson Convention Center Hotel.

Read more...