BOL should have samples for C++ and ADO

my thinking is you can use the outlook programming model so you could probably use the .net runtime. create a dll which has the outlook calendar objects etc.. and add...

as an IT contractor, i find that I can keep my skills upto date by responding to peoples queries when the current contract does not use a lot of the...

oh well there is something to learn everyday

probably won't help much, but can you post a bit of the schema.

why?? I have never seen a case... being used in an Order by.

if you want to do that stuff the way you want i think you are better off...

the functionality you want is a function of the frontend controls, you might consider getting a hierachical datagrid or something along those lines like Infragistics.

but as for the sql, the...

probably a dumb question but is your DATASET a .net dataset or a set of data?

first find out why you can't override the tables. what error message are you getting etc.

to copy your tables you can either write your own sql or use of the...

so what worked?

never compare your column values to null because null is not necessarily equal to null

anyway try to change your code like so

IF @HamTeamsID is null SET @HamTeamsID = 0

IF...

its a good kind of bashing because it shows people want to help you . maybe we should have a status on posts to denote...

are you not using an order id, can't you use that to get the last orders?

as for your script try to alias your sub query i.e.

SELECT createdate AS ShipDate, TrackingNumber

FROM (SELECT...

you can also have a look at your query execution path, to see were you can optimize

SELECT TOP 2 createdate AS ShipDate, TrackingNumber

FROM shipments

WHERE a.customerid = 'dmo-con'

ORDER BY createdate desc

what errors are you getting when using the sub query?