Recent content by AWithers

Hi does anyone know of a way around linking a db2 table with lots of indexes. I have a particular table that wont link and the error I get says it cannot link because the table has too many indexes Thanks Andy

Then its a little more complicated SELECT DISTINCT (SELECT Max(tablename.price) AS MaxOfprice FROM tablename WHERE tablename.qty<=[quantity])*[quantity] AS EstCost FROM tablename;

Unless I'm missing something where qty >=400 and <600 Andy

Dont think that will work. in the company table the products are different columns, in the grouping table the products are represented as rows of data

I am trying to create a fleixble (table driven) aggregation query and would appreciate your assistance. I have a table fo revenue values which I need to be able to simply group and change the groupings (without having to change the underlying SQL) any ideas? e.g I have a table contaning...

We created a system using sql asp and crystal reports. It does all you are after. You will need to purchase the crystal reports server software which is quite expensive to serve reports (in pdf format) to users but whole thing works very well Hope this helps Andy

might be a connection time out issue...i.e. the lenght of time required to execute all unioned expressions is too long Andy

need to build up the sql then execute it in asp code or create a stored procedure in sql server and execute that passing it the string of characters ntered by the usere.g. CREATE procedure ET_SP_ClientList @client varchar(50) ='%'--default value, returns all as select ClientName from...

I found GingerRs post very helpful I added the code environ(&quot;Username&quot;)to the default value in my table, saves coding all relevent forms etc. Andy

you need to join the tables and create an unmatched query something like insert into #tblAdd ( ItemNum, totQty, ManagerNum, BasePrice) select F.ItemNum, F.totQty, F.ManagerNum, F.BasePrice from #tblFin F left outer join #tblAdd A on f.itemNum = A.itemnum where...

triggers are created on tables what you might actually need is a stored procedure which will allow you to update data in tables What are you trying to update? Andy

Have you looked at the indexes on the underlying tables? otherwise you might want to try and write the same query in a different way e.g. using joins rather than sub queries or vice versa Andy

You can use DTS (Data Transfromation Services)from Enterprise Manager. I think this should create you a sample script which you can then reuse or adapt as necessary Andy

Another way would be to create a table based on your current table (design only) and then insert the value in the text field(dept name), all numerical fields whould then be based on the default which you could set to 0 HTH Andy

The main difference between enterpise manager (EM) and query analyzer (QA) is that EM presents you with a more user-friendly interface. As you are probably aware it is simple to add tables, define joins, select fields to return, add criteria(very similar to the Query by example grid available...