Monday, January 22, 2007

Are you looking for loans in Chennai?

My sister (Sumathi Maraimallai) was working with Citi Shelters for approx 3 years as a Manager for Personal Loans section. After that she moved to another company for better career growth and now she has become a DSA (Direct selling agent) of few MNC banks along with her friend Mr. Roshan (who was also working previously with Citi Shelters for approx 6 years).

On the other day she was asking for some referals. I said, I don't want to put people in trouble by giving away their mobile numbers :) Rather I thought I would put a word across here for the benefit of others.

If at all you are looking for Personal loans then you might want to make a note of their contact numbers [Feel free to refer my name so that they would realize that I am also capable of giving them business lol]:

Mobile - 9841283226
Land Line - 664561901 / 02 /03
E–Mail: corporateloans (at) airtelbroadband.in

Couple of questions which I thought people would ask by default:

1. What is the duration for getting a loan approved?
The loan process tentatively takes about 7 working days for sanction.

2. What are the basic details one need to furnish while applying for loans?

These are the documents required:
(a) 1 Photograph
(b) 2 Latest Payslips
(c) Last 3 months bank statements
(d) Address Proof (Ration Card, Passport, utility bill, Driving licence, Phone Bill, Voters ID, Letter from your organizations HR) -- This should reflect the current residential address.
(e) ID Proof (PAN card, Passport, Voters ID, Driving licence)
(f) Signature Proof (PAN card, Passport, Driving License, Bank Verification)

Apart from "Personal Loans" if at all you are looking for any other types of loans feel free to discuss with them. Based on their network they can accommodate your need on a case to case basis.

If possible, just spread the word around and help them succeed in their business.

Wednesday, January 17, 2007

Removing unwanted spaces within a string ...

Removing leading and trailling spaces is pretty easy. All you need to do is make use of Ltrim and Rtrim function respectively. But there are times when you want to remove unwanted spaces within a string. Check out the below code snippet to know how to do it.

--Declaration and Initialization
Declare @strValue varchar(50)
Set @strValue = ' I Love you ! ' -- Here between each word leave as many spaces as you want.

--Remove the leading and trailing spaces
Set @strValue = Rtrim(Ltrim(@strValue))

--Loop through and remove more than one spaces to single space.
While CharIndex(' ',@strValue)>0
Select @strValue = Replace(@strValue, ' ', ' ')

--Final output :)
Select @strValue

Monday, January 08, 2007

An error has occurred while establishing a connection to the server.

Error Description :: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Solution 1:

Go to, Start >> Programs >> Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server 2005 Surface Area Configuration >> Surface Area Configuration for Services and connections.

Within this check whether "Local and remote connections" is choosen. If not choose it :)

Solution 2:

Check this URL http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192622&SiteID=1 :)

Technorati tags:

Sunday, January 07, 2007

Why isn’t there any official message from Microsoft?

Microsoft announced a “BlogStar” contest last year and the winners were announced in the first week of November 2006.

How do I know that I am one among the winners?

On November 5 or 6th I got a call from one Ms. Bharathi claiming to be working in Microsoft. The number from which she called is 91-80-65605725. She said that I have won a prize and needed my size and full contact address to ship a jerkin. As the line wasn't clear I couldn't hear properly for what exactly is this gift for? But at that time Blogstar was the only Microsoft competition I was participating so I presumed it to be that.

So, you got a call from Microsoft employee and hope you have received your prize as well! What else are you asking for?

Excuse me :) As the female's communication was not that professional I thought its some spam caller and asked her to mail me the reason for requesting my contact address so that I can communicate my address back to her official ID. That said, it’s almost two months now and I am yet to hear from her :)

More over I was bit puzzled as Microsoft already has my shipping address (as I am a MVP)! May be there are some confusion in the way client/customer informations are stored within Microsoft!! I thought based on my email ID they should be in a position to fetch the contact details with ease! Am I missing something here?

Few days later I saw the winners list announced here: http://www.microsoft.com/india/blogstars/winners.aspx

I am really wondering why there isn't any official mail communication from Microsoft regarding this which would have avoided lots of confusion!! I even checked with few other winners on whether they have got any official communication from Microsoft? The response is big NO :)

Below is the extract from Microsoft site

“Over the next few weeks, the Top 20 BlogStars will meet with Tarun Gulati, General Manager - Developer and Platform Evangelism, Microsoft India and Microsoft IDC Products teams, and discuss the future roadmap of Microsoft technologies. That's not all - these Top 20 blogstars go on to form the first ever - Microsoft Blogging Leadership Cell (MBLC).” --- This too hasn’t happened yet. Hope this would occur sometime in future :)

Related Posts: http://vadivel.blogspot.com/2006/11/i-am-one-of-microsoft-blogstar-winner.html

Technorati tags: ,

Saturday, January 06, 2007

Google has decided to dedicate a page for me :)

Due to my enormous presence in the online world, Google has decided to dedicate a separate home page for me. You can check it out in the following url : http://googlemyway.com/Vadivel

Technorati tags: ,

Thursday, January 04, 2007

List tables that doesn't participate in any relationships

This query returns those tables which satisfy the below two conditions:

1. Tables that do not contain any Foreign Key referencing other tables.
2. Tables that are not referenced by other tables using foreign key constraints.

Solution:

Till SQL Server 2000 days we used to write the below scripts [This still works with SQL Server 2005 also].

Select [name] as "Orphan Tables" from SysObjects where xtype='U' and id not in
(
Select fkeyID from SysForeignKeys
union
Select rkeyID from SysForeignKeys
)

Solution which works only with SQL Server 2005:

Method 1:

Select [name] as "Orphan Tables" from Sys.Tables where object_id not in
(
Select parent_object_id from Sys.Foreign_Keys
union
Select referenced_object_id from Sys.Foreign_Keys
)

Method 2:

Select ST.[Name] as "Orphan Tables"
from Sys.Foreign_Keys as SFK Right Join Sys.Tables as ST
On ST.object_id = SFK.parent_object_id Or
ST.object_id = SFK.referenced_object_id
Where SFK.type is null

Technorati tags: ,

Wednesday, January 03, 2007

How to find the number of days in a month

This seems to be one another frequently asked question in the discussion forums. So thought would write a small post on this today.

With the help of built in SQL Server functions we can easily achieve this in one single T-SQL statement as shown below.

Select Day(DateAdd(Month, 1, '01/01/2007') - Day(DateAdd(Month, 1, '02/01/2007')))

Generalized Solution:

We can generalize it by creating a "User defined Stored Procedure" as shown below:

Create Function NumDaysInMonth (@dtDate datetime) returns int
as
Begin
Return(Select Day(DateAdd(Month, 1, @dtDate) - Day(DateAdd(Month, 1, @dtDate))))
End
Go

Test:

Select dbo.NumDaysInMonth('20070201')
Go


Technorati tags: ,

Monday, January 01, 2007

Find tables which doesn't have Primary Key

The below queries would list down the tables which doesn't have Primary Key in it.

In SQL Server 2000 :

Solution 1:

Select Table_name as "Table name"
From Information_schema.Tables
Where Table_type = 'BASE TABLE' and
Objectproperty (Object_id(Table_name), 'IsMsShipped') = 0 and
Objectproperty (Object_id(Table_name), 'TableHasPrimaryKey') = 0


Solution 2:

SysObjects :: Contains one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure. No prizes for guessing 'U' refers to user tables, and 'PK' refers to Primary Keys :)

Select [name] as "Table Name without PK"
from SysObjects where xtype='U' and
id not in
(
Select parent_obj from SysObjects where xtype='PK'
)


SQL Server 2005:

Catalog views return information that is used by the Microsoft SQL Server 2005 Database Engine. We recommend that you use catalog views because they are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information. All user-available catalog metadata is exposed through catalog views. [sys.tables is one of many catalog views introduced in SQL Server 2005]

Solution 1:

Select [name] AS table_name
from sys.tables
Where Objectproperty(object_id,'TableHasPrimaryKey') = 0

Solution 2; [Display with schema name]

Select Schema_Name(schema_id) AS schema_name,
[name] AS table_name from sys.tables
Where Objectproperty(object_id,'TableHasPrimaryKey') = 0
Order by schema_name, table_name


Technorati tags:,