Viewing 15 posts - 58,606 through 58,620 (of 59,048 total)
"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
With 7 million rows of data, I'm thinking that you'll get a recompile on run anyway just due to the number of changes in the data. So, I gotta ask,...
October 9, 2005 at 8:30 pm
Chris,
Likewise it's interesting to think that databases are not used for performance... whatever. The real key is that the inclusion of the NOLOCKs greatly reduced the number of deadlocks in...
October 6, 2005 at 10:46 pm
Viewing 15 posts - 58,606 through 58,620 (of 59,048 total)