http://p2p.wrox.com SQL Language discussions not specific to a particular RDBMS program or vendor. en Sat, 21 Nov 2009 23:46:23 GMT vBulletin 60 http://p2p.wrox.com/images/misc/rss.jpg http://p2p.wrox.com http://p2p.wrox.com/sql-language/77042-max-value-groupby-query.html Sun, 15 Nov 2009 17:24:45 GMT Hi, I have this table named Sales with this data Table: Sales ------------------ Salesman Amount -------------------- Ben 1 Hi,

I have this table named Sales with this data


Table: Sales
------------------
Salesman Amount
--------------------
Ben 1
Steve 2
Ben 3

then i do this query

select Salesman, sum(amount) as Total
from Sales
group by Salesman

the results are

---------------------
Salesman Amount
---------------------

Ben 4
Steve 2


The query i want is one that gives me the maximum amount of sales (4).

I have tried this, but it is wrong


select max(Total) from
(select Salesman, sum(amount) as Total
from Sales
group by Salesman)


I am using microsoft SQL Server 2005

thanks in advance! ]]> SQL Language diegoblin http://p2p.wrox.com/sql-language/77042-max-value-groupby-query.html http://p2p.wrox.com/sql-language/76888-coping-data-db-another-diff-server.html Tue, 03 Nov 2009 20:58:41 GMT Need help. On server x I have a large SQL server 2000 database (Call it A) with a very large amount of daily transactions. The database X only... Need help.

On server x I have a large SQL server 2000 database (Call it A) with a very large amount of daily transactions. The database X only holds 6 months worth of data the rest is archived to tape. We keep only six months of data so the performance of the application is not affected.


On Server y I have a copy of database A (Call it database B) in SQL SERVER 2008. I would like to add new records and modified records that occur on database A on serer x to accumulate in database B on server Y so we can have 2 years of data for reporting purposes only. Having close to real time changes and inserts of new records would be preferred.

How can I accomplish this?

Thanks
Eric ]]> SQL Language eapranger http://p2p.wrox.com/sql-language/76888-coping-data-db-another-diff-server.html http://p2p.wrox.com/sql-language/76878-implicit-conversion-error-alter-column.html Tue, 03 Nov 2009 14:29:48 GMT I have code that generates the following SQL statement: ALTER TABLE SurveyResults598 ALTER COLUMN Q13810 REAL Q13810 is currently defined as a... I have code that generates the following SQL statement:

ALTER TABLE SurveyResults598 ALTER COLUMN Q13810 REAL

Q13810 is currently defined as a DATETIME column. I accept that data is likely to be lost or rendered useless but I still need to change the column from a DATETIME type to a REAL type. When I run it, I get this error:

Implicit conversion from data type datetime to real is not allowed. Use the CONVERT function to run this query.

Note that I am able to successfully convert REAL to DATETIME without causing this error. And I can go both directions between VARCHAR and REAL. Only DATETIME to REAL is causing this.

So, how do I specify a conversion such as this error suggests to change a column DATA TYPE from DATETIME to REAL? ]]> SQL Language Ron Howerton http://p2p.wrox.com/sql-language/76878-implicit-conversion-error-alter-column.html