Pressed "Post Reply" too quickly.

pk dat

1 001

2 00102

3 ...

Peso,

That is indeed the question:

For ALPHANUMERIC data, does '001' come before '1' ?.

I cannot shake out of my head that anything that sarts with 0 should come before that starts...

Peso,

I was interested enough in your idea, I tried the following: (note the result: 1 comes before 001).

[font="Courier New"]create table #T (pk int not null primary key identity, dat varchar(10))

insert...

I use something like

[font="Courier New"]'type filename.txt > a.txt'[/font]

** NOT ** [font="Courier New"]'type filename.txt' > a.txt [/font] as in "greater than"

Thumbs Up:

1. HAL - Odyssey 2001

2. Colossus: the Forbin Project

3. Star Trek, original series: the weapon which still keeps destroying everything it can find, even after destroying its own world....

-> ak

Posting the DDL to create the table is only part of the groundwork required to help us help you.

You must also add some test data and show what the...

-> R. Van Laake

ak started a new thread to elaborate on your work, as suggested by Peso.

I also suggest using aliases for your table names. If all the names begin with "RRSIN", then you can make the code less verbose -- I would have to verify...

would like to comment on one reply:

A bigint gives you 16 hours a day to schedule appointments for your salesmen. If that is not enough time, then your company...

Leading commas ...

Always hated them myself but did not condemn the style, it did LOOK easier to comment out some lines while debugging.

Not that this was a problem with...

There is an SQL command to do what you want, as has already been answered.

It is just that you have to understand the key concept, which I show below with...

Lakh: 10 exp 5 (100, 000).

In India, there is:

[font="Courier New"]

. thousand (10 exp 3),

. lakh -- 100 thousands (10 exp...

I do not remember where, but apparently CDOSYS is better than CDONT.

You can also use CDOSYS (Collaborative Data Objects).

You can find detail code example at http://www.sqlservercentral.com/Forums/Topic527864-110-1.aspx

One point worth...

You will not go very far if you do not master the join construct.

I suggest you start with

How to use the LEFT vs. RIGHT OUTER JOIN in SQL

[font="Courier New"]http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1286374,00.html#[/font]

How to...

You can also use CDOSYS (Collaborative Data Objects).

You can find detail code example at [font="Courier New"]http://www.sqlservercentral.com/Forums/Topic527864-110-1.aspx[/font]

One point worth mentioning: this does NOT that Outlook be installed and running on the...