As a "best practice", you should always use at least the two part naming convention, which includes the user name.  There's dozens of articles on this recommendation on the Web......

>because DB programming is almost the same in oracle and in sql 2000

Boy oh boy are you in for a surprise!  Take, for instance, that SQL Server 2000 has a...

Couldn't see the forest for the circumlocution

I don't get it, Neetu... you posted...

RefNo   Pro_No         Country

1.        11,22,33,44    X

2.        33,44,22,11    Y

3.        44,55,33,22    Z

Explain to me why 44 is in RefNo 1, why 33,44 is in RefNo2, and why...

You bet, Henk... thank you for the feed back.

I gotta know... what's comical about it?

"The difficult can be done immediately... the impossible takes slightly longer."

This will work but the creation of a real "Numbers" table would be better as it would be more predictable...

My mistake... I misread BOL... the NVARCHAR(4000) is for the command line INPUT... you can't get more than 255 characters in the OUPUT... so, the following will work just fine...

You just don't need to write a VB script to count the number of files in a directory from T-SQL.  In fact, with a little clever CMD line code in...

Just adding my two cents...

Use STR(n,l,d) for numerics on this...

n = number to convert

l = final length of all characters (defaults to 10)

d = number of decimal places (defaults to...

I share David Burrow's opinion of this series of articles.  Very well written with a great amount of understanding of what's what in the world of employment both from the employee...

The computed sum column example a couple of postings above may give an incorrect sort order depending on the data.

The ORDER BY CASE example works wonderfully for 3 columns.  It does...

I can't see the images...

Sounds more like homework than a request from the vendor...

Thank you Carl... that's just what the Dr. ordered.

See what I mean?