Since everyone is telling me to use storeprocedures, I might start converting my pages..

Good for you

There is no concept of row order in an SQL Table (SET). If you need them in certain order, add an order column and when you perform a select use...

Frank I ran you code in SQL 2000 and is working as per BOL!

if you run your last inserts as

insert into rp_work3(type,new_posting_key, currdate) values ('T',@@DBTS, '7/18/2005')

insert into rp_work3(type,new_posting_key, currdate)...

Rajesh,

If you are going to use only one grid why do you need the record count in a compute by?

or is it that the record count should be another column?

>> I have tried rollup, but the output has extra records for null case. <<

You can filter those out in your Where Clause

>>cant we...

it is not very difficult to work with more than one result set just make sure that when you are done with one you call NextRecordSet from the ADO recorset...

I'm not sure you can do an Insert + Select in the same SQL connection.

Yes it is called a batch! And I would suggest you put that logic in a...

Henrik,

1) While I strongly agree with you in general this is the exception. If I hadn't used generic functions/stored procedures in this project the number might have risen from the...

why nobody advised me for that?

Well what you are doing is undocummented!

You say that it works like a charm but right off the bat I can tell you that you...

SELECT

  Substring([ext_tags], Charindex('@1@',[ext_tags],1)+3, Charindex('~1~',[ext_tags],1) - Charindex('@1@',[ext_tags],1)+3) AS Field1

, Substring([ext_tags], Charindex('@2@',[ext_tags],1)+3, Charindex('~2~',[ext_tags],1) - Charindex('@2@',[ext_tags],1)+3) AS Field2

, Substring([ext_tags], Charindex('@3@',[ext_tags],1)+3, Charindex('~3~',[ext_tags],1) - Charindex('@3@',[ext_tags],1)+3) AS Field3

, Substring([ext_tags],...

I am not a Crystal Reports expert but I am positive that you can use Stored procedures with it!

Galahad,

It is ok if you want to leave it like that but I think it may be easier if you create a view with the thefinition of the original query...

Well Some (not all ) of my knowledge come from some interesting chanllenges that everyonce in a while pop up in user forums like...

Unfortunately this query

Delete Dups

where pk in (-- Get the max pk of each dup

             select max(a.pk)

             from dups a

             join dups b on a.foo = b.foo

             where a.pk...

>>.. none of them however have any sorting ability <<

I have to differ on that one In "Mainatining Hierarchies" you have a "level"  and a "path" columns therefor if you...