motivate the team... Think out of the Box !!

• Employee "A" in a company walked up to his manager and asked what my job is for the day?
• The manager took "A" to the bank of a river and asked him to cross the river and reach the other side of the bank.
• "A" completed this task successfully and reported back to the manager about the completion of the task assigned. The manager smiled and said "GOOD JOB"

Next day Employee "B" reported to the same manager and asked him the job for the day. The manager assigned the same task as above to this person also.

• The Employee "B' before starting the task saw Employee "C" struggling in the river to reach the other side of the bank. He realized "C" has the same task.
• Now "B" not only crossed the river but also helped "C" to cross the river.
• "B" reported back to the manager and the manager smiled and said "VERY GOOD JOB"

The following day Employee "Q" reported to the same manager and asked him the job for the day. The manager assigned the same task again.

• Employee "Q" before starting the work did some home work and realized "A", "B" & "C" all has done this task before. He met them and understood how they performed.
• He realized that there is a need for a guide and training for doing this task.
• He sat first and wrote down the procedure for crossing the river, he documented the common mistakes people made, and tricks to do the task efficiently and effortlessly.
• Using the methodology he had written down he crossed the river and reported back to the manager along with documented procedure and training material.
• The manger said "Q" you have done an "EXCELLENT JOB".

The following day Employee "O' reported to the manager and asked him the job for the day. The manager assigned the same task again.

"O" studied the procedure written down by "Q" and sat and thought about the whole task.
He realized company is spending lot of money in getting this task completed. He decided not to cross the river, but sat and designed and implemented a bridge across the river and went back to his manager and said, "You no longer need to assign this task to any one".
The manager smiled and said "Outstanding job 'O'. I am very proud of you."

What is the difference between A, B, Q & O????????
Many a times in life we get tasks to be done at home, at office, at play.,
Most of us end up doing what is expected out of us. Do we feel happy? Most probably yes. We would be often disappointed when the recognition is not meeting our expectation.

Let us compare ourselves with "B". Helping some one else the problem often improves our own skills. There is an old proverb (I do not know the author) "learn to teach and teach to learn". From a company point of view "B" has demonstrated much better skills than "A" since one more task for the company is completed.

"Q" created knowledge base for the team. More often than not, we do the task assigned to us without checking history. Learning from other's mistake is the best way to improve efficiency. This knowledge creation for the team is of immense help. Re-usability reduces cost there by increases productivity of the team. "Q" demonstrated good "team-player" skills,

Now to the outstanding person, "O" made the task irrelevant; he created a Permanent Asset to the team.

If you notice B, Q and O all have demonstrated "team performance" over an above individual performance; also they have demonstrated a very invaluable characteristic known as "INITIATIVE".

Initiative pays of every where whether at work or at personal life. If you put initiative you will succeed. Initiative is a continual process and it never ends. This is because this year's achievement is next year's task. You cannot use the same success story every year.

The story provides an instance of performance, where as measurement needs to be spread across at least 6-12 months. Consequently performance should be consistent and evenly spread.

Out-of-Box thinkers are always premium and that is what every one constantly looks out for. Initiative, Out-of-Box thinking and commitment are the stepping stone to success.
Initiative should be life long. Think of out of the box.

Compression & Backup Softwares

WinZip

• Save disk space and send e-mail attachments faster

• Password-protect confidential files and e-mail attachments

• Compress JPEGs by 20 to 25% without compromising quality spacer
  

• Browse digital photos and other image

• thumbnails before you unzip

WinRar

WinRAR is a powerful archive manager.
It can backup your data and reduce the size of email attachments, decompress RAR, ZIP and other files.

7-Zip

Supported formats:
Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR
Unpacking only: ARJ, CAB, CHM, CPIO, DEB, DMG, HFS, ISO, LZH, LZMA, MSI, NSIS, RAR, RPM, UDF, WIM, XAR and Z.

IZArc

Supported formats: 7-ZIP, A, ACE, ARC, ARJ, B64, BZ2, BH, CAB, BZA, CPIO, ENC, DEB, GCA, GZ, GZA, HA, JAR, LHA, LIB, LZH, MBF, MIM, PAK, PK3, RAR, RPM, TAR, TAZ, TBZ, TGZ, TZ, UUE, XXE, YZ1, Z, ZIP, ZOO.

SyncBack

SyncBack is a flexible, and quite powerful backup and synchronization program that allows to to maintain backup copies of your files and folder, or to synchronize them, so that both locations always have a complete copy (e.g Laptop/PC).

SyncBack has established itself as world-class in the field of backup and synchronization software. Whether you're a beginner or advanced user, at home or work, SyncBack ensures your most valuable asset, data, remains protected.

Universal Extractor

Universal Extractor is a program do to exactly what it says: extract files from any type of archive, whether it's a simple zip file, an installation program, or even a Windows Installer (.msi) package

sql server insert multiple records


CREATE TABLE #CALCULATE
(
COL1 VARCHAR(20),

COL2 VARCHAR(20))

Using Insert INTO commands for each row

INSERT INTO #CALCULATE
(COL1,
COL2)
VALUES ('one',
1);
INSERT INTO #CALCULATE
(COL1,
COL2)
VALUES ('two',
2);
INSERT INTO #CALCULATE
(COL1,
COL2)
VALUES ('three',
3);
INSERT INTO #CALCULATE
(COL1,
COL2)
VALUES ('four',
4);
INSERT INTO #CALCULATE
(COL1,
COL2)
VALUES ('five',
5);

SELECT *
FROM #CALCULATE

DELETE FROM #CALCULATE

Using Union All command

INSERT INTO #CALCULATE
(COL1,
COL2)
SELECT 'one',
1
UNION ALL
SELECT 'two',
2
UNION ALL
SELECT 'three',
3
UNION ALL
SELECT 'four',
4
UNION ALL
SELECT 'five',
5

SELECT *
FROM #CALCULATE

CREATE TABLE #CALCULATETEMP
(
COL1 VARCHAR(20),

COL2 VARCHAR(20))

Insert from another table

INSERT INTO #CALCULATETEMP
(COL1,
COL2)

SELECT COL1,
COL2
FROM #CALCULATE

Create table and insert the data from another table

SELECT *
FROM #CALCULATETEMP

SELECT COL1,
COL2
INTO #CALCULATETEMP1
FROM #CALCULATE

SELECT *
FROM #CALCULATETEMP1

DROP TABLE #CALCULATE

DROP TABLE #CALCULATETEMP

DROP TABLE #CALCULATETEMP1

Reference : www.sqlauthority.com



sql server execute all files in a folder using sqlcmd

Step 1. Create a sql file (proc.sql) and palace it here C:\SqlFiles\01_database\proc.sql

create procedure procName
as
begin
select * from DimProduct
end

Step2. Create a sql file(proc1.sql) and place it here C :\SqlFiles\proc1.sql

create procedure procName1
as
begin
select * from DimProduct
end

step3.Create a BatchCommand file(ExecuteSqlFiles.bat) with following text in it and place it here C:\SqlFiles\ExecuteSqlFiles.bat

for /R %%X in (*.SQL) do SQLCMD -S Server -d Database -U UserID -P Password -I -i "%%X" >> ResultScript.txt

Step4. Run the ExecuteSqlFiles.bat (i.e by clicking on it)

A file (C:\SqlFiles\ResultScript.txt) if not exist is created and the errors encounterd while executing the sql files is written to the file.

Software Jokes Telugu version

Dialogues from Soft Simha Reddy
1) Etti kottanante, GOOGLE search lo kooda kanapadakunda potav..

2) Rey Java Reddy, nenu VB chesa, VC chesa, Sun chesaa, nee java chesa....

Nuvvu.. Software vamsam lo ne puttunte.. neeke ganaka ... oka guenine company unte.. laptop , desktop rendu unte... raara.. dammunte naaku interview cheyyara... ee roju .. ee joboo , leka nee companyno telipovala...

3) Keyboard lo button nokkanante.. aa sound ke job istav.. nenu personal ga vacchi interview ivvatam entra...

4)Debugging naaku maa amma uggu paalatho pattindi ra.

5) Program nuvvu ichina sare, nannu raayamanna sare. Logic nuvvu cheppina sare nannu alochinchammana sare, eppudayina ekkadaina nenu program rayagalanu.

6) Cant be displayed" ani vacchinantha maatrana kanipinchananukunnava.vakka sari refresh kotti chooda ra Romaalu nikka boduchukuntai.

7)hacker ali khann!!! thappu naa program lo undhi kaabatti logout avuthunna, adhey error nee code lo unduntey system crash chesi velley vaadini.

8) Ee Softseema lo modhata spam pettindhi maa thaata, Virus puttinchindhi maa thaata , nuvventra peekedhi.

9) Arey thaaai... evari company ki vacchavo telusa.. naa peru chepithe.. BILL GATES kooda java program copy cheyyadam marchipotadu...

10) Kathula tho kadura program tho champestha

#######################################################


Hi good afternoon, this is Martha, I can't print. Every time I try it says 'Can't find printer'. I've even lifted the printer and placed it in front of the monitor, but the computer still says he can't find it...



$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Customer Care....

Helpdesk: What kind of computer do you have?

Customer: A white one...

--------------------------------------------

Customer: Hi, this is Celine. I can't get my diskette out.

Helpdesk: Have you tried pushing the button?

Customer: Yes, but it's really stuck.

Helpdesk: That doesn't sound good; I'll make a note .

Customer: No ... wait a minute... I hadn't inserted it yet... it's still on my desk... sorry.

--------------------------------------------

Helpdesk: Click on the 'my computer' icon on to the left of the screen.

Customer: Your left or my left?

--------------------------------------------

Helpdesk: Good day. How may I help you?

Male customer: Hello... I can't print.

Helpdesk: Would you click on start for me and ...

Customer: Listen pal; don't start getting technical on me! I'm not Bill Gates!

--------------------------------------------

Hi good afternoon, this is Martha, I can't print. Every time I try it says 'Can't find printer'. I've even lifted the printer and placed it in front of the monitor, but the computer still says he can't find it...

--------------------------------------------

Customer: I have problems printing in red...

Helpdesk: Do you have a colour printer?

Customer: No.

--------------------------------------------

Helpdesk: What's on your monitor now ma'am?

Customer: A teddy bear my boyfriend bought for me in the supermarket.

--------------------------------------------

Helpdesk: And now hit F8.

Customer: It's not working.

Helpdesk: What did you do, exactly?

Customer: I hit the F-key 8-times as you told me, but nothing's happening...

--------------------------------------------

Customer: My keyboard is not working anymore.

Helpdesk: Are you sure it's plugged into the computer?

Customer: No. I can't get behind the computer.

Helpdesk: Pick up your keyboard and walk 10 paces back.

Customer: OK

Helpdesk: Did the keyboard come with you?

Customer: Yes

Helpdesk: That means the keyboard is not plugged in. Is there another
keyboard?

Customer: Yes, there's another one here. Ah...that one does work!

--------------------------------------------

Helpdesk: Your password is the small letter a as in apple, a capital letter V as in Victor, the number 7.

Customer: Is that 7 in capital letters?

--------------------------------------------

A customer couldn't get on the internet...

Helpdesk: Are you sure you used the right password?

Customer: Yes I'm sure. I saw my colleague do it.

Helpdesk: Can you tell me what the password was?

Customer: Five stars.

--------------------------------------------

Helpdesk: What antivirus program do you use?

Customer: Netscape.

Helpdesk: That's not an antivirus program.

Customer: Oh, sorry...Internet Explorer.

--------------------------------------------

Customer: I have a huge problem. A friend has placed a screensaver on my computer, but every time I move the mouse, it disappears!

--------------------------------------------

Helpdesk: Microsoft Tech. Support, may I help you?

Customer: Good afternoon! I have waited over 4 hours for you. Can you please tell me how long it will take before you can help me?

Helpdesk: Uhh..? Pardon, I don't understand your problem?

Customer: I was working in Word and clicked the help button more than 4 hours ago. Can you tell me when you will finally be helping me?

--------------------------------------------

Helpdesk: How may I help you?

Customer: I'm writing my first e-mail.

Helpdesk: OK, and, what seems to be the problem?

Customer: Well, I have the letter a, but how do I get the circle around it?

Watch online movies tv channels

Great website

Watch online Movies

Listen songs

Live Tv Channels

Telugu,Hindi,Tamil,Kannada,Panjabi,Bengali,Marathi

Bindaasbharat

SQL Server programming Group by day,Month ,Year

--group by day

SELECT COUNT(* ),

Dateadd(DAY,Datediff(DAY,0,HireDate),0) 'day'

FROM Employees

GROUP BY Dateadd(DAY,Datediff(DAY,0,HireDate),0)

ORDER BY Dateadd(DAY,Datediff(DAY,0,HireDate),0) DESC



--group by Month

SELECT COUNT(* ),

Dateadd(MONTH,Datediff(MONTH,0,HireDate),0) 'Month'

FROM Employees

GROUP BY Dateadd(MONTH,Datediff(MONTH,0,HireDate),0)

ORDER BY Dateadd(MONTH,Datediff(MONTH,0,HireDate),0) DESC





Testing Principles

A new web browser from google Chrome

Google Chrome is a browser that combines a minimal design with sophisticated technology to
make the web faster, safer, and easier

One box for everythingType in the address bar and get suggestions for both search and web pages.

Thumbnails of your top sitesAccess your favorite pages instantly with lightning speed from any new tab.

Shortcuts for your appsGet desktop shortcuts to launch your favorite web applications.

Download

Internet Explorer 8

Try the new Developer friendly

Internet Explorer

clickhere

Regular Expressions in Dotnet

Quantifiers provide a simple way to specify within a pattern how many times a particular character or set of characters is allowed to repeat itself. There are three non-explicit quantifiers:

1. *, which describes "0 or more occurrences",
2. +, which describes "1 or more occurrences", and
3. ?, which describes "0 or 1 occurrence".

Quantifiers always refer to the pattern immediately preceding (to the left of) the quantifier, which is normally a single character unless parentheses are used to create a pattern group. Below are some sample patterns and inputs they would match.

Pattern		Inputs (Matches)
	fo*		foo, foe, food, fooot, "forget it", funny, puffy
	fo+		foo, foe, food, foot, "forget it"
	fo?		foo, foe, food, foot, "forget it", funny, puffy

In addition to specifying that a given pattern may occur exactly 0 or 1 time, the ? character also forces a pattern or subpattern to match the minimal number of characters when it might match several in an input string.

Explicit quantifiers are positioned following the pattern they apply to, just like regular quantifiers. Explicit quantifiers use curly braces {} and number values for upper and lower occurrence limits within the braces. For example, x{5} would match exactly five x characters (xxxxx). When only one number is specified, it is used as the upper bound unless it is followed by a comma, such as x{5,}, which would match any number of x characters greater than 4. Below are some sample patterns and inputs they would match.

Pattern	Inputs (Matches)
ab{2}c	abbc, aaabbccc
ab{,2}c	ac, abc, abbc, aabbcc
ab{2,3}c	abbc, abbbc, aabbcc, aabbbcc

Metacharacters

The constructs within regular expressions that have special meaning are referred to as metacharacters. You've already learned about several metacharacters, such as the *, ?, +, and { } characters. Several other characters have special meaning within the language of regular expressions. These include the following: $ ^ . [ ( | ) ] and \.

. It matches any single character

^ used to designate the beginning of a string (or line)

$ is used to designate the end of a string

\ is used to "escape" characters from their special meaning

| (pipe) is used for alternation, essentially to specify 'this OR that' within a pattern.

( ) used to group patterns.

Some examples of metacharacter usage are listed below.

Pattern	Inputs (Matches)
.	a, b, c, 1, 2, 3
.*	Abc, 123, any string, even no characters would match
^c:\\	c:\windows, c:\\\\\, c:\foo.txt, c:\ followed by anything else
abc$	abc, 123abc, any string ending with abc
(abc){2,3}	abcabc, abcabcabc

In order to include a literal version of a metacharacter in a regular expression, it must be "escaped" with a backslash.

For instance if you wanted to match strings that begin with "c:\" you might use this: ^c:\\

So something like a|b would match anything with an 'a' or a 'b' in it, and would be very similar to the character class [ab].

Character classes are a mini-language within regular expressions, defined by the enclosing hard braces [ ]. The simplest character class is simply a list of characters within these braces, such as [aeiou].

To specify any numeric digit, the character class [0123456789] could be used. However, since this would quickly get cumbersome, ranges of characters can be defined within the braces by using the hyphen character, -.

Eg: [a-z],[A-Z],[0-9]

If you need a hyphen to be included in your range, specify it as the first character. For example, [-.? ]

You can also match any character except a member of a character class by negating the class using the carat ^ as the first character in the character class. Thus, to match any non-vowel character, you could use a character class of [^aAeEiIoOuU].

Pattern	Inputs (Matches)
^b[aeiou]t$	Bat, bet, bit, bot, but
^[0-9]{5}$	11111, 12345, 99999
^c:\\	c:\windows, c:\\\\\, c:\foo.txt, c:\ followed by anything else
abc$	abc, 123abc, any string ending with abc
(abc){2,3}	abcabc, abcabcabc
^[^-][0-9]$	0, 1, 2, … (will not match -0, -1, -2, etc.)

Metacharacter	Equivalent Character Class
\a	Matches a bell (alarm); \u0007
\b	Matches a word boundary except in a character class, where it matches a backspace character, \u0008
\t	Matches a tab; \u0009
\r	Matches a carriage return; \u000D
\w	Matches a vertical tab; \u000B
\f	Matches a form feed; \u000C
\n	Matches a new line; \u000A
\e	Matches an escape; \u001B
\040	Matches an ASCII character with a three-digit octal. \040 represents a space (Decimal 32).
\x20	Matches an ASCII character using 2-digit hexadecimal. In this case, \x2- represents a space.
\cC	Matches an ASCII control character, in this case ctrl-C.
\u0020	Matches a Unicode character using exactly four hexadecimal digits. In this case \u0020 is a space.
\*	Any character that does not represent a predefined character class is simply treated as that character. Thus \* is the same as \x2A (a literal *, not the * metacharacter).
\p{name}	Matches any character in the named character class 'name'. Supported names are Unicode groups and block ranges. For example Ll, Nd, Z, IsGreek, IsBoxDrawing, and Sc (currency).
\P{name}	Matches text not included in the named character class 'name'.
\w	Matches any word character. For non-Unicode and ECMAScript implementations, this is the same as [a-zA-Z_0-9]. In Unicode categories, this is the same as [\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}].
\W	The negation of \w, this equals the ECMAScript compliant set [^a-zA-Z_0-9] or the Unicode character categories [^\p{Ll}\p{Lu}\p{Lt}\p{Lo}\p{Nd}\p{Pc}].
\s	Matches any white-space character. Equivalent to the Unicode character classes [\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \s is equivalent to [ \f\n\r\t\v] (note leading space).
\S	Matches any non-white-space character. Equivalent to the Unicode character categories [^\f\n\r\t\v\x85\p{Z}]. If ECMAScript-compliant behavior is specified with the ECMAScript option, \S is equivalent to [^ \f\n\r\t\v] (note space after ^).
\d	Matches any decimal digit. Equivalent to [\p{Nd}] for Unicode and [0-9] for non-Unicode, ECMAScript behavior.
\D	Matches any non-decimal digit. Equivalent to [\P{Nd}] for Unicode and [^0-9] for non-Unicode, ECMAScript behavior.

Sample Expressions

Most people learn best by example, so here are a very few sample expressions.

Pattern	Description
^\d{5}$	5 numeric digits, such as a US ZIP code.
^(\d{5})|(\d{5}-\d{4}$	5 numeric digits, or 5 digits-dash-4 digits. This matches a US ZIP or US ZIP+4 format.
^(\d{5})(-\d{4})?$	Same as previous, but more efficient. Uses ? to make the -4 digits portion of the pattern optional, rather than requiring two separate patterns to be compared individually (via alternation).
^[+-]?\d+(\.\d+)?$	Matches any real number with optional sign.
^[+-]?\d*\.?\d*$	Same as above, but also matches empty string.
^(20|21|22|23|[01]\d)[0-5]\d$	Matches any 24-hour time value.
/\*.*\*/	Matches the contents of a C-style comment /* … */

Regex test;

test = new Regex("testing");

Match m = test.Match("here is a string for testing");

if (m.Success) {

// do whatever you want

}