Convert a comma separed values in to table

CREATE FUNCTION [dbo].[ufn_CSVToTable] ( @StringInput VARCHAR(8000) )
RETURNS @OutputTable TABLE ( [String] VARCHAR(10) )
AS
BEGIN

DECLARE @String VARCHAR(10)

WHILE LEN(@StringInput) > 0
BEGIN
SET @String = LEFT(@StringInput,
ISNULL(NULLIF(CHARINDEX(',', @StringInput) - 1, -1),
LEN(@StringInput)))
SET @StringInput = SUBSTRING(@StringInput,
ISNULL(NULLIF(CHARINDEX(',', @StringInput), 0),
LEN(@StringInput)) + 1, LEN(@StringInput))

INSERT INTO @OutputTable ( [String] )
VALUES ( @String )
END

RETURN
END
GO

Online Pratice Exams

For Online Pratice Quiz in .NET Technologies you can check at
geekinterview
googlepages
4Test
Numer2
You can evaluate your .NET Knowledge and get assessed for FREE.
Questions are generated randomly.

Please leave a comment of any other such websites you know.

Todo

Manage tasks quickly and easily.

If you go to View -> Task List and select “Comments” from the dropdown, you’ll see that “TODO” comment in the list.

heart touching

An 80 year old man was sitting on the sofa in his house along with his 45 years old highly educated son.

Suddenly a crow perched on their window.
The Father asked his Son, "What is this?" The Son replied "It is a crow".
After a few minutes, the Father asked his Son the 2nd time, "What is this?" The Son said "Father, I have just now told you "It's a crow".

After a little while, the old Father again asked his Son the 3rd time, What is this?"At this time some ex-pression of irritation was felt in the Son's tone when he said to his Father with a rebuff. "It's a crow, a crow".

A little after, the Father again asked his Son t he 4th time, "What is this?"This time the Son shouted at his Father, "Why do you keep asking me the same question again and again, although I have told you so many times 'IT IS A CROW'. Are you not able to understand this?"

A little later the Father went to his room and came back with an oldtattered diary, which he had maintained since his Son was born. On opening a page, he asked his Son to read that page.

When the son read it, the following words were written in the diary :- "Today my little son aged three was sitting with me on the sofa, when a crow was sitting on the window.

My Son asked me 23 times what it was, and I replied to him all 23 times that it was a Crow. I hugged him lovingly each time he asked me the same question again and again for 23 times.

I did not at all feel irritated I rather felt affection for my innocent child". While the little child asked him 23 times "What is this", the Father had felt no irritation in replying to the same question all 23 times and when today the Father asked his Son the same question just 4 times, the Son felt irritated and annoyed.So..If your parents attain old age, do not repulse them or look at them as a burden, but speak to them a gracious word, be cool, obedient, humble and kind to them.
Be considerate to your parents.From today say this aloud, "I want to see my parents happy forever.

They have cared for me ever since I was a little child. They have always showered their selfless love on me.

They crossed all mountains and valleys without seeing the storm and heat to make me a person presentable in the society today". Say a prayer to God, "I will serve my old parents in the BEST way. I will say all good and kind words to my dear parents, no matter how they behave.

After all result Matter!

Priest dies & is awaiting his turn in line at the Heaven's Gates. Ahead of him is a guy, nattily dressed, in dark sun glasses, a loud shirt, leather jacket & jeans.

Lord Dharamraj asks him : Please tell me who are you , so that I may know whether to admit you into the kingdom of Heaven or not ?

The guy replies : I am Banta Singh, taxi driver from New Delhi !

Lord Dharamraj consults his ledger ( Bahi khaata ), smiles & says to Banta Singh : Please take this silken robe & golden staff & enter the Kingdom of Heaven.

Now it is the priest's turn. He stands erect and speaks out in a booming voice : I am Sant Shiromani Baba so & so ,Head Priest of the so & so Temple for the last 40 years.

Lord Dharamraj consults his ledger & says to the Priest : Please take this cotton robe & wooden staff & enter the Kingdom of Heaven.

"Just a minute," says the agonised Priest. How is that a foul mouthed,
rash driving Taxi Driver is given a Silken robe & a Golden staff, and me, a Priest , who's spent his whole life preaching your Name & goodness has to make do with a Cotton robe & a Wooden staff ?

" Results my friend, results," shrugs Lord Dharamraj.

While you preached, people SLEPT ; but when he drove his taxi, people PRAYED.
Moral of the story: It’s the RESULT that matters…

Email Etiquettes

Hi All!

This is good list of email etiquettes. Please go through it and make sure to use it in your day to day work.

Why are you writing to me?
State the purpose of your e-mail -- it is a good practice to have a subject line that explains what follows and how high on the priority list it should be. This information has to be in two places:

i. The subject box, which is part of the compose e-mail form. Here, state the reason for your mail. If you are writing it to apply for leave, you could say 'Leave application'.

ii. Subject line in the main e-mail body; just as you would in any formal business letter. Here, you could say: Sub: Leave application, April 1-April 15 2006
Greet me right

Address people you don't know as Mr, Mrs, Ms or Dr. Address someone by first name only if you are on a first name basis with each other; it is okay, under these circumstances, to use first names on a formal business missive.

If you do not know the name of the person, or whether it is a man or a woman, it is best to address the person concerned as: Dear Sir / Madam, Whomsoever it may concern, The Manager; etc.

And your point is?Get to the point.
Verbosity and extreme terseness are two ends of a spectrum, you should try for the middle -- state your point without sounding rudely brief or chatty.

Remember to state your point and what you expect from the reader of your mail in clear terms. There should also be a clear structure -- an introduction, body and conclusion.

2 use or not 2 use...Never use 'sms-ese' or informal abbreviations in your email. U instead of you, 2 instead of to or too, plz instead of please, thanx instead of thanks and 4 instead of for are a strict no-no.

While are all right for personal e-mail, they show a level of informality not encouraged in formal business communication. Frequently used abbreviations you may use include FYI (for your information), Pvt., Ltd., Co., etc., OK.

The magic of spellsThough using a spell check is a must, don't rely on it completely. The most common areas of errors and confusion are -- two, too and to.

For eg: Wrong: I would like two order too other books two.
Correct: I would like to order two other books, too.
A hit or miss effort with spellings does not help -- use a dictionary.
Write rightGood grammar is very important. A correctly framed sentence, with proper punctuation in place, is what you should aim at. Be very careful with commas, especially, as they change the meaning of a sentence.

A good example would be:
Wrong: All foreign tea, tree, oils are free from duty.
Correct: All foreign tea tree oils are free from duty.
Use action words and 'I' statements -- they evoke a sense of reassurance in the reader. For eg:
On receipt of your earlier mail, I/ we have already set things in motion and I/ we assure you that you will receive your order on time.

I was responsible for the day-to-day working and administration of the office; planning, scheduling, and achieving targets were my areas of contribution.

Mind your P's and Q's Though a friendly tone is encouraged, basic corporate etiquette rules do apply. So, maintain a well-mannered, friendly polite stance.

Gender-neutral language is politically correct -- couch your e-mail accordingly. This essentially means you should not assume a person's gender on the basis of the designation. Keep the e-mail neutral.Attachment breeds detachmentWith worms, viruses, and spam, nobody wants to open attachments anymore, not even if the e-mail is from one's own mother. If you do need to send an attachment, confirm this with the recipient first.

Like an arrow shot from a bowAn e-mail is like the spoken word -- once sent, you can't recall it. By the time you press the recall button, chances are it has already reached and, with it, your recall message. This compounds the embarrassment. So, think before you dash off something.

The KISS rulesKeep It Short and Simple. Use simple sentences, words that don't need a dictionary. Use universal formats -- not all systems support HTML rich style, or tables and tabs. You could lose much by way of appearances if your recipient's system can't support all that fancy formatting you spent hours working on.

Smile pleaseSmileys and other emoticons are a way to add 'body language' to e-mail. When used appropriately and sparingly, smileys do bring a touch of personalisation to otherwise impersonal mail. Of course, due care with regards to the appropriateness of the communication must be taken.

You would not use emoticons in job application covering letters, while delivering bad news (delay in order, loss of job, etc). Use discretion.

Emoticons are generally used to add comfort to the communication or soften the blow. The most common smiley faces are probably these:

:-) OR :) Just a smile / can be used for greeting or making a point gently. :-( OR :( To show mild displeasure or that something is not going the way you want it to. ;-) Equivalent to a wink -- used to convey that a particular comment is a joke and not to be taken too seriously. ;-> To be used sparingly, and with people you know well, as this signifies a provocative comment.

Humour doesn't travelWhat seems funny to you may be offensive to someone else. Remember, humour doesn't travel well. Jokes about religion, sports, political figures, and women may come across as tasteless and should be avoided at all costs.

Swift and promptBe prompt in replying. That is why we have the Internet. If a prompt response were not expected, one would use the postal service.

CAPITAL, MY DEAR FELLOWIF YOU WRITE IN CAPITALS, IT SEEMS AS IF YOU ARE SHOUTING. You could get really angry responses to your e-mail if you do so, and trigger a flame war.
Fw. Fw. Fw. Do not forward chain letters -- simply delete them. Also avoid forwarding them to professional contacts.

Shh... It's a secretIf it is a secret, don't send it via e-mail -- you never know where it will end up.

ConnectionsKeep the thread of the message as part of your mail; this will help keep the context handy. The thread is the previous message/s in context to which this e-mail is being written. Last but not least, please, please read the e-mail before you click the 'Send' button. It will save you a lot of embarrassment and misunderstanding.