Saturday, February 14, 2009

Pivoting your data in MSSQL Creating "Cross Tab" reports

A pivot is a normally used to transform large amounts data into a condensed list or grid. A Pivot report displays data in a grid along a vertical and horizontal axis. Financial reports are good candidates for Pivot reports.

Microsoft Access refers to pivots as "Cross tabs." In MS Acces there is a wizard as well. It asks which columns should be on which axis, then auto-generates the code needed. Access creates pivots by using the special key word TRANSFORM.

Unfortunately it is not as easy as using a wizard in MS SQL. In SQL 2000, pivot style reports, called "Cross-Tab Reports" can be created using the CASE keyword. CASE can also be used in SQL 2005 and SQL 2008. But there is another keyword that can be used, PIVOT.

Read More..

Tuesday, February 3, 2009

LinkedIn vs Facebook

Do you have a social netwrok account. Are you on Facebook or MySpace. Social networking is taking the world by storm. Everyone has a MySpace or Facebook account. Maybe you have a twitter account. Researching SEO, one find out that good use of social networks can improve web site traffic. But Facebook has never really been the place for business has it. Well, if you want to promote your business via social networking, take a look at LinkedIn

Read More »

Sunday, February 1, 2009

Facebook more popular than MySpace

The social wars get bigger and more intense. Just like everything else, someone is always trying to out do you. The internet is a cut throat business. Traffic is what makes the World Wide Web go round. Facebook and Myspace are no different. Myspace has taken the limelight for a while, but there is a new kid on the block.

Read More »

Promote your blog with e-mail

A blog will die if no traffic comes its way. If you have a new blog, then one of the ways to get traffic to you blog is to promote it. But How?

We are always looking for ways to promote our blog or website. One way of doing this is putting links to your blog into your e-mail via a signature. Why not have the latest post from your blog in you e-mail signature.

Read More »