try,

SELECT Company.[Company Name], DailyStockPrice.Date

FROM Company LEFT OUTER JOIN DailyStockPrice ON Company.[Ticker] = DailyStockPrice.[Ticker]

WHERE DailyStockPrice.Date IS NULL

GROUP BY Company.[Company Name], DailyStockPrice.Date;

There are thousands of websites that provide .net tutorials

check out MSDN for some walk-throughs.

http://msdn.microsoft.com/en-gb/default.aspx

it really depends on how much experience you have..

Don't use RDO, i am sure this is no longer supported, use ADO.NET

as for the pages, i would use ASP (either c# or vb.net) and run these from IIS.

you...

to find the name that has the highest average moneyx use;

SELECT TOP 1 namex,AVG(moneyx) AS MoneyXAvg

FROM [Temp]

GROUP BY namex

ORDER BY MoneyXAvg DESC

This not always accurate, all this has been discussed in...

create table #rowcount (tablename varchar(128), rowcnt int)

exec sp_MSforeachtable

'insert into #rowcount select ''?'', count(*) from ?'

select * from #rowcount

order by tablename

drop table #rowcount

This is kind of a hard question to answer without a bit more detail,

What does your table look like?

how are you accessing the database?

What are the business rules surrounding transactions...

Rishi (12/10/2008)

---

Paul,

I am aware that it can be done using trigger, but dont know how to write a trigger as I have never done it before and I am weak...

You won't need to change the collation at all.

The reason it is not storing unicode is because you are not passing the string as Unicode.

add the leading unicode N before...

then...

The connection has been denied The reasons are either;

the databse does not exist ( check that it does and that you have the name correct)

the user does not...

You can modify the stored procedures that you use to access the data to use an audit table.

Yes you can;

you can setup an audit table and use triggers to populate this table when changes are made.

Or if you are using stored procs to access your data, you...

gm.mittal (12/10/2008)

---

most of the time client will not be connected to the main server. Therefore we have local SQL server on every machine with Access as its front end. So...

SQL server should really be installed on a Server and all the client machines should then access this server. Setting up local copies of SQL server and then using...