I just wanted to say I've been using this approach to generate ranks for over a year now. I found the undocumented update syntax somewhere on the web. It works...

INT is smallest, but generally not recommended because of the manipulation. INT is +- 2 billion, roughly, plenty for 9 digits. DECIMAL(9) is 5 bytes. I see no advantage to...

Yikes!

First of all, what does this do, and when and in what conditions does it run? You need to determine that first. You've provided little information to go on. Where are...

Readers of this cannot debug your expression. Perhaps you could determine all the input values, eg:

select cast( (31.0-20+1.0)*

  (CAST(3 AS float)*9.0+CAST(5 AS float))/

  30

   as decimal (5,3))

-------

 12.800

(1...

Why not just use Perl, DBI and DBD :: ODBC? I hate DTS.

use strict;

#use DBI;

#use DBI qw(:sql_types);

use Compress::Zlib;

open FH, "<file.gz";

binmode FH;

{ local $/ = undef; my $filetext = <FH>}

$filetext = Compress::Zlib::memGunzip(...

Unless you're really short on disk space, I don't see the problem with putting all the data in a temp table, especially if you'd doing this just once and then...

RAID 0? Are you kidding? I dont like this question.

I answered "Buy bigger hard drives", because RAID 0 is very unsafe and RAID 5 isn't necessarily faster for writes; easily...

This has nothing to do with SQL...

(Continuing anyway...)

There seems to be a pathlength limit of about 247 characters, in my testing, but there should be no (practical) limits to the...

Adding leading 0s doesn't increase the precision of the implicit conversion to decimal, or, in your case, integer.

It looks like you need to join to the xref table once for each column you are looking up. EG:

SELECT   d.company,d.address1,d.address2,d.city_id

             ,d.state_id,d.country_id,d.zip

             ,case dr.directory_roletype_id when 1 then 'shipper' when 2...

okay now I feel silly; the results are out of order. So if the order is important go with the looping, or create...

Fun with cross products... I just saw this technique in a post.

create view Letters AS

SELECT 'A' l UNION ALL

SELECT 'B' UNION ALL

SELECT 'C' UNION ALL

SELECT 'D' UNION ALL

SELECT 'E'...

Use sp_executesql

This gets me the count of records in tbl_clients. I just posted this to microsoft.public.sqlserver.programming as well.

declare @mySQL nvarchar(4000)

declare @CountRec int

SET @mySQL = 'SELECT @CountParm = COUNT(*) FROM...

My post was erased when I tried to post it.

Anyway, this is something similar that worked for me. One cursor, but not nested.

declare @client_id int

declare @client varchar(20)

declare client_cursor cursor fast_forward...