Viewing 15 posts - 58,621 through 58,635 (of 59,065 total)
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...
October 31, 2005 at 9:38 pm
You bet, Henk... thank you for the feed back.
I gotta know... what's comical about it?
October 31, 2005 at 5:24 pm
"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...
October 31, 2005 at 6:16 am
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...
October 31, 2005 at 5:52 am
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...
October 30, 2005 at 8:37 am
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...
October 30, 2005 at 8:07 am
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...
October 25, 2005 at 5:52 am
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...
October 22, 2005 at 11:32 pm
Sounds more like homework than a request from the vendor...
October 16, 2005 at 7:59 pm
Thank you Carl... that's just what the Dr. ordered.
October 15, 2005 at 9:51 am
Actualy, if you do a search for "DELETE DUPLICATES", you come up with just a couple of articles which use cursors and group bys and adding columns and using MAX/GROUP...
October 10, 2005 at 6:54 am
Vishal,
If your field list looks like this...
field value: Oracle,VB,ASP,PHP
field value: Java,VB,PHP,MYSql
field value: Java,VB,Oracle,Asp.net,MSSQL,Asp
field value: Windows,HASP,Excel,VBA
Consider the following code to keep from listing the 4rh line when looking for ASP and...
October 9, 2005 at 9:22 pm
And, you might want to consider using the user name in the 3 part naming convention as part of best practices...
October 9, 2005 at 8:32 pm
Viewing 15 posts - 58,621 through 58,635 (of 59,065 total)